Snowflake Developer

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

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