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