Udayan Sil
Solutions Architect @CitiusTech
Signup · Get unlimited contacts
WORK HISTORY
Solutions Architect @CitiusTech
Mumbai, IN
Project & Assignment DescriptionClient is a nonprofit health care company and/or investor in more than 20 healthcare companies in the U.S.As Solution Architect my responsibilities included:1) Work with onshore client to understand their data strategy and implement the same.2) Build prototypes, solutions to create the final architecture of the DWH.3) Setup team to run as Agile project and implement Snowflake as the datawarehouse.4) Create technical documents as per client requirements sessions.5) Learn and implement Snowflake database and DBT Tool6) Work with leadership to leverage the knowledge gained from this implementation to identify the learnings for future project setup where similar needs are envisioned for better client engagement.
EDUCATION
New English School, Kalwa
High School, Matriculation
K. J. Somaiya Institute of Technology
Engineer’s Degree, Information Technology
South Indian Education Societys College of Arts Science and Commerce Sion West Mumbai 400 022
High School, Science
SKILLS
ABOUT UDAYAN SIL
I have more than 12 years of experience as Informatica ETL, DWH and Data Quality Analyst with a good understanding of the Oracle PLSQL. I\'m currently H1B visa enabled with a valid visa till Jan 2024. I\'ve been involved in variety of ETL implementations like Data Migration, Data Reconciliation, Datawarehouse Build and Data Analytics. I\'ve built complex mappings, workflows, database objects, data profiles and scorecards. I have delivered successful results with multiple clients and my forte is working independently towards short term goals with quick results. Quick learner and never shy away from taking up new/challenging scope of work, I give my best to achieve the goals of my client. I\'m actively seeking full time opportunities for taking up new role in my career.Scope of work done:• Implemented Single Source of Truth/DWH solution on Cloud using Snowflake with Data Analytic capabilities.• Implemented Data Governance framework and Data Quality Strategies in SDLC management.• Established Data Quality processes in end to end implementations.• Extensive Data Profiling work done on client data.• Involved in 8 Informatica/PL SQL implementations.• Lead 2 end to end Data Quality implementations.• Performed Data Cleansing operations on client data.• Lead end to end delivery of Predictive Data Analytics efforts. • Extensive experience in client interactions for understanding business processes.KEY SKILLS/TOOLS USED• Informatica Powercenter 10.1.1(ETL Tool)- Informatica Certified Specialist• Informatica Analyst (Data Quality Tool)• Informatica Developer Big Data Edition 10.0.1(ETL tool)• Oracle PL SQL• SQL / Postgresql• Amazon Redshift
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.