Informatica MDM Architect

Job Title: Informatica MDM Architect

Location: Charlotte, NC( Onsite)

Type: Contract

Need: ITAR Compliance

Informatica MDM Architect

Technical Skills

• Informatica MDM Hub, including match and merge, trust, survivorship, and hierarchy management.
• Experience with ETL and data-quality tools, preferably Informatica PowerCenter, Informatica Data Quality (IDQ), and Informatica Intelligent Cloud Services (IICS).
• Strong expertise in Oracle relational databases.
• Proficiency in Linux environments and shell scripting.

Required Skills

• Proven experience as an architect in Informatica MDM implementations.
• Strong understanding of MDM match and merge, survivorship, and consolidation logic.
• Hands-on experience with Business Entity Services (BES), Service Integration Framework (SIF), and user exits.
• Proficiency in Core Java and Java web services.
• Experience in SQL and Oracle stored-procedure development.

Key Responsibilities

• Architect and implement MDM solutions focused on match and merge, deduplication, survivorship, and data consolidation.
• Design and manage data flows from IDQ to MDM and onward to publishing layers.
• Configure and integrate Business Entity Services (BES) and the Service Integration Framework (SIF).
• Develop and manage user exits for custom business logic and data handling.
• Lead the development of Core Java applications and Java web services for MDM integration.
• Analyse and optimize Oracle stored procedures for data manipulation and extraction.
• Build and refine complex SQL queries to meet business data requirements.

Mandatory Skill

• Informatica MDM