What are the responsibilities and job description for the Lead Informatica Data Engineer position at Ztek Consulting?
Job Title: Lead Informatica Data Engineer
Location: Owings Mills, MD
Type of hire: Full-time
• 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 : $140,000
