Position Overview

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.

Core Technical Requirements

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

⢠Experience with stored procedures, transaction management, and data transformations

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 agile 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

Key Responsibilities

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

⢠Write and optimize c

📌 Senior Snowflake Data Developer (Bengaluru)
🏢 Technopals Pte.
📍 Bengaluru