10+ years of total and relevant experience in Data modeling, Pipeline building in native AWS services (S3, Lambda, Glue, Snowflake, Snaplogic, Athena, PowerBI, etc)
7-10 yr of experience in Informatica ETL/ELT , Data warehousing and cloud databases including Snowflake
Provide application architecture, framework, design specification
Provide deployment plan and architecture etc. and collaborate with development teams and senior designers to develop architectural requirements to ensure client satisfaction with ETL Mappings.
Plan and conduct technical reviews
Review Hexaware deliverables and provide feedback on technical deliverables
Knowledge of AWS Lambda, Informatica IICS , Snowflake database.
Lead and guide development of an ETL architecture & ETL Mappings.
Responsible for ETL Mappings validation.
Understand the Data Flow and Guide Team for Mappings for Source to Target
Identify, recommend and implement ETL process and architecture improvements.