Snowflake Developer - Snowflake,Python,ETL

Sigma Allied Services; Hyderabad, Chennai District, Bengaluru; Hybrid; INR 2,250,000 - 2,750,000; Full time

Job summary

Sigma Allied Services in Hyderabad is seeking an experienced data engineer to design and optimize enterprise-scale ETL pipelines. The role requires 6.5-10 years of data engineering experience with 4+ years in Snowflake and Python-based ETL development.

You will leverage advanced Snowflake features, build robust ETL frameworks, and mentor developers while delivering high-performance data solutions for terabytes of data.

Qualifications

• 6.5-10 years of progressive data engineering experience with at least 4+ years in Snowflake and Python ETL.
• Expert Snowflake proficiency including Snowpipe, Snowpark, streams, tasks, dynamic tables, tuning and data sharing.
• Advanced Python for robust ETL frameworks and reusable libraries; production-grade development.
• Proven track record deploying enterprise-scale ETL pipelines handling terabytes of data.
• Deep SQL optimization skills with window functions, recursive CTEs and execution plans.
• Experience with Git, CI/CD for data workflows and IaC practices.
• Strong data modeling knowledge (dimensional, Data Vault, star/snowflake schemas) and when to apply.

Skills

Snowflake

Python ETL

SQL optimization

Data modeling

CI/CD for data

Git

Mentoring

Tools

Git

CI/CD

IaC

Job description

Role & responsibilities

Technical Skills & Experience

• 6.5-10 years of progressive experience in data engineering, with at least 4+ years focused on Snowflake(at least 4+ yrs) and Python-based ETL development
• Expert-level proficiency in Snowflake, including advanced features (Snowpipe,snowpark, streams, tasks, dynamic tables), performance tuning, resource optimization, query profiling, and data sharing capabilities
• Advanced Python programming skills with demonstrated ability to build robust, production-grade ETL frameworks, implement design patterns, and develop reusable libraries
• Proven track record of architecting and deploying enterprise-scale ETL pipelines processing terabytes of data with high reliability and performance
• Deep expertise in SQL optimization, including complex window functions, recursive CTEs, and execution plan analysis
• Strong experience with version control (Git), CI/CD pipelines for data workflows, and infrastructure-as-code practices
• Comprehensive understanding of data modeling methodologies (dimensional modeling, Data Vault, star/snowflake schemas) and when to apply each approach
• Experience mentoring developers and leading technical initiatives

Preferred candidate profile

Max 25 LPA - Not more than that

Bangalore/Hyderabad/chennai

Immediate joiners only.