MDM Architect

Droisys; Charlotte (NC); On-site; USD 140,000 - 180,000; Full time

Job summary

Droisys in Charlotte, NC seeks an experienced MDM Architect to lead enterprise data management initiatives. You will architect and implement MDM solutions focusing on match/merge, survivorship, deduplication, and data consolidation, integrating IDQ with MDM and publishing layers.

The role requires hands-on BES, SIF, and user exits, strong Core Java and web services, and extensive Oracle SQL. You will optimize stored procedures and build complex queries while collaborating with cross-functional

Qualifications

• Experience as an architect in Informatica MDM implementations.
• Strong understanding of MDM match, survivorship, and consolidation.
• 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.

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.

Skills

Informatica MDM Hub

Match & Merge logic

Deduplication & Survivorship

BES / SIF

Core Java

SQL & Oracle

Tools

Informatica PowerCenter

Informatica Data Quality (IDQ)

Informatica IICS

Oracle DB

Linux

Shell scripting

Job description

Droisys is an innovation technology company focused on helping companies accelerate their digital initiatives from strategy and planning through execution. We leverage deep technical expertise, Agile methodologies, and data-driven intelligence to modernize systems of engagement and simplify human/tech interaction.

Amazing things happen when we work in environments where everyone feels a true sense of belonging and when candidates have the requisite skills and opportunities to succeed. At Droisys, we invest in our talent and support career growth, and we are always on the lookout for amazing talent who can contribute to our growth by delivering top results for our clients. Join us to challenge yourself and accomplish work that matters.

MDM Architect

Location : Charlotte, NC

12+ Months

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.

Droisys is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. Droisys believes in diversity, inclusion, and belonging, and we are committed to fostering a diverse work environment.