Informatica IDMC/MDM Consultant
Summary
Design and implement enterprise Master Data Management solutions using Informatica IDMC/MDM SaaS, including domain modeling, data integration, and Kafka-based event streaming for downstream systems.
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.
Role & 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.
Hard Skills - Must have:
- 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.
Hard Skills - Nice to have / It's a plus:
- 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.
Soft Skills:
- 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.