Informatica MDM Production Support Engineer || Plano, TX

Role: Informatica MDM Production Support Engineer

Location: Plano, TX (Onsite, rotational Weekend Shift)

Duration: Long Term Contract

 

Role Descriptions:

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 analyse 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. 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 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.

 

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.

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 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.

•       Education Requirements: Bachelors in Computer Science or other related field

 

 

Thanks & regards, Sonu Chauhan Sr. Technical Recruiter

571-678-0927  sonu.chauhan@1rpo.net