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.
- Solid problem-solving, analytical, and communication skills.
- Ability to manage critical production incidents independently.

📌 Informatica DEI Support Lead (Mumbai)
🏢 Smart Analytica
📍 Mumbai