Job Summary
We are seeking an experienced Informatica MDM Architect to design, implement, and optimize enterprise Master Data Management (MDM) solutions. The ideal candidate will have extensive expertise in Informatica MDM Hub, Match & Merge, data consolidation, ETL technologies, Oracle databases, and Java-based integrations. This role will lead the architecture and implementation of scalable MDM solutions while ensuring data quality, consistency, and efficient integration across enterprise systems.
Key Responsibilities
• Architect and implement enterprise Master Data Management (MDM) solutions using Informatica MDM Hub.
• Design and implement Match & Merge, deduplication, survivorship, and data consolidation strategies.
• Design and manage data flows between Informatica Data Quality (IDQ), Informatica MDM, and downstream publish layers.
• Configure and integrate Business Entity Services (BES) and Service Integration Framework (SIF).
• Develop and maintain user exits to support custom business logic and data processing requirements.
• Develop Core Java applications and Java web services to support MDM integrations.
• Design, develop, and optimize Oracle stored procedures for data processing and extraction.
• Develop complex SQL queries to support business reporting and data management requirements.
• Collaborate with business and technical teams to deliver scalable, high-quality MDM solutions.
• Ensure adherence to enterprise architecture standards, data governance, and best practices.
Required Qualifications
• Proven experience as an Informatica MDM Architect.
• Strong expertise with Informatica MDM Hub, including Match & Merge, Trust, Survivorship, and Hierarchies.
• Experience with ETL tools such as Informatica PowerCenter, Informatica Data Quality (IDQ), and Informatica Intelligent Cloud Services (IICS).
• Strong expertise with Oracle relational databases.
• Experience configuring and integrating Business Entity Services (BES) and Service Integration Framework (SIF).
• Hands-on experience developing user exits within Informatica MDM.
• Strong proficiency in Core Java and Java web services.
• Experience developing SQL queries and Oracle stored procedures.
• Experience working in Linux environments with Shell scripting.
• Strong understanding of Master Data Management principles, data integration, and data quality best practices.
• Excellent analytical, problem-solving, and communication skills.
