Lead Informatica MDM Integration Engineer

Employment Type: Permanent/Direct Hire

Compensation: $175k base/yr + Bonus & Benefits

Location: Remote

Job Overview:

We are seeking a highly skilled professional to lead the integration workstream for an enterprise Informatica SaaS MDM implementation. This role involves designing, developing, testing, and deploying integrations between enterprise applications, source systems, third-party platforms, and the MDM ecosystem using Informatica IDMC, IICS/IAC, CDQ, CDI, APIs, and related Informatica cloud services.

The role requires establishing integration architecture, development standards, and best practices while ensuring successful delivery across the project lifecycle. The individual will manage and mentor two offshore integration developers, providing technical guidance, code reviews, work allocation, and quality oversight.

Strong expertise in the Informatica platform is essential, with experience integrating data into and out of MDM environments. Experience with Snowflake and Airbyte is highly desirable.

Requirements:

• Lead the end-to-end integration workstream for an Informatica SaaS MDM implementation.
• Design, develop, test, and deploy data integrations using Informatica IDMC, IICS/IAC, CDQ, CDI, and related Informatica cloud services.
• Build and maintain integrations between enterprise source systems, applications, APIs, MDM, and downstream data platforms.
• Define integration architecture, patterns, reusable components, mapping standards, and development best practices.
• Design and implement batch, real-time, API-based, and event-driven integration solutions.
• Collaborate with business stakeholders, MDM architects, data stewards, business analysts, and source system teams to understand requirements and deliver solutions.
• Partner with data quality and MDM teams to ensure accurate, trusted, and governed master data.
• Develop and document source-to-target mappings, transformation logic, error handling, and reconciliation processes.
• Monitor and troubleshoot integration pipelines and resolve production issues as needed.
• Conduct code reviews and provide technical leadership and mentorship to two offshore integration developers.
• Support project planning, estimation, sprint execution, testing, deployment, and hypercare activities.
• Ensure integrations comply with enterprise security, governance, and operational standards.

Preferred Qualifications:

• 10 years of hands-on experience with Informatica technologies, including IDMC, IICS, IAC, CDI, CDQ, and MDM platforms.
• Proven experience leading integration development efforts on large-scale enterprise implementations.
• Strong understanding of enterprise integration patterns and architectures.
• Experience building integrations using REST APIs, web services, file-based interfaces, and message-based integrations.
• Strong SQL skills and experience with data transformation, profiling, validation, and reconciliation.
• Experience working with Agile implementation methodologies.
• Demonstrated ability to leverage AI tools to enhance productivity, streamline workflows, and support data-informed task execution.
• Familiarity with AI-enhanced platforms is a plus.
• A solid understanding of AI capabilities and limitations including ethical considerations is expected.
• Demonstrated ability to lead technical teams and coordinate offshore resources.
• Strong analytical, troubleshooting, and communication skills.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field.
• Flexibility to work across different US time zones and travel if needed (up to 25%).