Track Lead - Extract Transform Load (ETL), Data Lakes (IN)

HCLTech

7–12 yrs Bengaluru Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

Seeking a highly skilled Track Lead specializing in Extract Transform Load (ETL) and Data Lakes to provide L3 engineering and escalation support for relational database services. This role is based in Bangalore and involves taking ownership of complex incidents, managing the lifecycle, ensuring reliability, driving automation, and upholding technical governance across a diverse RDBMS technology stack.

The scope includes Oracle, Microsoft SQL Server, IBM DB2, PostgreSQL, SAP ASE, SAP IQ, and SAP Replication Server, offering a challenging and rewarding environment for experienced professionals.

Responsibilities

Key responsibilities include leading database health monitoring, process management, replication, space utilization, backup, and scheduler oversight. You will also lead access control, service management, job execution, tablespace administration, patching, and backup/restore activities. This role requires leading High Availability/Disaster Recovery (HA/DR), performance tuning, recovery strategies, and lifecycle support across enterprise RDBMS platforms.

Act as the primary technical escalation point for critical production issues, own root-cause analysis, and implement permanent solutions. You will be responsible for capacity planning, lifecycle management, and upgrade planning. Additionally, review complex changes, assess technical risks, develop runbooks, and uphold operational standards. A crucial part of this role involves creating automation using Python, Ansible, scripting, or platform APIs, and mentoring L2 engineers.

Qualifications

A minimum of 7 to 12 years of enterprise engineering and production-support experience is required. You should possess deep expertise in the primary technology stack and demonstrate strong cross-platform troubleshooting capabilities. Excellent incident, request, change, escalation, and documentation discipline within a 24x7 environment is essential. Proven experience in leading major incidents, RCAs, upgrades, migrations, automation initiatives, and technical mentoring is highly valued.

Proficiency with ITSM tools like ServiceNow, Jira, monitoring dashboards, operational runbooks, and knowledge repositories is expected. Familiarity with observability, alert correlation, capacity reporting, and SLA/KPI-based operations is important. Hands-on experience with Python, Ansible, and/or platform API automation, with a focus on reducing toil and enhancing reliability, is a key requirement.

An accredited Bachelor's degree in Engineering, Computer Science, Information Technology, or equivalent practical experience is necessary. Relevant certifications from Oracle, Microsoft, IBM, PostgreSQL, or SAP are preferred. Strong written and verbal communication, structured troubleshooting, collaborative work ethic across technical and business teams, and willingness to work in 24x7 rotational shifts in Bangalore are crucial.

Essential Skills

OracleMicrosoft SQL ServerIBM DB2PostgreSQLSAP ASESAP IQSAP Replication ServerPythonAnsibleScriptingITSMJiraMonitoring DashboardsRoot Cause AnalysisCapacity PlanningIncident ManagementEscalation ManagementTechnical GovernanceAutomation

Good to Have

Oracle CertificationMicrosoft CertificationIBM CertificationPostgreSQL CertificationSAP Certification

Highlights

  • Actively hiring

More Details

RoleTrack Lead - Extract Transform Load (ETL), Data Lakes (IN)
DepartmentData Engineering
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting