Description

Architect and implement end-to-end Master Data Management solutions to establish single versions of truth.

This role is on-site.

Responsibilities

• Design conceptual, logical, and physical relational data models for party, client, or provider hierarchies.
• Build and maintain data ingestion pipelines, including cleansing, matching, merging, and staging tables.
• Develop integrations with external systems using APIs, web services, JMS, ESB, and Kafka.
• Configure data profiling, match rules, merge options, and trust rules within Informatica MDM and Data Quality.
• Create technical documentation including data mappings, dictionaries, lineage, and high/low-level designs.

Required Skills

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

Preferred Skills

• Domain knowledge in health and human services or Integrated Eligibility System programs.

Key Skills

Education

Not specified