Sr. Snowflake Data Engineer

SynapOne; Hyderabad; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

SynapOne is seeking a Snowflake Developer with 3+ years of hands-on Snowflake experience. The role emphasizes SQL optimization, Python scripting, and end-to-end data warehousing. You will design and optimize Snowflake pipelines, migrate data, and implement best practices for performance and security.

You should be proficient in ETL/ELT tools and have strong collaboration skills to work with cross-functional teams on full data warehouse solutions.

Qualifications

• Minimum 3 years of hands-on Snowflake experience.
• Strong SQL development and optimization.
• Python scripting for data engineering tasks.
• Experience in Data Warehouse architecture and Star/Snowflake schemas.
• Hands-on with ETL/ELT tools (Informatica, Matillion, dbt, Talend).

Responsibilities

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

Skills

Snowflake

SQL

Python

Data warehousing

Data modeling

ETL/ELT tools

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.