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.
Skills Required
- 7+ years of enterprise Master Data Management experience.
- 3+ years of recent hands-on Informatica Multidomain MDM SaaS (IDMC) experience.
- 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.
What We Do
Allata (pronounced a-ley-ta) is a strategy, architecture and enterprise-level application development company focused on helping clients enhance or scale business opportunities, create efficiencies and automate processes through custom technologies. We are building a different kind of firm – focused on doing exciting, transformational work for great clients and bringing caring and dedicated people to make our clients goals a reality. Our vision is to build an energized group of talented professionals that can stand strong on their own but work better as a networked team. We enable business agility at the intersection of people, process, and technology. We provide solutions and expert services to assist businesses to become more nimble, transformative, and disruptive in their respective industries. We define vision, strategy, and value creation models for shaping strategic product designs, managing, and transforming enterprise delivery. Just as strongly as we care about our clients, we feel that it is important to give back to the community and non-profits that we are passionate about. Every month, Allata donates 2% of our net income to a charitable cause our team believes in. We live by our mantra: Family comes first, clients are king, we take great care of our people.
