Informatica DEI Support Lead

Job Description Informatica DEI Support Lead

Job Title: Informatica DEI Support Lead
Location: Mumbai
Experience: 7+ Years
Work Mode: 100% Work from Office (WFO)
Shift: 247 Rotational Shifts

Job Summary

We are looking for an experienced Informatica DEI Support Lead with 7+ years of IT experience and strong expertise in Informatica Data Engineering Integration (DEI/BDM), SQL, Unix Shell Scripting, and production support. The candidate will be responsible for managing critical data integration applications, troubleshooting production issues, ensuring smooth ETL operations, and leading support activities in a 247 environment.

Key Responsibilities

• Provide L2/L3 production support for Informatica DEI/BDM applications and ETL workflows.
• Monitor production jobs, troubleshoot failures, and ensure timely resolution.
• Perform root cause analysis (RCA) and implement preventive measures.
• Troubleshoot complex SQL queries, Unix Shell Scripts, and ETL workflows.
• Monitor and optimize ETL job performance.
• Support Hadoop ecosystem components, including Hive, HDFS, and Spark.
• Manage production incidents, escalations, and SLA compliance.
• Coordinate with development, infrastructure, and business teams.
• Lead support activities, mentor team members, and manage shift handovers.
• Maintain technical documentation and incident reports.
• Ensure smooth production operations across 247 rotational shifts.

Mandatory Technical Skills

• Strong hands-on experience in Informatica DEI / BDM.
• Strong SQL knowledge, including complex queries and troubleshooting.
• Hands-on experience in Unix/Linux and Shell Scripting.
• Experience in L2/L3 Production/Application Support.
• Strong understanding of ETL workflows, job monitoring, and troubleshooting.
• Experience in incident management, problem management, and RCA.
• Knowledge of the Hadoop ecosystem.
• Experience in team handling or technical leadership.

Good-to-Have Skills

• Apache Spark, Hive, and HDFS.
• ITIL processes and ServiceNow/Jira.
• Control-M or Autosys scheduling tools.
• ETL performance tuning and automation.

Qualifications

• Bachelor's degree in Computer Science, IT, or a related field.
• Minimum 7+ years of overall IT experience, preferably in ETL/Data Integration production support.
• Strong problem-solving, analytical, and communication skills.
• Ability to manage critical production incidents independently.