Snowflake Developer
At a glance
Mid-level Data Engineering role at Weekday AI. Pune · full-time.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Design Snowflake data pipelines and architectures, then move legacy databases onto the platform
- Build ELT workflows with DBT and Apache Airflow, including ingestion for structured and semi-structured data
- Create data models and reusable checks for validation, reconciliation, auditing and monitoring
- Improve Snowflake objects and transformed workloads, and prepare technical designs and migration runbooks
- Handle L3 production issues by diagnosing pipeline failures, finding root causes and applying lasting fixes
What you bring
- At least five years of experience in data engineering or closely related work
- Hands-on skill with Snowflake, DBT and Apache Airflow
- Experience assessing legacy data platforms and planning loads, CDC and historical data migrations
Who this fits
This role suits someone comfortable combining Snowflake development and legacy-data migration with L3 production support. The position is based onsite in Pune or Bengaluru, and requires flexibility to shift working hours.
From the employer
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
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.