Master Data Management_Informatica at Dallas, TX

VOLTO Consulting; Dallas (TX); On-site; USD 100,000 - 130,000; Full time

Job summary

VOLTO Consulting is seeking a Master Data Management professional in Dallas, TX. The role involves monitoring and resolving batch job failures, and ensuring data governance through collaboration with stakeholders.

Applicants should have over 10 years of experience in MDM, proficiency in Informatica MDM Hub Console, and strong SQL skills for effective data analysis. Effective problem-solving and communication abilities are crucial for success in this role.

Qualifications

• 10+ years of experience in Master Data Management.
• Strong problem-solving skills in a technical environment.
• Excellent communication skills for technical and business interactions.

Responsibilities

• Monitor and fix MDM batch jobs and data pipeline failures.
• Collaborate with stakeholders to ensure data integrity.
• Analyze large data sets for anomalies and prepare corrections.

Skills

Informatica MDM Hub Console (10.5)

SQL queries (Oracle DB)

UNIX Shell scripting

Autosys

IBM Sterling Integrator

ServiceNow or JIRA

Tools

Informatica IDQ (10.5)

Putty

Job description

Role: Master Data Management_Informatica (MDM)

Location: Dallas, TX

Contract

Experience Required: 10 & Above

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.

Skills

• Informatica: Strong experience in Informatica MDM Hub Console 10.5 (good to have), IDD, SIF, Match/Merge rules, and provisioning tool, IDQ10.5 (good to have), putty.
• SQL: Should be good in writing SQL queries (Oracle DB) as this will be needed for data analysis and troubleshooting.
• Scripting: Good to have UNIX Shell scripting knowledge as this will be required to analyze scripts for any IDQ or MDM job failures.
• Autosys and MFT: Experienced in third party scheduling tool 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.