Description

You will lead the architecture, design, and implementation of complex Master Data Management (MDM) solutions to create single versions of truth and master indices.

Responsibilities

• Architect and implement end-to-end MDM solutions including data cleansing, ingestion pipelines, matching, merging, and hierarchy management.
• Design conceptual, logical, and physical relational data models such as party, client, or provider models.
• Develop and maintain integrations between MDM solutions and external systems using APIs, web services, and message queues.
• Configure data profiling, match rules, merge options, and trust rules within Informatica MDM and Data Quality products.
• Create technical documentation including data mappings, data dictionaries, lineage, and high-level/low-level designs.

Required Skills

• 10+ years of hands-on experience with Informatica MDM Hub, including MDM Hub Workbench, Informatica Data Director, and Provisioning Tool.
• 10+ years of experience building data models, landing tables, staging tables, and base objects in Informatica MDM.
• 10+ years of experience with Informatica MDM architecture, ActiveVOS, Customer 360, and Service Integration Framework (SIF).
• 7+ years of experience with Informatica PowerCenter or Informatica Data Quality for ETL processes.
• 7+ years of experience integrating MDM with systems via APIs, Web Services, JMS, ESB, and Kafka.
• 7+ years of experience working with high-volume OLTP and OLAP systems.
• 5+ years of experience with Erwin Data Modeler and advanced Oracle PL/SQL (stored procedures, functions, triggers, and complex joins).
• Proven experience in Architect roles for complex MDM projects.
• Domain knowledge in health and human services or Integrated Eligibility System programs.

Key Skills

Education

Not specified