Informatica Production Support Engineer

Tata Consultancy Services; Plano (TX); On-site; USD 100,000 - 125,000; Full time

Job summary

Tata Consultancy Services in Plano, TX is seeking a senior Informatica/ETL engineer to manage MDM and data integration. You will monitor batch jobs, troubleshoot data loading issues, and collaborate with data stewards.

The role requires strong SQL, UNIX scripting, Dynatrace experience, and familiarity with Autosys, MFT, and REST/SOAP APIs. Knowledge of AWS, Docker, and Spring Boot microservices is a plus. Candidates should perform RCA and implement proactive fixes.

Qualifications

• Hands-on experience with Informatica MDM, ETL, and data integration.
• Strong SQL skills for data analysis and troubleshooting.
• Proficiency in UNIX shell scripting for automation and diagnostics.
• Experience with Dynatrace for performance debugging and DQL familiarity.
• Exposure to Autosys scheduling and IBM Sterling Integrator for file transfers.
• Knowledge of REST/SOAP APIs and containerized deployments (Docker).
• Understanding of data governance and data quality principles.

Responsibilities

• Monitor and troubleshoot daily/weekly/monthly MDM batch jobs and data pipelines.
• Diagnose data loading errors and user-reported bugs; apply RCAs and proactive fixes.
• Collaborate with data stewards to ensure governance alignment.
• Maintain real-time and batch data interfaces using APIs and ETL tools.
• Support DevOps activities and automate routine tasks with scripts.

Skills

Informatica MDM

SQL

Scripting (UNIX Shell / Python)

Dynatrace

Autosys

MFT / IBM Sterling Integrator

Springboot

Informatica Power Center Admin

REST/SOAP APIs

Docker

Jenkins CI/CD

AWS

React

AWS EKS / ELB

Data governance

Data analysis

Education

Bachelor of Computer Science

Tools

Informatica MDM Hub Console

IDQ

Dynatrace tooling

Job description

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


• Must Have 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.
  

Job Description

Must Have Technical/Functional 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.


• Must Have 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.
  

Roles & Responsibilities

Hands-on experience with the Informatica MDM /ETL /ID

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


• Strong experience with Jenkins CI/CD pipeline development and troubleshooting.


• Hands-on experie nce with Docker and containerized application deployment.


• Experience working with Artifactory.


• Practical knowledge of AWS cloud services.


• Experience with AWS EKS and ELB.


• Exposure to deploying React frontend applications and Java Spring Boot microservices.


• Good understanding of DevOps best practices, release management, and automation.
  

Salary Range: $100,000 to $125,000 per year

Qualifications:

BACHELOR OF COMPUTER SCIENCE