Informatica IDMC/MDM Consultant

Allata; Dallas (TX); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Restaurant availability

Job summary

Allata is seeking a Senior Informatica IDMC MDM Consultant to lead design, implementation, and support of enterprise Master Data Management (MDM) solutions using Informatica IDMC SaaS in production environments.

The role includes designing Person/Contact and Member/Account domains, configuring survivorship and golden-record rules, and publishing data via Kafka and REST APIs to downstream systems. Strong experience with CDI, CDQ, CAI, and Databricks is required.

Qualifications

• 7+ years of enterprise Master Data Management experience.

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.
• Publish master data through Kafka, REST APIs, databases, and other downstream integration channels.
• 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.

Skills

MDM design

SaaS IDMC

Data governance

Relational databases

Batch and API integrations

Event-driven architectures

Client-facing communication

Tools

Informatica IDMC

CDI

CDQ

CAI

Databricks

Kafka

REST APIs

Job description

Allata is a global consulting and technology services firm founded in 2016, with 350+ employees across the US, India, and Argentina. We partner with some of the world's largest enterprises to move AI from idea to production — building intelligent agents, data foundations, and governance frameworks that scale.

Our teams work at the intersection of strategy, engineering, data, and design, helping clients modernize their technology, unlock data value, and create meaningful digital experiences. At Allata, you'll join an agile, cross-functional team that works closely alongside clients — making a real impact and building lasting partnerships.

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 Intelligent Data Management Cloud (IDMC).

This role will be responsible for implementing and managing 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 IDMC MDM SaaS in production.

• 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.

• 7+ years of 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 modeling, and data governance.

• 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.

• Ability to identify, communicate, and mitigate risks and issues effectively.
• Strong communication skills in English, both written and spoken.
• Strong time management and organizational skills.
• Proactive mindset and ownership of technical challenges.
• Ability to work effectively in collaborative, client‑facing environments.

At Allata, we value differences.

Allata is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.

Allata makes employment decisions without regard to race, color, creed, religion, age, ancestry, national origin, veteran status, sex, sexual orientation, gender, gender identity, gender expression, marital status, disability or any other legally protected category.

This policy applies to all terms and conditions of employment, including but not limited to, recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.