Oracle MDM Consultant

American IT Systems; Plano (TX); Hybrid; USD 110,000 - 165,000; Full time

Job summary

American IT Systems is seeking an Oracle MDM Consultant in Plano, TX with hybrid work options and occasional on-site visits. The role focuses on designing, implementing, and supporting Master Data Management to improve data quality, governance, and usability across enterprise systems.

You will work with stakeholders to define requirements, design data models, and implement MDM tools while coordinating with data governance and IT teams.

Qualifications

• Strong understanding of Master Data Management concepts and data governance.
• Hands-on experience with MDM tools, preferably Oracle.
• Knowledge of data modeling, hierarchies, survivorship, and golden records.
• Experience with APIs, ETL, message queues, and batch interfaces.
• Ability to translate business requirements into functional and technical specs.
• 5–10 years of relevant MDM or enterprise data management experience.

Responsibilities

• Gather and analyze MDM requirements across domains (customer, supplier, product, etc.).
• Design and support MDM solution architecture, data models, workflows, and data stewardship processes.
• Configure and implement MDM tools per project standards.
• Define data quality rules, validation checks, and remediation processes with teams.
• Support data profiling, cleansing, enrichment, migration, and consolidation efforts.
• Create functional specifications, technical docs, and process flows.
• Analyze data issues and coordinate root-cause resolution with relevant teams.
• Support integrations between MDM platforms and ERP/CRM/data warehouse systems.

Skills

MDM concepts

Data governance

Oracle MDM

Data modeling

APIs & ETL

Data quality

Documentation

Problem solving

Job description

Oracle MDM Consultant

Plano, TX- Hybrid Ocassional Visist to location

The MDM Consultant will be responsible for designing, implementing, and supporting Master Data Management solutions that improve data quality, governance, consistency, and business usability across enterprise systems. The role requires strong functional and technical understanding of master data domains, data governance processes, integration patterns, and stakeholder coordination.

Key Responsibilities

• Work with business stakeholders to gather, analyze, and document MDM requirements across domains such as customer, supplier, product, employee, or finance master data.
• Design and support MDM solution architecture, data models, workflows, match and merge rules, hierarchy management, and data stewardship processes.
• Configure and implement MDM tools and platforms based on project requirements and enterprise standards.
• Collaborate with data governance, business, integration, and application teams to define data quality rules, validation checks, and remediation processes.
• Support data profiling, cleansing, enrichment, migration, and consolidation activities.
• Develop and maintain functional specifications, technical documentation, process flows, data mapping documents, and operational support guides.
• Analyse data issues, perform root cause analysis, and coordinate resolution with relevant teams.
• Support integrations between MDM platforms and downstream or upstream systems such as ERP, CRM, data warehouse, and reporting platforms.

Required Skills

• Strong understanding of Master Data Management concepts, data governance, data quality, reference data, and metadata management.
• Hands-on experience with MDM tools such as preferably Oracle
• Good knowledge of data modelling, entity relationships, hierarchy management, survivorship rules, and golden record creation.
• Understanding of integration technologies such as APIs, ETL tools, message queues, and batch interfaces.
• Ability to translate business requirements into functional and technical specifications.
• 5 to 10 years of relevant experience in Master Data Management, data governance, data quality, or enterprise data management.
• Prior experience in implementation, enhancement, support, migration, or upgrade projects is preferred.