Senior Snowflake Data Developer

Bangalore - India

Monthly Salary: INR 1500000 - 1500000

Experience Required: 5years

Posted on: 2 hours ago

Vacancies: 1 Vacancy

Job Summary

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

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

Required Skills:

Experience in Infosec and GRCC. Mandatory Requirement Experience in Application support (required) Azure Cloud Infra Level 1 knowledge in DevOps L2 knowledge & Angular. L1/L2 in Infra security. Knowledge in Australian Data Sovereignty/Data Privacy laws and Regulatory compliance certifications needed for Software Products.

Required Education:

Graduate

Position OverviewWe 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 engineer...