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 ExpertiseExpert-level knowledge of SQL and SnowSQL for complex query development and optimizationProficiency 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 FLATTENExperience with stored procedures, transaction management, and data transformationsPerformance Optimization & Query Tuning
Deep understanding of Snowflake query optimization strategies and best practicesExpertise in warehouse sizing, clustering keys, and micro-partition optimizationProficiency with Snowflake's caching mechanisms and partition pruning techniquesExperience with filter pushdown optimization and predicate optimization techniquesAbility to analyze query execution plans using EXPLAIN and Query Profile featuresExperience with Query Acceleration Service (QAS), Search Optimization Service, materialized views, and dynamic tablesProven track record identifying and resolving query bottlenecks, spilling issues, and warehouse queuing problemsPython Development & Integration
Strong Python programming for data engineering, automation, and ETL / ELT workflowsProficiency in Snowpark for Python to build scalable data processing applicationsExperience with Snowflake Python APIs, Snowflake Connector for Python, and pandas on SnowflakeAbility to develop Python UDFs and stored proceduresDesign, develop, and maintain robust data solutions using Snowflake platformWrite and optimize complex SQL queries for high performance and cost efficiencyImplement performance tuning strategies for optimal query execution and warehouse utilizationDevelop Python-based automation scripts and data processing workflowsCreate and maintain data models supporting business intelligence and analyticsMonitor and troubleshoot data pipeline issues and performance bottlenecksCollaborate with cross-functional teams to translate business requirements into technical solutionsDocument technical processes, data flows, and architectural decisionsStay current with Snowflake features and implement industry best practicesParticipate in code reviews and mentor junior developersWork Location
Work from officeBangalore / Mumbai / Chennai / PuneExperience
Minimum 6 – 10 years of work experience with at least two projects implementation leveraging Snowflake - either migration from traditional DWHs or a fresh implementation