Tata Consultancy Services
Lead Informatica Data Engineer
Must Have Technical/Functional Skills • Solid hands-on experience (7+ Years) with Informatica tools, including IDQ, PowerCenter, PowerExchange, 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
Salary Range- $125,000-$135,000 a year
#LI-NR3
Must Have Technical/Functional Skills • Solid hands-on experience (7+ Years) with Informatica tools, including IDQ, PowerCenter, PowerExchange, 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
Salary Range- $125,000-$135,000 a year
#LI-NR3