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

Positive-to-have skills

Informatica, SQL, Datastage

📌 Snowflake Developer Bengaluru
🏢 Weekday AI
📍 Bengaluru