This role is for one of Weekday’s clients

Min Experience: 5+ years
Location: Remote (India), India
JobType: full-time

We are seeking an experienced Snowflake Data Engineer with 5–8 years of hands-on experience in data engineering, data warehousing, and large-scale data migration. The ideal candidate will have strong expertise in Snowflake Data Warehousing, ETL/ELT development, and Oracle-to-Snowflake migration. You will be responsible for designing scalable data solutions, developing efficient data pipelines, and supporting the modernization of enterprise data platforms.

Requirements

Key Responsibilities
- Design, develop, and maintain scalable data warehouse solutions using Snowflake.
- Develop robust and optimized ETL/ELT pipelines for ingesting, transforming, and loading data from multiple source systems.
- Lead and execute Oracle-to-Snowflake migration activities, including data assessment, mapping, transformation, validation, and reconciliation.
- Analyze existing Oracle databases, stored procedures, ETL workflows,



and data models to determine appropriate migration strategies.
- Design and implement effective data models, schemas, tables, views, and data structures in Snowflake.
- Develop SQL queries, transformations, and data processing workflows while ensuring performance and maintainability.
- Optimize Snowflake workloads through appropriate warehouse sizing, query optimization, clustering, partitioning, and resource management.
- Build data pipelines that ensure data quality, reliability, accuracy, and timely availability for downstream analytics and reporting.
- Perform data validation and reconciliation between Oracle and Snowflake during migration and post-migration activities.
- Collaborate with data architects, analysts, application teams, and business stakeholders to understand data requirements.
- Troubleshoot data pipeline failures, performance issues, and data quality problems.
- Establish and follow best practices for data security, governance

📌 Snowflake Data Engineer (India)
🏢 Weekday AI
📍 India