Overview
Skills
Job Details
Job Description
We are seeking a highly skilled Lead Informatica Engineer with strong experience in building and managing enterprise-scale data integration solutions. The role will focus on leading ETL design and implementation, optimizing performance, supporting production workflows, and managing critical data pipelines using Informatica tools and multiple database platforms.
Key Responsibilities
Design, implement, and manage ETL pipelines and data processing workflows using Informatica PowerCenter, PowerExchange, and IICS.
Shape data integration strategies across Data Warehouses, Data Marts, EDW, and ODS environments.
Lead the design and implementation of data marts and enable real-time integrations with open integration patterns.
Work with diverse database technologies including Snowflake, DB2, Postgres, and others.
Troubleshoot, resolve, and optimize performance issues, ensuring efficient data transfer and parallelism.
Provide support for ID management, Snowflake data shares, client and prospect data management.
Lead production support activities for Informatica jobs and resolve workflow issues.
Manage job execution, scheduling, monitoring, and incident resolution for failed or delayed workflows.
Collaborate with business and technical stakeholders in an Agile development environment.
Deliver clear and concise documentation and communication, both written and verbal.
Required Skills and Experience
10+ years of overall experience with strong knowledge of data warehousing concepts (DW, Data Marts, EDW, ODS).
7+ years of solid hands-on experience with Informatica: PowerCenter, PowerExchange, and IICS.
Expertise in Snowflake, DB2, Postgres, and other relational database platforms.
Proven experience in data modeling and performance tuning.
Strong production support background within Informatica workflows and scheduling tools.
Familiarity with Agile methodologies and stakeholder collaboration.
Excellent communication skills with the ability to explain complex solutions effectively.