Informatica DEI Support Lead

Smart Analytica; Mumbai; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Smart Analytica INC. is seeking an experienced Informatica DEI Support Lead in Mumbai. The candidate will manage critical data integration applications, troubleshoot production issues, and lead 24/7 support operations in a 247 environment.

The role requires 7+ years of IT experience, strong DEI/BDM, SQL, Unix shell scripting, and prior production support leadership. 100% on-site work with rotational shifts.

Qualifications

• Bachelor's degree in Computer Science, IT, or related field.
• 7+ years of IT experience with emphasis on ETL/Data Integration production support.
• Strong hands-on knowledge of Informatica DEI/BDM and ETL processes.

Responsibilities

• Provide L2/L3 production support for Informatica DEI/BDM apps and ETL workflows.
• Monitor production jobs, troubleshoot failures, and ensure timely resolution.
• Perform root cause analysis and implement preventive measures.
• Troubleshoot SQL queries, Unix scripts, and ETL workflows.
• Monitor and optimize ETL job performance and SLA compliance.
• Coordinate with cross-functional teams and mentor juniors.

Skills

Informatica DEI/BDM

SQL

Unix/Linux

Shell scripting

Production support

ETL monitoring

RCA / Incident mgmt

Hadoop/Hive/Spark

Team leadership

Education

Bachelor's degree in CS/IT

Job description

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.