Informatica Production Support Engineer

Tata Consultancy Services Ltd

  • Plano, TX
  • 17 days ago
  • $100,000–$125,000 Per Year

Highlights

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. Autosys and MFT: Experienced in third party scheduling tool like Autosys, and file transfer tools like IBM Sterling Integrator.

Numbers & Facts

LocationPlano, TX
Salary$100,000–$125,000 Per Year

Description

Role: Engineer

Required Skills: Informatica

Qualification: BACHELOR OF COMPUTER SCIENCE

Experience: 10 - 12 Years

Function: TECHNOLOGY

Apply By: 2026-10-23

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

Similar Jobs