Senior Technical Lead
HCLTech
Senior Technical Lead
About this role
Job Summary
Highly skilled Data Engineer with strong expertise in Snowflake and dbt should possess extensive hands-on experience in designing, building, optimizing, and maintaining modern cloud-based data platforms. The candidate must have a strong foundation in Data Warehousing, ETL/ELT processes, Data Modeling, SQL, and RDBMS technologies along with the ability to develop scalable and high-performing data solutions.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines using Snowflake and dbt.
- Build and optimize data warehouse solutions to support analytics and reporting requirements.
- Develop ELT/ETL frameworks and data transformation processes using industry best practices.
- Design and implement dimensional and normalized data models.
- Write Complex SQL queries when required.
- Create reusable dbt models, macros, tests, snapshots, and documentation.
- Optimize Snowflake performance, storage, and compute costs.
- Develop and maintain data ingestion frameworks from various source systems.
- Implement data quality checks, monitoring, and governance controls.
- Collaborate with business analysts, architects, and stakeholders to translate business requirements into technical solutions.
- Troubleshoot and resolve production issues related to data pipelines and warehouse performance.
- Ensure adherence to security, compliance, and data management standards.
Skill Requirements
Snowflake
- Strong hands-on experience in Snowflake architecture and administration.
- Expertise in:
- Virtual Warehouses
- Snowflake Storage & Compute Optimization
- Complex Query writing and Performance Tuning
- Clustering & Partitioning Strategies
- Snowpipe
- Streams & Tasks
- Time Travel & Fail-safe
- Data Sharing
- Role-Based Access Control (RBAC)
- Experience with Snowflake migration projects and performance optimization.
dbt
- Extensive hands-on experience in:
- dbt Core and/or dbt Cloud
- dbt Models
- Macros
- Seeds
- Snapshots
- Incremental Models
- CI/CD Integration
- Data Lineage and Governance
Data Warehousing
- Strong understanding of:
- Dimensional Modeling
- Star and Snowflake Schemas
- Data Lake and Data Warehouse Architectures
- SCD Type 1 & Type 2 Implementations
ETL / ELT
- Extensive experience in designing and implementing ETL/ELT solutions.
- Expertise in handling complex data transformations and large-volume data processing.
Databases
Strong knowledge of multiple RDBMS platforms including:
- Oracle/SQL Server/PostgreSQL etc..
Other Requirements
Good to Have Skills
- Cloud platforms: AWS, Azure, or GCP.
- Data integration tools such as Informatica, Matillion, Fivetran, Talend, or Azure Data Factory.
- CI/CD tools such as GitHub, GitLab, Azure DevOps, Jenkins.
- Exposure to data governance and data quality frameworks.
Frequently Asked Questions
Is the salary disclosed for the Senior Technical Lead position at HCLTech?
The salary for this Senior Technical Lead role at HCLTech is not publicly listed. Click "Apply Now" to learn more about the compensation package on their official careers page.
Where is the Senior Technical Lead position at HCLTech located?
This Senior Technical Lead role at HCLTech is based in Chennai, India. The position is listed as on-site or hybrid. Check the full job description or apply directly to confirm the work arrangement.
How do I apply for the Senior Technical Lead position at HCLTech?
Click the "Apply Now" button on this page. You will be redirected to HCLTech's official application portal hosted on successfactors where you can submit your application directly.
When was the Senior Technical Lead job at HCLTech posted?
This Senior Technical Lead position at HCLTech was posted on Sep 2, 2026. Apply as soon as possible — early applications are often reviewed first.
Senior Technical Lead
HCLTech
You'll be redirected to HCLTech's official application page on successfactors.