Informatica MDM Engineer - MDM Hub Console(DID or SIF)

METRIX IT SOLUTIONS INC; Plano (TX); On-site; USD 110,000 - 145,000; Full time

Job summary

METRIX IT SOLUTIONS INC is seeking an Informatica MDM Engineer to manage the MDM Hub Console, IDD/SIF rules, and provisioning tools. The role requires SQL proficiency (Oracle), UNIX scripting, and experience with Dynatrace, Autosys, and IBM Sterling Integrator for end-to-end data management.

You will monitor real-time and batch interfaces, troubleshoot data loading errors, and collaborate with data stewards to ensure governance compliance across platforms.

Qualifications

• Strong experience in Informatica MDM Hub Console 10.5 and IDD/SIF.
• Proficiency writing SQL for Oracle DB analytics and troubleshooting.
• Experience with Dynatrace, Autosys, and MFT scheduling tools.
• Familiarity with REST/SOAP APIs and ETL tooling.
• Experience with batch job monitoring and data governance alignment.

Responsibilities

• Monitor and troubleshoot MDM data loading and batch jobs daily/weekly/monthly.
• Analyze incidents, perform RCA, and implement permanent fixes.
• Collaborate with stakeholders to ensure data governance alignment.
• Analyze large datasets to detect anomalies and duplicates.
• Maintain real-time and batch interfaces between MDM and spoke systems.

Skills

Informatica MDM

SQL queries

UNIX scripting

Dynatrace

Autosys

MFT

IDQ10.5

SIF

PUTTY

Spring Boot

PowerCenter Admin

Python

Tools

IBM Sterling Integrator

REST API

Oracle DB

Job description

Position: Informatica MDM Engineer - MDM Hub Console(DID or SIF)

Contract

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. Dynatrace - Working experience in settingup | debugging issues using Dynatrace | familiarty with DQL must have Autosys and MFT: Experienced in third party scheduling tool like Autosys| and file transfer tools like IBM Sterling Integrator. Springboot( able to debug Microservice issues)|Informatica Power Center Admin 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 toolsBasic scripting skills (PowerShell| Python| or similar) for automation of routine support tasks. Top 3 Preferred QualificationsHands-on experience with the Informatica MDM /ETL /IDQDomain experience in auto finance| commercial finance| or captive financeunderstanding of loan/lease lifecycle| funding| billing| and collections.Experience working in an onshore/offshore delivery model with distributed teams across time zones.Ability to interpret and write SQL queries for data investigation and validation.Understanding of REST/SOAP API concepts for troubleshooting integration issues.Familiarity with incident and change management tools (ServiceNow| Jira| or similar).Strong client-facing communication skills; able to translate business issues into technical actions.Ability to manage multiple priorities independently in a fast-paced AMS environment.

Essential 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.Dynatrace - Working experience in settingup | debugging issues using Dynatrace | familiarty with DQL must haveAutosys and MFT: Experienced in third party scheduling tool like Autosys| and file transfer tools like IBM Sterling Integrator.Springboot( able to debug Microservice issues)|Informatica Power Center AdminMonitor 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 Basic scripting skills (PowerShell| Python| or similar

Top 3 Required 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.

• Dynatrace - Working experience in settingup , debugging issues using Dynatrace , familiarty with DQL must have

• Autosys and MFT: Experienced in third party scheduling tool like Autosys, and file transfer tools like IBM Sterling Integrator.

• 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

•Basic scripting skills (PowerShell, Python, or similar) for automation of routine support tasks.