Walk-in | Snowflake Data Engineer

HCL Technologies Limited; Chennai District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

HCL Technologies Limited is seeking a skilled Snowflake Developer to design, develop, and optimize cloud-based data warehouse solutions. The role focuses on SQL, dbt, and ELT/ETL development, with emphasis on performance tuning and scalable data pipelines.

You will implement CI/CD for dbt projects, ensure data governance, and collaborate with analytics teams to translate data requirements into robust architectures.

Qualifications

• Hands-on Snowflake data warehouse design and development experience.
• Strong SQL skills and experience with data transformations.
• Experience with dbt for ELT/ETL and modeling.
• Knowledge of data warehousing concepts (Star/Snowflake schemas).
• Familiarity with Git version control and CI/CD for dbt.
• Experience with cloud platforms (AWS, Azure, or GCP).

Responsibilities

• Design, develop, and maintain Snowflake data warehouse solutions.
• Build and manage ELT pipelines using dbt.
• Develop complex SQL queries, views, and transformations.
• Create data marts and dimensional models.
• Optimize performance via clustering and query tuning.
• Implement CI/CD processes for dbt projects.
• Collaborate with stakeholders and analytics teams.
• Monitor data quality and performance issues.
• Ensure data governance and security compliance.
• Develop reusable dbt macros and documentation.

Skills

Snowflake DW

SQL

dbt

ELT/ETL

DW concepts

Git

CI/CD

Performance tuning

Cloud platforms

Tools

dbt

Git

Job description

Job Summary

We are looking for a highly skilled Snowflake Developer with strong expertise in SQL and dbt (Data Build Tool) to design, develop, and optimize modern cloud-based data warehouse solutions. The ideal candidate should have hands‑on experience in data modeling, ETL/ELT development, performance tuning, and building scalable data pipelines using Snowflake and dbt.

Key Responsibilities

• Design, develop, and maintain data warehouse solutions in Snowflake.
• Build and manage ELT pipelines using dbt.
• Develop complex SQL queries, stored procedures, views, and data transformations.
• Create dimensional and data mart models using best practices.
• Optimize Snowflake performance through clustering, partitioning, and query tuning.
• Implement CI/CD processes for dbt projects.
• Collaborate with business stakeholders, data engineers, and analytics teams to understand data requirements.
• Monitor data quality, troubleshooting, and performance issues.
• Develop reusable data models, macros, and documentation within dbt.
• Ensure data governance, security, and compliance standards are followed.

Required Skills

• Strong experience with Snowflake Data Warehouse.
• Advanced hands‑on expertise in SQL.
• Experience in dbt (Data Build Tool) for data transformation and modeling.
• Knowledge of ELT/ETL concepts and implementation.
• Understanding of Data Warehousing concepts (Star Schema, Snowflake Schema, Dimensions, Facts).
• Experience with Git version control.
• Knowledge of CI/CD implementation for dbt deployments.
• Experience with query optimization and performance tuning.
• Familiarity with cloud platforms such as AWS, Azure, or GCP.