Senior Snowflake Data Developer

Zohorecruit; Bangalore Rural; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Technopals Pte.Ltd. in Bangalore seeks an experienced Snowflake Developer to design, implement, and optimize data solutions on the Snowflake Data Cloud platform. You will leverage SnowSQL, advanced SQL, and Python for scalable data engineering.

The candidate should demonstrate expertise in performance optimization, semi-structured data handling, and Snowpark for Python to build automated ETL/ELT workflows. Join a team delivering high-performance analytics and robust data models.

Qualifications

• Expert-level knowledge of SQL and SnowSQL for complex query development and optimization.
• Experience handling JSON, AVRO, Parquet, XML using VARIANT and LATERAL FLATTEN.
• Experience with stored procedures and data transformations.

Responsibilities

• 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 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 pipelines and performance bottlenecks.
• Collaborate with cross-functional teams to translate 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.

Skills

SnowSQL

Advanced SQL

Semi-structured data

Query optimization

Python data engineering

Snowpark for Python

Snowflake Python APIs

Pandas on Snowflake

VARIANT & FLATTEN

Stored procedures

Tools

Snowflake

Snowflake Connector for Python

EXPLAIN / Query Profile

Job description

Bangalore North, India | Posted on 11/11/2025

• Industry Information Technology and Services
• Work Experience 5+ years
• Country India
• Postal Code 560038

Job Description

Position Overview

We are seeking anexperiencedSnowflake Developerwith strong hands-on expertise todesign, implement, and optimize data solutions on the Snowflake Data Cloudplatform. The ideal candidate will demonstrate deep proficiency in SnowSQL,performance optimization, and advanced data engineering using SQL and Python.

Core TechnicalRequirements

SnowSQL & AdvanceSQL Expertise

• Expert-level knowledge of SQL and SnowSQL for complex query development andoptimization
• Proficiency in DDL and DML operations, advanced SQL constructs (windowfunctions, CTEs, subqueries, joins)
• Expertise handling semi-structured data (JSON, AVRO, Parquet, XML) usingVARIANT column type and LATERAL FLATTEN
• Experience with stored procedures, transaction management, and datatransformations

PerformanceOptimization & Query Tuning

• Deep understanding of Snowflake query optimization strategies and bestpractices
• Expertise in warehouse sizing, clustering keys, and micro-partitionoptimization
• Proficiency with Snowflake's caching mechanisms and partition pruningtechniques
• Experience with filter pushdown optimization and predicate optimizationtechniques
• Ability to analyze query execution plans using EXPLAIN and Query Profilefeatures
• Experience with Query Acceleration Service (QAS), Search Optimization Service,materialized views, and dynamic tables
• Proven track record identifying and resolving query bottlenecks, spillingissues, and warehouse queuing problems

Python Development& Integration

• Strong Python programming for data engineering, automation, and ETL/ELTworkflows
• Proficiency in Snowpark for Python to build scalable data processingapplications
• Experience with Snowflake Python APIs, Snowflake Connector for Python, andpandas on Snowflake
• Ability to develop Python UDFs and stored procedures

KeyResponsibilities

• 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 andwarehouse 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 intotechnical 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

Technopals Pte.Ltd. is an Equal Opportunity Employer and does not discriminate on the basis of race or ethnicity, religion, sex, national origin, age, veteran disability or genetic information or any other reason prohibited by law in employment.