What are the responsibilities and job description for the Lead Informatica Engineer position at Ventures Unlimited?
Job Details
Lead Informatica Data Engineer
- 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
