Informatica MDM Developer with Dynatrace C2C jobs in TX

Tech Mirrors; Plano (TX); On-site; USD 120,000 - 170,000; Full time

Job summary

Tech Mirrors is seeking an Informatica MDM Developer with Dynatrace expertise in Plano, TX. The role requires extensive experience with MDM Hub Console 10.5, IDD, SIF, and advanced SQL for data analysis and troubleshooting. Onsite work is expected.

The candidate will monitor MDM batch jobs, diagnose data loading issues, and perform root-cause analysis to prevent recurrence, collaborating with stakeholders across data governance teams.

Qualifications

• Minimum 10+ years of experience.
• Strong Informatica MDM experience including Hub Console 10.5, IDD, SIF, and Match/Merge rules.
• Proficient in SQL queries (Oracle DB) for data analysis and troubleshooting.
• UNIX Shell scripting knowledge for analyzing IDQ/MDM jobs.

Responsibilities

• Monitor daily, weekly, and monthly MDM batch jobs and data loading.
• Troubleshoot data loading errors and batch failures; implement fixes.
• Perform RCA on production incidents and apply permanent solutions.
• Collaborate with business stakeholders and data stewards on data requirements.

Skills

Informatica MDM

IDQ

SQL

UNIX Shell

Dynatrace

Autosys

MFT

Spring Boot

Data Governance

Data Analysis

Tools

Informatica MDM Hub Console 10.5

IDD

SIF

IDQ 10.5

Dynatrace

Autosys

IBM Sterling Integrator

Informatica PowerCenter Admin

REST/SOAP APIs

Putty

Job description

Role- Informatica MDM Developer with Dynatrace

Location - Plano, TX (Onsite)

Job Type - C2C/W2

Job Description:

• Minimum 10+ years of experience.
• 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 setting up , debugging issues using Dynatrace , familiarity with DQL must have
• Autosys and MFT: Experienced in third party scheduling tool like Autosys, and file transfer tools like IBM Sterling Integrator.
• Spring boot (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 tools
• Basic scripting skills (PowerShell, Python, or similar) for automation of routine support tasks.

Top 3 Preferred Qualifications

• Hands-on experience with the Informatica MDM /ETL /IDQ
• Domain experience in auto finance, commercial finance, or captive finance - understanding 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.