Snowflake data developer

About the Role :

We are seeking an experienced Snowflake Developer with strong hands-on expertise to design, implement, and optimize data solutions on the Snowflake Data Cloud platform. The ideal candidate will demonstrate deep proficiency in SnowSQL, performance optimization, and advanced data engineering using SQL and Python. Location is

Bangalore / Mumbai / Chennai / Pune

Key Responsibilities :

• SnowSQL & Advance SQL Expertise

Expert-level knowledge of SQL and SnowSQL

for complex query development and optimization

Proficiency in DDL and DML operations, advanced SQL constructs (window functions, CTEs, subqueries, joins)

Expertise handling semi-structured data (JSON, AVRO, Parquet, XML) using VARIANT column type and LATERAL FLATTEN

Performance Optimization & Query Tuning

Deep understanding of Snowflake query optimization strategies and best practices

Expertise in warehouse sizing, clustering keys, and micro-partition optimization

Proficiency with Snowflake's caching mechanisms and partition pruning techniques

Experience with filter pushdown optimization and predicate optimization techniques

Ability to analyze query execution plans using EXPLAIN and Query Profile features

Experience with Query Acceleration Service (QAS), Search Optimization Service, materialized views, and dynamic tables

Proven track record identifying and resolving query bottlenecks, spilling issues, and warehouse queuing problems

Python Development & Integration

Strong Python programming for data engineering, automation, and ETL / ELT workflows

Proficiency in Snowpark for Python to build scalable data processing applications

Experience with Snowflake Python APIs, Snowflake Connector for Python, and pandas on Snowflake

Ability to develop Python UDFs and stored procedures

Design, develop, and maintain robust data solutions using Snowflake platform

Write and optimize complex SQL queries for high performance and cost efficiency

Implement performance tuning strategies for optimal query execution and warehouse utilization

Develop Python-based automation scripts and data processing workflows

Create and maintain data models supporting business intelligence and analytics

Monitor and troubleshoot data pipeline issues and performance bottlenecks

Collaborate with cross-functional teams to translate business requirements into technical solutions

Document technical processes, data flows, and architectural decisions

Stay current with Snowflake features and implement industry best practices

Participate in code reviews and mentor junior developers

Work Location

Work from office

Bangalore / Mumbai / Chennai / Pune

Experience

Minimum 6 – 10 years of work experience with

at least two projects implementation leveraging Snowflake