Sr. Snowflake Data Engineer

SynapOne; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

SynapOne is seeking a skilled Snowflake Developer with 3+ years of hands-on Snowflake experience, strong SQL expertise, and Python scripting abilities to design and optimize data pipelines. The role requires implementing ETL/ELT processes, migrating data to Snowflake, and ensuring performance, security, and cost efficiency across cloud environments.

The ideal candidate will contribute to data warehousing, data modeling (Star/Snowflake schema), and collaboration with cross-functional teams to

Qualifications

• Minimum 3 years of hands-on Snowflake experience.
• Strong expertise in SQL development and optimization.
• Proficiency in Python for scripting and data engineering tasks.
• Experience in Data Warehouse architecture and Data Modeling (Star/Snowflake).
• Hands-on experience with ETL/ELT tools (Informatica, Matillion, dbt, Talend).
• Experience with cloud platforms (AWS, Azure, GCP) and related services.
• Solid understanding of performance tuning, data governance, and security concepts.
• Excellent problem solving and communication skills.

Responsibilities

• Design, develop, and optimize data pipelines and ETL/ELT processes in Snowflake.
• Develop and optimize complex SQL queries for data extraction, transformation, and reporting.
• Write robust Python scripts for automation, orchestration, and data transformations.
• Migrate data from legacy systems to Snowflake and integrate various data sources.
• Implement Snowflake best practices for performance tuning, security, and cost management.
• Collaborate with cross-functional teams to implement end-to-end data warehouse solutions.

Skills

Snowflake

SQL development

Python scripting

Data Warehousing

Data Modeling

ETL/ELT concepts

Cloud platforms

Data governance & security

Problem solving & communication

Tools

Informatica

Matillion

dbt

Talend

Job description

We are seeking a highly skilled and experienced Snowflake Developer with a strong background in SQL, Python and a minimum of 3 years of hands-on experience with Snowflake. The ideal candidate will be a Snowflake Certified with a proven track record in data warehousing, data modelling, and implementing ETL/ELT pipelines using industry-standard tools.

Primary Roles & Responsibilities

• Design, develop, and optimize data pipelines and ETL/ELT processes in Snowflake.
• Develop and optimize complex SQL queries for data extraction, transformation, and reporting.
• Write robust Python scripts for automation, orchestration, and data transformations.
• Migrate data from legacy systems to Snowflake and integrate various data sources.
• Implement Snowflake best practices for performance tuning, security, and cost management.
• Collaborate with cross-functional teams to implement end-to-end data warehouse solutions.

Required Skills

• Minimum 3 years of hands-on experience with Snowflake.
• Strong expertise in SQL development and optimization.
• Proficient in Python for scripting and data engineering tasks.
• Experience in Data Warehouse architecture and Data Modeling (Star/Snowflake Schema).
• Hands-on experience with ETL/ELT tools like Informatica, Matillion, dbt, Talend, or equivalent.
• Experience with cloud platforms (AWS, Azure, or GCP) and associated services.
• Solid understanding of performance tuning, data governance, and security concepts.
• Excellent problem solving and communication skills.