Time since we first saw it
Day 1
Early. Similar jobs usually come down between day 6 and day 56.
From 13,630 similar postings that came down. Coming down is not always a hire.
Track Lead - Extract Transform Load (ETL), Data Lakes (IN)
- Pay
- Pay not listed
- Work setting
- Not stated
- Employment
- Not stated
What you’ll work on
Full postingAnalyse the Oracle data warehouse and design the target model in Databricks
Build and optimise ETL/ELT pipelines in Databricks to migrate tables and datamarts
Translate Oracle SQL and PL/SQL logic into Databricks Spark SQL and PySpark
Ensure data quality, performance and reliability of the new warehouse
Document migration patterns, data models and operational procedures
From the employer’s posting
Analyse the current Oracle data warehouse (including PostgreSQL source feeds and SAS ETL–generated structures) and design the target model in Databricks.
Build and optimise ETL/ELT pipelines in Databricks (Spark SQL, PySpark) to migrate core data warehouse tables and datamarts from Oracle to Databricks.
Translate Oracle SQL/PL-SQL logic into Databricks Spark SQL and PySpark, ensuring functional equivalence and performance optimisation.
Ensure data quality, performance, and reliability of the new Databricks-based data warehouse
Document migration patterns, data models, and operational procedures to support long-term maintainability and reusability.
Posting record
Report an errorActively hiringFirst seen by us 1 day ago, still listed, and not a repost of an earlier posting.
- Status in our records
- Live
- First seen by us
- Nov 12, 20261 day ago
- Recorded sightings
- 2
- Last seen by us
- Nov 13, 2026
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
How this job compares
HCL Technologies is hiring
357 open jobs
Open jobs by the week we first saw them, last 12 weeks.
- 1% of open jobs were reposted
See how this role fits your experience
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
- SAS
- SQL
- Databricks
- Delta Lake
- Oracle
- PostgreSQL
- Spark
- PySpark
Where the posting names them
Key Responsibilities Analyse the current Oracle data warehouse (including PostgreSQL source feeds and SAS ETL–generated structures) and design the target model in Databricks. • Build and optimise ETL/ELT pipelines in Databricks (Spark SQL, PySpark) to migrate core data warehouse tables and datamarts from Oracle to Databricks. • Translate Oracle SQL/PL-SQL logic into Databricks Spark SQL and PySpark, ensuring functional equivalence and performance optimisation. • Ensure data quality, performance, and reliability of the new Databricks-based data warehouse, enabling downstream analytics and AI/ML use cases. • Collaborate closely with the Enterprise Architect, ADP platform team and business stakeholders to align with architecture, standards, and best practices. • Document migration patterns, data models, and operational procedures to support long-term maintainability and reusability. Skill Requirements
Skill Requirements Graduate or Postgraduate in Engineering or a Post graduate in non-engineering disciplines . • Experience of 5-9 years of experience in ITIL process/application support/Deployment activities. • Basic knowledge on database • Strong hands-on experience with Databricks (Spark SQL, PySpark, Delta Lake, jobs, clusters). • Proven background in data warehousing (dimensional modelling, ETL/ELT, performance tuning). • Solid experience with Oracle DWH (SQL, PL/SQL) and migrations from Oracle or similar legacy DWH platforms. • Experience integrating PostgreSQL as a data source into a central DWH/Lakehouse. • Ability to reverse-engineer existing ETL logic (e.g. SAS jobs) and translate it into Databricks pipelines, even if not directly working on SAS BI reports. • Strong communication and stakeholder management skills in an international, multi-vendor setup. • Good understanding of how high-quality, well-modelled data underpins advanced analytics and AI/ML capabilities. Other Requirements
Job Summary We are looking for a Senior Data Engineer with strong Databricks, SQL and data warehousing experience to lead the migration of an existing Oracle-based data warehouse to Databricks on the Allianz Data Platform (ADP). Experience with modern data engineering practices and AI-enabling data platforms is highly desirable. Key Responsibilities
Your next step
Complete your application on careers.hcltech.com. The employer’s form will show what is required.
Applying through SAP SuccessFactors
- Images (.jpg) aren’t accepted as a resume.
Already applied? Track this application
Has HCL Technologies posted this job before?
Yes. We’ve followed one other Track Lead - Extract Transform Load (ETL), Data Lakes (IN) job there since November 2026. It is still up.
About HCL Technologies
- People
- About 20,206 in 2024.Benefit plan filings (Form 5500)
- Company
- Listed as HCLTECH.NS.
- H-1B visas
- 754 approved for new hires in fiscal 2025.US Citizenship and Immigration Services
- Layoff notices
- Notices this year and last cover 120 people. The latest was filed March 27, 2026.State WARN notices
Demand for Data Engineer roles
New Data Engineer postings at the employers we follow are up 7% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Engineer, by the work the posting describes.
Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.
Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.
An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.
US government figures for database architects
- Median yearly pay, May 2025
- $139,500
- Expected change, 2025 to 2035
- 9.4% more jobsagainst 3.5% for all jobs
The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.
Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.
Job description
Job Summary
We are looking for a Senior Data Engineer with strong Databricks, SQL and data warehousing experience to lead the migration of an existing Oracle-based data warehouse to Databricks on the Allianz Data Platform (ADP). Experience with modern data engineering practices and AI-enabling data platforms is highly desirable.
Key Responsibilities
Analyse the current Oracle data warehouse (including PostgreSQL source feeds and SAS ETL–generated structures) and design the target model in Databricks. • Build and optimise ETL/ELT pipelines in Databricks (Spark SQL, PySpark) to migrate core data warehouse tables and datamarts from Oracle to Databricks. • Translate Oracle SQL/PL-SQL logic into Databricks Spark SQL and PySpark, ensuring functional equivalence and performance optimisation. • Ensure data quality, performance, and reliability of the new Databricks-based data warehouse, enabling downstream analytics and AI/ML use cases. • Collaborate closely with the Enterprise Architect, ADP platform team and business stakeholders to align with architecture, standards, and best practices. • Document migration patterns, data models, and operational procedures to support long-term maintainability and reusability.
Skill Requirements
Graduate or Postgraduate in Engineering or a Post graduate in non-engineering disciplines . • Experience of 5-9 years of experience in ITIL process/application support/Deployment activities. • Basic knowledge on database • Strong hands-on experience with Databricks (Spark SQL, PySpark, Delta Lake, jobs, clusters). • Proven background in data warehousing (dimensional modelling, ETL/ELT, performance tuning). • Solid experience with Oracle DWH (SQL, PL/SQL) and migrations from Oracle or similar legacy DWH platforms. • Experience integrating PostgreSQL as a data source into a central DWH/Lakehouse. • Ability to reverse-engineer existing ETL logic (e.g. SAS jobs) and translate it into Databricks pipelines, even if not directly working on SAS BI reports. • Strong communication and stakeholder management skills in an international, multi-vendor setup. • Good understanding of how high-quality, well-modelled data underpins advanced analytics and AI/ML capabilities.
Other Requirements
Strong Analytical, Logical and Communication Skills (written, oral, one to one etc). • Professional, Innovative, Drive for continuous improvement. • Positive attitude, proactively provides solutions
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
No pay amount identified in the saved description.
- Location & working pattern
India
Working pattern and location restrictions need checking in the full posting.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.