Informatica MDM Architect

Job Title: Informatica MDM Architect

Location: Charlotte, NC

Job Summary

Seeking an experienced Informatica MDM Architect to architect, design, and implement Master Data Management (MDM) solutions with a focus on data quality, match and merge processes, deduplication, data consolidation, and enterprise integrations.

Key Responsibilities

• Architect and implement Informatica MDM solutions with a focus on Match & Merge, deduplication, and data consolidation.
• Design and manage data flows from Informatica IDQ to MDM and downstream 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 activities involving Core Java and Java-based web services for MDM integration.
• Analyze, develop, and optimize Oracle stored procedures for data manipulation and extraction.
• Build and refine complex SQL queries to support business and data requirements.
• Collaborate with stakeholders to ensure scalable and efficient MDM architecture and implementation.

Required Skills

• Proven experience in an Architect role within Informatica MDM implementations.
• Strong understanding of MDM Match & Merge, survivorship, and consolidation logic.
• Hands-on experience with BES, SIF, and user exits.
• Proficiency in Core Java and Java web services.
• Experience in SQL and Oracle stored procedure development.
• Expertise in:
• Informatica MDM Hub
• Match & Merge
• Trust and Survivorship
• Hierarchies
• Experience with ETL tools:
• Informatica PowerCenter
• Informatica Data Quality (IDQ)
• Informatica Intelligent Cloud Services (IICS) preferred
• Strong expertise in Oracle relational databases.
• Proficiency in Linux operating systems and Shell scripting.

Preferred Skills

• Experience with Informatica Intelligent Cloud Services (IICS).

Qualifications

• Demonstrated experience designing and delivering enterprise-scale Informatica MDM solutions.
• Strong technical expertise in Informatica MDM architecture, integration, and data management best practices.
• Ability to develop and support complex database solutions using Oracle, SQL, and stored procedures.

Mandatory Skills

• INFORMATICA-MDM

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law.

https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf