Snowflake Data Engineer

Zettamine Labs; Dadri, Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

ZettaMine Labs Pvt Ltd. in India seeks an experienced Data Engineer to design and implement scalable ETL/ELT data pipelines using Snowflake, SQL, and PostgreSQL. The role emphasizes data warehousing, dimensional modeling, and delivering reliable reporting workloads.

You will collaborate with analysts and BI teams to translate data requirements into robust data architectures, optimize performance, ensure data quality, and maintain scalable data pipelines.

Qualifications

• Minimum 3–5 years of experience as a Data Engineer or similar in a data-driven environment.

Responsibilities

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Work extensively with Snowflake for data warehousing and analytical workloads.
• Write and optimize advanced SQL queries for large datasets.
• Design and implement dimensional data models, including Star Schema and Snowflake Schema.
• Develop and maintain data warehouse structures, tables, views, and transformations.
• Collaborate with data analysts, BI teams, and business stakeholders to understand data requirements.
• Ensure data pipelines are scalable, reliable, and maintainable.

Skills

Advanced SQL

ETL/ELT pipelines

Dimensional data modeling

Star Schema

Snowflake Schema

Data warehousing

Data quality

Tools

Snowflake

PostgreSQL

Job description

Role & responsibilities

Job Summary:
We are looking for an experienced Data Engineer with expert-level proficiency in Snowflake and Advanced SQL. The candidate should have strong experience in designing and implementing ETL/ELT data pipelines, data integration, and dimensional data modeling for analytical and reporting workloads.

Key Responsibilities:

• Design, develop, and maintain scalable ETL/ELT data pipelines.
• Work extensively with Snowflake for data warehousing and analytical workloads.
• Write and optimize advanced SQL queries for large datasets.
• Design and implement dimensional data models, including Star Schema and Snowflake Schema.
• Develop and maintain data warehouse structures, tables, views, and transformations.
• Work with PostgreSQL for data extraction, transformation, and analysis.
• Implement data quality, validation, and performance optimization processes.
• Troubleshoot and optimize ETL/ELT workflows and SQL queries.
• Collaborate with data analysts, BI teams, and business stakeholders to understand data requirements.
• Ensure data pipelines are scalable, reliable, and maintainable.

ZettaMine Labs Pvt Ltd.