Informatica MDM Architect - Hybrid

Position: Informatica MDM Architect

Location: Charlotte, NC (Hybrid)

Duration: Long-term

Technical Skills

• Informatica MDM Hub Match, Merge, Trust, Survivorship, Hierarchies
• Good experience with ETL tools: Informatica PowerCenter, IDQ, and IICS preferred
• Strong expertise in Oracle relational databases
• Proficient in LINUX OS environment Shell Scripts

Required Skills

• Proven experience in an Architect role within Informatica MDM implementations Mandatory
• Strong understanding of MDM match, merge, survivorship, and consolidation logic Mandatory
• Hands-on experience with BES SIF and user exits Mandatory
• Proficiency in Core Java and Java web services Mandatory
• Experience in SQL and Oracle stored procedure development Mandatory

Key Responsibilities

• Architect and implement MDM solutions with a focus on Match Merge Deduplication and data consolidation
• Design and manage data flows from IDQ to MDM and onward to publish layers
• Configure and integrate Business Entity Services BES and Service Integration Framework SIF
• Develop and manage user exits for custom business logic and data handling
• Lead development of Core Java and Java web services for MDM integration
• Analyze and optimize Oracle stored procedures for data manipulation and extraction
• Build and refine complex SQL queries to meet business data requirements

Skills

Mandatory Skills: INFORMATICA-MDM