Role Overview:This role involves monitoring, troubleshooting, and maintaining Master Data Management (MDM) batch jobs and data interfaces. The engineer will be responsible for resolving data pipeline failures, identifying issues, and implementing proactive fixes for recurring production incidents. Collaboration with business stakeholders and data stewards is essential to ensure data governance alignment.
Key Responsibilities:- Monitor daily, weekly, and monthly MDM batch jobs for data loading and synchronization, resolving data pipeline failures, and identifying issues.
- Troubleshoot and fix issues/incidents related to data, failed batch jobs, data loading errors, and user-reported bugs.
- Analysis (RCA) of recurring production incidents and implement permanent, proactive fixes to prevent recurrence.
- Collaborate with business stakeholders and data stewards to understand data requirements and ensure alignment with data governance policies.
- Analyze large data sets to detect anomalies, data errors, and duplicates in the system. Prepare processes for data corrections in MDM.
- Monitor and maintain real-time and batch data interfaces between the MDM and its spoke systems using APIs, REST/SOAP services, SIF API, or IDQ /ETL tools.
Required Skills:- Informatica: Strong experience in Informatica MDM Hub Console, IDD, SIF, Match/Merge rules, provisioning tool, and putty.
- SQL: Proficient in writing SQL queries (Oracle DB) for data analysis and troubleshooting.
- Autosys and MFT: Experienced in third-party scheduling tools like Autosys, and file transfer tools like IBM Sterling Integrator.
- Tools: Familiarity with ServiceNow or JIRA for incident tracking.
- Problem-Solving: Ability to troubleshoot and resolve complex technical issues under SLA.
- Communication: Strong verbal and written communication skills to interact with both technical and business teams.
Qualifications:Preferred Skills:- Informatica MDM Hub Console 10.5
- IDQ 10.5
- UNIX Shell scripting knowledge for analyzing scripts for IDQ or MDM job failures.
