Location: Plano Texas (Hybrid - 3 days onsite)
Role: MDM Analyst
Experience Required: 8-10 Years
The MDM Analyst is responsible for ensuring the health accuracy and availability of Master Data (Customer Vendor Product etc.) across production environments. This role acts as a bridge between data governance and technical support ensuring data quality resolving production issues and maintaining reliable data pipelines.
Provide Level 3 production support for MDM platforms (e.g. Informatica MDM).
Diagnose and resolve production incidents related to master data data quality and downstream data syndication.
Troubleshoot data-related issues such as failed batch jobs data load errors and user-reported defects.
Perform root cause analysis (RCA) and implement preventive solutions for recurring issues.
Coordinate with infrastructure database and application teams to resolve data pipeline failures.
Monitor daily weekly and monthly MDM batch jobs and data synchronization processes.
Analyze large datasets to identify anomalies duplicates and data quality issues.
Perform data cleansing matching merging and stewardship activities.
Investigate and correct data issues related to attributes such as cost location and product details.
Maintain operational runbooks SOPs and knowledge base documentation.
Document data mappings transformation logic and system configurations.
Work with business stakeholders and data stewards to align data management practices with governance policies.
Provide training and support to end users on MDM systems and data processes.
Develop and maintain real-time and batch integrations between the MDM hub and downstream systems using APIs REST/SOAP services or ETL tools.
Design and configure MDM components including landing tables staging tables base objects match & merge rules survivorship rules and trust configurations.
Design logical data models and implement data quality rules.
Perform data profiling and ensure high standards of data accuracy and integrity.
Hands-on experience with Informatica MDM
Advanced SQL for data analysis and manipulation
Strong problem-solving skills with production support experience in MDM systems
Informatica Data Quality (IDQ)
Experience with AWS
Unix / Linux or scripting knowledge
Experience with MDM platforms such as Informatica MDM
Strong knowledge of ETL processes and data integration
Experience with data profiling and data quality tools
Familiarity with Shell scripting or Python for automation