About this role
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