Lead Informatica Data Engineer

• Solid hands-on experience (7+ Years) with Informatica tools, including IDQ, PowerCenter, Power Exchange, IDMC implementing data pipelines and data processing.

• 10 years of total experience with good knowledge on DW concepts, Data marts, EDW and ODS

• Hands-on experience with designing and implementing data marts, ETL pipelines, real time integration with

open integration patterns. 

• Experience in using Snowflake, DB2, Postgres and other database technologies.

• Experiencing in fixing performance issues / parallelism, Data model exposure is a must.

• Experience in ID management, Snowflake data shares, Client and prospect data management.

• Experience with Agile methodologies and working with wide range of stakeholders across business and technology.

• Experience in supporting production and resolving client issues related to Informatica workflows.

• Familiarity in running/scheduling jobs, hosting, monitoring and analyzing job failure and fixing the same

• Excellent communication skills both written and verbal

Roles & Responsibilities

• Design, develop, modify, configure & debug Informatica workflows using Informatica PowerCenter and Power Exchange CDC tools

• leads the design, development, and maintenance of data integration solutions using Informatica, ensuring data quality 

• Troubleshoot and resolve technical issues. Debug, tune and optimize code for optimal performance

• Manage the new requirements, Review the existing jobs, Perform gap analysis & Fixing performance issues, etc.

• Document all ETL mappings, sessions and workflows

• Ticket handling and problem ticket analysis skills in Agile /POD approach