Snowflake Technical Lead
India
Job Description
Snowflake Technical Lead
Bengaluru, Karnataka

Job Summary

We are seeking an experienced Senior Developer specializing in DBT (Data Build Tool) and Snowflake to design, develop, and optimize scalable data transformation pipelines on a modern cloud data platform.

The ideal candidate will have strong expertise in data warehousing, ELT frameworks, and Snowflake performance optimization, along with the ability to independently own end-to-end data pipeline and migration initiatives.

Key Responsibilities

Key Responsibilities:

  • Design, develop, and maintain scalable ELT pipelines using DBT on Snowflake
  • Build modular, reusable, and well-documented DBT models following best practices
  • Optimize Snowflake workloads for performance, cost, and scalability
  • Translate complex business requirements into efficient data models and transformations
  • Perform end-to-end migration of legacy ETL jobs (e.g., DataStage) to DBT/Snowflake
  • Analyze existing ETL pipelines and redesign them using modern ELT architecture patterns
  • Implement data quality checks, testing frameworks, and CI/CD pipelines using DBT
  • Monitor, troubleshoot, and improve pipeline reliability and performance
  • Collaborate with data architects, analysts, and business stakeholders to deliver high-quality data solutions
  • Ensure adherence to data governance, security, and best engineering practices

Skill Requirements

Mandatory Skills & Experience

6+ years of experience in data engineering / ETL development

Minimum 3–4 years of hands-on experience with DBT on Snowflake

 

Strong expertise in:

Snowflake architecture, performance tuning, and query optimization

DBT models, macros, snapshots, and testing frameworks

SQL (advanced level)

 

Solid understanding of:

Data warehousing concepts

ELT vs ETL frameworks

Dimensional data modeling

 

Experience in end-to-end development and deployment of data pipelines

Ability to independently deliver and own complete modules/migrations

Other Requirements

Nice to Have

DBT certification or Snowflake certification

Experience in healthcare or enterprise data platforms

Exposure to data governance and compliance frameworks

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 226,300 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 December 2025 totaled $14.5 billion.

23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.