Requisition ID: 106418-1
Title:Senior Informatica MDM Engineer
Duration: 6-12 months with possible extension
Location: 655 Headquarters Drive, Plano, TX. 100% onsite. (rotational Weekend Shift)
Salary Range: $55- $60 an hour on W2/C2C
Job Description:
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 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 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.
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 toolsBasic 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.
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
" Years of Experience: 8-10 years
Appreciate your quick response and please feel free to reach me out for any query you may have.
Thanks