Snowflakes SQL developer

Quantasis Pvt. Ltd.; Mumbai; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Quantasis Pvt. Ltd. is seeking a skilled Snowflake Developer / Data Engineer based in Mumbai with 3–4 years of data engineering and data warehousing experience.

You will design and optimize scalable data pipelines, implement Snowflake features, and collaborate across teams to deliver reliable data solutions in a cloud environment. The role requires hands-on expertise in Snowflake, SQL, ETL/ELT pipelines, Python, and cloud platforms (AWS/Azure/GCP), with a focus on performance, security (RBAC),

Qualifications

• 3–4 years of data engineering, data warehousing, or cloud data platforms experience.
• Hands-on Snowflake, SQL, ETL/ELT pipelines, Python, and cloud platforms.
• Knowledge of data governance, RBAC, security best practices, and performance tuning.

Responsibilities

• Design, develop, optimize, and maintain scalable data pipelines and data warehouse solutions using Snowflake.
• Develop and manage ETL/ELT workflows for integrating data from multiple sources.
• Implement Snowflake features including Streams, Tasks, Snowpipe, Dynamic Tables, Materialized Views, Time Travel, and Zero-Copy Cloning.
• Develop efficient SQL queries and perform query optimization and performance tuning.
• Work on data modelling using Star Schema, Snowflake Schema, and other dimensional modelling techniques.
• Implement and manage RBAC, security controls, and access policies within Snowflake.
• Monitor data pipelines, provide production support, troubleshooting, and RCA.
• Optimize Snowflake workloads for performance and cost efficiency.
• Develop Python scripts and automation for data processing and operational activities.
• Collaborate with cloud platforms such as AWS, Azure, or GCP, including S3-compatible storage.

Skills

Snowflake

SQL

ETL/ELT pipelines

Python

Cloud platforms

Data modelling concepts

Performance tuning

Cost optimization

RBAC & security

Data governance

Tools

Snowflake Cortex AI

OpenMetadata

Collibra

Apache Airflow

Snowflake Streams

Snowpipe

Dynamic Tables

Time Travel

Zero-Copy Cloning

Materialized Views

Job description

Snowflake SQL Developer Role

**Experience:** 3 to 4 Years Relevant Experience

**Position Type:** Full-Time

**Joining:** Immediate Joiners Only

**Work Mode:** Work From Office BKC Location

**Location Preference:** Mumbai-based candidates only NO RELOCATION

About the Role

We are looking for a skilled **Snowflake Developer / Data Engineer** with 34 years of relevant experience in data engineering, data warehousing, and cloud data platforms.

The ideal candidate should have strong hands‑on expertise in **Snowflake, SQL, ETL/ELT pipelines, Python, and cloud platforms**, with the ability to work on scalable data solutions, performance optimization, production support, and data governance.

Key Responsibilities

• Design, develop, optimize, and maintain scalable data pipelines and data warehouse solutions using Snowflake.
• Develop and manage ETL/ELT workflows for integrating data from multiple sources.
• Implement Snowflake features including **Streams, Tasks, Snowpipe, Dynamic Tables, Materialized Views, Time Travel, and Zero-Copy Cloning**.
• Develop efficient SQL queries and perform query optimization and performance tuning.
• Work on data modelling using **Star Schema, Snowflake Schema**, and other dimensional modelling techniques.
• Implement and manage **RBAC, security controls, and access policies** within Snowflake.
• Monitor data pipelines and provide production support, troubleshooting, and root-cause analysis.
• Optimize Snowflake workloads for both **performance and cost efficiency**.
• Develop Python scripts and automation for data processing and operational activities.
• Work with cloud platforms such as **AWS, Azure, or GCP**, including cloud storage services such as Amazon S3.
• Follow data governance, metadata management, security, and data quality best practices.
• Collaborate with cross-functional teams to understand data requirements and deliver reliable data solutions.

Required Technical Skills

• **3–4 years** of experience in Data Engineering, Data Warehousing, or Cloud Data Platforms.
• Strong hands‑on experience with **Snowflake**.
• Excellent expertise in **SQL and query optimization**.
• Strong understanding of data warehousing and data modelling concepts.
• Experience with scalable **ETL/ELT pipelines**.
• Proficiency in **Python** for automation and data processing.
• Experience with **AWS / Azure / GCP** and cloud storage platforms, preferably S3.
• Hands‑on understanding of:

• Snowflake Streams & Tasks
• Snowpipe
• Dynamic Tables
• Time Travel & Zero-Copy Cloning
• Materialized Views
• RBAC & Security Management
• Performance Tuning
• Cost Optimization
• Experience in production support, monitoring, troubleshooting, and RCA.
• Understanding of data governance, metadata management, and security best practices.

Preferred Skills

• Exposure to **Snowflake Cortex AI** capabilities.
• Knowledge of **OpenMetadata, Collibra**, or other metadata management platforms.
• Experience with orchestration tools such as **Apache Airflow**.
• Exposure to modern cloud-based data engineering architectures.

Candidate Profile

• Strong analytical and problem-solving skills.
• Good understanding of enterprise data environments.
• Ability to independently troubleshoot and resolve data-related issues.
• Strong communication and collaboration skills.
• Comfortable working in a fast‑paced, production-oriented environment.