Senior Technical Lead

India
Job Description

Senior Technical Lead

Chennai, Tamil Nadu

Job Summary

"Task Description: Data Engineer / Software Engineer with strong hands-on experience in Snowflake, Teradata, SQL, ETL/ELT, and Stored Procedures.

Experience:
5–10 years of experience in Data Engineering / Software Engineering, with strong enterprise data warehouse development and production support experience.

Key Responsibilities:
•    Develop and maintain complex Snowflake and Teradata Stored Procedures.
•    Design and develop data pipelines and ETL/ELT processes.
•    Develop complex SQL, views, tables, and transformation logic.
•    Build staging, integration, target, and presentation data layers.
•    Implement incremental loads, reload logic, reconciliation, and data-quality checks.
•    Optimize Snowflake queries, warehouses, and credit consumption.
•    Work with Azure Data Factory (ADF), SFTP, and Python as required.
•    Develop data models including fact, dimension, and aggregate tables.
•    Support Power BI/Cognos reporting requirements.
•    Troubleshoot production issues and perform root-cause analysis.
•    Follow software engineering practices including Git, testing, code reviews, and deployment.

Required Skills:
•    Strong Snowflake Stored Procedure development
•    Strong Teradata Stored Procedure / SQL development
•    Advanced SQL
•    Snowflake & Teradata
•    ETL/ELT
•    Data Modeling
•    Performance Tuning
•    Python
•    Azure Data Factory"

Key Responsibilities

"Task Description: Data Engineer / Software Engineer with strong hands-on experience in Snowflake, Teradata, SQL, ETL/ELT, and Stored Procedures.

Experience:
5–10 years of experience in Data Engineering / Software Engineering, with strong enterprise data warehouse development and production support experience.

Key Responsibilities:
•    Develop and maintain complex Snowflake and Teradata Stored Procedures.
•    Design and develop data pipelines and ETL/ELT processes.
•    Develop complex SQL, views, tables, and transformation logic.
•    Build staging, integration, target, and presentation data layers.
•    Implement incremental loads, reload logic, reconciliation, and data-quality checks.
•    Optimize Snowflake queries, warehouses, and credit consumption.
•    Work with Azure Data Factory (ADF), SFTP, and Python as required.
•    Develop data models including fact, dimension, and aggregate tables.
•    Support Power BI/Cognos reporting requirements.
•    Troubleshoot production issues and perform root-cause analysis.
•    Follow software engineering practices including Git, testing, code reviews, and deployment.

Required Skills:
•    Strong Snowflake Stored Procedure development
•    Strong Teradata Stored Procedure / SQL development
•    Advanced SQL
•    Snowflake & Teradata
•    ETL/ELT
•    Data Modeling
•    Performance Tuning
•    Python
•    Azure Data Factory"

Skill Requirements

Other Requirements

Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 230,000 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending September 2026 totaled $14.8 billion.