MDM Analyst
Job Summary
Location: Plano Texas (Hybrid - 3 days onsite)
Role: MDM Analyst
Experience Required: 8-10 Years
Job Summary
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.
Key Responsibilities
Production Support & Incident Management
-
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.
MDM Data Operations & Analysis
-
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.
Change Management & Documentation
-
Maintain operational runbooks SOPs and knowledge base documentation.
-
Document data mappings transformation logic and system configurations.
Data Governance Collaboration
-
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.
Data Integration
-
Develop and maintain real-time and batch integrations between the MDM hub and downstream systems using APIs REST/SOAP services or ETL tools.
System Configuration
-
Design and configure MDM components including landing tables staging tables base objects match & merge rules survivorship rules and trust configurations.
Data Modeling & Data Quality
-
Design logical data models and implement data quality rules.
-
Perform data profiling and ensure high standards of data accuracy and integrity.
Required Skills
Top 3 Required Skills
-
Hands-on experience with Informatica MDM
-
Advanced SQL for data analysis and manipulation
-
Strong problem-solving skills with production support experience in MDM systems
Preferred Skills
-
Informatica Data Quality (IDQ)
-
Experience with AWS
-
Unix / Linux or scripting knowledge
Technical Competencies
-
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