Lead Consultant(Development)
India
Apply now
Job Description
Lead Consultant(Development)
Noida, Uttar Pradesh

Job Summary

Data Engineer

 

ADF

DBT

Databricks

Snowflake

Key Responsibilities

ADF

DBT

Databricks

Snowflake

Skill Requirements

ob Description: Snowflake & dbt DeveloperRole OverviewWe are looking for an experienced Snowflake & dbt Developer / Data Engineer to design, develop, and maintain scalable cloud data solutions. The candidate should have strong hands-on experience with Snowflake, dbt, SQL, data modeling, and ETL/ELT processes, with a focus on building reliable and high-performing data pipelines.Key ResponsibilitiesDesign, develop, and maintain data solutions using Snowflake and dbt.Build and optimize ELT/ETL pipelines for data ingestion and transformation.Develop reusable and modular dbt models, tests, macros, and documentation.Design and implement dimensional and analytical data models.Write and optimize complex SQL queries for performance and scalability.Implement data quality checks, testing, monitoring, and troubleshooting.Work with structured and semi-structured data within Snowflake.Perform Snowflake performance tuning and query optimization.Collaborate with business analysts, architects, BI teams, and upstream/downstream application teams.Support deployment and version control processes using Git and CI/CD practices.Troubleshoot data pipeline, transformation, and production issues.Follow data engineering standards, security practices, and development best practices.Required SkillsStrong hands-on experience with Snowflake.Strong working experience with dbt (Data Build Tool).Advanced knowledge of SQL.Good understanding of data warehousing, dimensional modeling, and ELT/ETL concepts.Experience developing scalable data transformation pipelines.Experience with Git/version control and CI/CD.Knowledge of Snowflake concepts such as warehouses, databases, schemas, stages, and performance optimization.Strong debugging, analytical, and problem-solving skills.Preferred SkillsExperience with Python for data engineering or automation.Exposure to cloud platforms such as Azure, AWS, or GCP.Experience with orchestration/integration tools such as Airflow, Azure Data Factory, or similar technologies.Understanding of data governance, security, and data quality practices.dbt certification or Snowflake certification is an added advantage.Experience5+ years of overall Data Engineering / Data Warehousing experience.2+ years of hands-on Snowflake and dbt experience preferred. ADF

DBT

Databricks

Snowflake

 

 

Other Requirements

ADF

DBT

Databricks

Snowflake
Apply now
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 223,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 June 2026 totaled $14.8 billion.