Informatica IDMC MDM Consultant

Senior Informatica IDMC MDM Consultant

Experience: - Min 10 Years

Location: - Irving, TX (Hybrid 3 days WFO)

We are seeking a Senior Informatica IDMC MDM Consultant to lead the design, implementation, and support of enterprise Master Data Management (MDM) solutions using Informatica Multidomain MDM SaaS (IDMC).

This role will be responsible for implementing Person/Contact and Member/Account master data domains, building scalable data integration and data quality solutions, configuring match and merge rules, publishing golden records to downstream systems, and integrating with enterprise platforms using APIs and Kafka.

This is a hands-on engineering role requiring recent experience implementing Informatica MDM SaaS in production. Candidates with only Informatica MDM On-Prem, PowerCenter, or administration experience will not be considered.

Roles and Responsibilities

• Lead end-to-end implementation of Informatica Multidomain MDM SaaS (IDMC).
• Design and implement Person/Contact and Member/Account master data domains.
• Configure business entities, relationships, hierarchies, crosswalks, survivorship, trust, validation, and golden-record rules.
• Configure Business 360 Console, Reference 360, Cloud Data Integration (CDI), Cloud Data Quality (CDQ), and Cloud Application Integration (CAI).
• Develop batch, API-based, and event-driven integrations.
• Publish master data through Kafka, REST APIs, databases, and other downstream integration channels.
• Design Kafka topics, event schemas, message structures, retry, replay, reconciliation, and dead-letter handling.
• Build scalable data pipelines using Informatica CDI and integrate with enterprise data platforms including Databricks.
• Configure data stewardship workflows and duplicate management processes.
• Support security, RBAC, environment promotion, CI/CD, release management, and operational support.
• Troubleshoot production issues involving data quality, matching, integrations, publications, and performance.
• Create technical design documents and implementation artifacts.

Educational Qualifications: -

Engineering Degree BE/ME/BTech/MTech/BSc/MSc.

Technical certification in multiple technologies is desirable.

Skills: -

Mandatory skills

• Experience in enterprise Master Data Management experience.
• 3 years of recent hands-on Informatica Multidomain MDM SaaS (IDMC) experience.
• Successfully delivered at least one complete Informatica MDM SaaS implementation into production.
• Strong experience implementing Person, Customer, Member, Account, Organization, Contact, or Party domains.
• Experience integrating Informatica with Kafka or similar event-streaming platforms.
• Experience building enterprise data integration solutions using CDI, CDQ, and CAI.
• Strong understanding of relational databases, data modelling, and data governance.
• Informatica IDMC - Informatica Multidomain MDM SaaS, Business 360 Console, Cloud Data Integration (CDI), Cloud Data Quality (CDQ), Cloud Application Integration (CAI), Informatica Reference 360, Master Data Management
• Entity modelling - Match & Merge, Survivorship, Trust configuration, Golden, Record implementation, Crosswalk management, Relationship management Hierarchies, Data stewardship, Integration
• REST APIs, JSON, SQL, Kafka / Confluent, Event-driven architecture, Batch processing, Real-time integrations
• Cloud & Data Engineering, Databricks, Delta Lake, Azure, Azure Key Vault, Entra, ID / Azure AD, Python, CI/CD, Git / Azure DevOps

Nice to Have Experience with:

• Healthcare or Membership domain experience.
• Experience integrating Informatica IDMC with Databricks or enterprise Lakehouse platforms.
• Experience with Azure cloud services.
• Informatica IDMC certifications.
• Experience with AI-assisted development tools such as GitHub Copilot or Codex.