Snowflake Senior Technical Lead
India
Apply now
Job Description
Snowflake Senior Technical Lead
Bangalore, Karnataka

Job Summary

Design and build Snowflake optimization capabilities within DCO - warehouse sizing, 
query performance, clustering, materialized views, storage tiers, and credit consumption.
• Translate Snowflake expertise into product capabilities - detection rules, 
recommendation engines, and safe automated actions for production accounts.
• Build POCs to validate optimization ideas, demonstrate customer value, and support 
product discovery and pre-sales.
• Partner with backend, AI/ML, and data engineering teams to ship features end-to-end.

Key Responsibilities

Design and build Snowflake optimization capabilities within DCO - warehouse sizing, 
query performance, clustering, materialized views, storage tiers, and credit consumption.
• Translate Snowflake expertise into product capabilities - detection rules, 
recommendation engines, and safe automated actions for production accounts.
• Build POCs to validate optimization ideas, demonstrate customer value, and support 
product discovery and pre-sales.
• Partner with backend, AI/ML, and data engineering teams to ship features end-to-end.

Skill Requirements

engineering experience; hands-on exp in Snowflake in production.
• Snowflake architecture expertise - three-layer, virtual warehouses, micro-partitions, 
clustering/pruning, result/metadata/warehouse caching, time travel, fail-safe, and zerocopy cloning.
• Snowflake platform capabilities - Snowpark, Streams, Tasks, Dynamic Tables, 
Materialized Views, Search Optimization Service, Query Acceleration Service, Resource 
Monitors, Snowflake Optima, Query Insights, external functions, and SQL API.
• Account administration - RBAC, warehouses, Adaptive Compute, Gen2 Warehouses, 
multi-cluster policies, auto-suspend/resume, replication, SnowSQL/REST APIs.
• Advanced query tuning - Query Profile analysis, clustering keys, materialized views, 
Search Optimization.
• Cost optimization warehouse right-sizing , credit usage analysis, workload-based 
optimization, AISQL / Cortex cost governance (tagging, attribution, budget controls).
• Python (Snowpark), JavaScript/Python UDFs and stored procedures.
• Cloud platforms (AWS / Azure / GCP) - IAM, networking, storage integrations 
(S3/ADLS/GCS), PrivateLink, cloud-native Snowflake integrations.
• Strong fundamentals in data structures, algorithms, distributed systems, and large-scale 
system design

Snowflake Cortex -Cortex AI Functions (AISQL), AI-driven optimization (intelligent 
recommendations, anomaly detection), and native Snowflake automation complementing 
optimization logic.
• FinOps practices and cost-attribution models for data platforms.
• Observability tools (Prometheus, Grafana, OpenTelemetry, Datadog).
• Experience with Docker, Kubernetes, Terraform, and modern CI/CD pipelines

Other Requirements

BS/MS in Computer Science, Engineering, or related field.

SnowPro Advanced certifications (Architect, Data Engineer, or Administrator).
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 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.