Snowflake Developer

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 Requirements 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

Good to have: 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