Snowflake Developer

Weekday AI; Pune District; On-site; INR 1,400,000 - 2,000,000; Full time

Job summary

Weekday is seeking an experienced Data Engineer for L3 Snowflake migrations in Pune or Bengaluru. You will design scalable data pipelines, migrate legacy systems to Snowflake, and implement robust ELT frameworks with DBT and Airflow.

The role requires 5+ years in data engineering, strong SQL, and experience with modern data architectures. This is a full-time position based in India with flexible shift options.

Qualifications

• Minimum 5+ years of experience in data engineering or similar.
• Strong expertise in Snowflake and modern data architectures.
• Experience with ETL/ELT and migration projects.

Responsibilities

• Design and develop scalable data pipelines and data architectures using Snowflake.
• Lead migration initiatives from legacy databases to Snowflake.
• Build and optimize ELT frameworks using DBT.
• Develop and orchestrate workflows using Apache Airflow.
• Design migration strategies, including Full Data Loads and Incremental Loads.
• Create data models (Star Schema, Snowflake Schema) and data validation routines.

Skills

Snowflake

DBT

Airflow

Tools

Informatica

SQL

Datastage

Job description

This role is for one of the Weekday's clients

Min Experience: 5+ years

Location: Pune, Maharashtra, India, Bengaluru, Karnataka, India

JobType: full-time

Key Responsibilities

Shift- Flexibility to shift working

Project Type- L3 Support

Development Responsibilities

• Design and develop scalable data pipelines and modern data architectures using Snowflake.


• Lead migration initiatives from legacy databases to Snowflake.


• Build and optimize ELT frameworks using DBT.


• Develop and orchestrate workflows using Apache Airflow.


• Design and implement data models, including Star Schema and Snowflake Schema.


• Develop ingestion pipelines for structured and semi-structured data.


• Create reusable frameworks for data validation, reconciliation, auditing, and monitoring.


• Optimize Snowflake objects, including Virtual Warehouses


• Clustering Keys


• Materialized Views


• Streams & Tasks


• Dynamic Tables


• Develop technical design documents and migration runbooks.


• Perform code reviews and enforce engineering best practices.

Migration Responsibilities

• Assess and migrate data from legacy platforms, including Oracle


• SQL Server


• Teradata


• Netezza


• DB2


• SAP HANA


• On-Prem Data Warehouses


• Perform source system analysis and database rationalization.


• Design migration strategies, including Full Data Loads


• Incremental Loads


• CDC (Change Data Capture)


• Historical Data Migration


• Conduct data reconciliation and validation during migration.


• Optimize transformed workloads for Snowflake architecture.


• Execute cutover planning and post-migration stabilization.

AMS / Production Support Responsibilities

• Provide L3 support for Snowflake data platforms and pipelines.


• Monitor and manage production data workloads.


• Troubleshoot data failures, performance issues, and pipeline disruptions.


• Perform root cause analysis (RCA) and implement permanent fixes.


• Support incident, problem, change, and release management activities.


• Work closely with business users and stakeholders to resolve production issues.


• Ensure adherence to SLA and operational support commitments.


• Participate in production releases and deployment activities.

Must-have skills

Snowflake, DBT, Airflow

Good-to-have skills

Informatica, SQL, Datastage