# Snowflake Data Engineer

> Weekday AI · India (Remote) · Full-time · Posted 2026-08-24

**Workplace:** remote

**Department:** Weekday's Client via platform

## Description

**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 efficient 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, documentation, and operational monitoring.
-   Contribute to the modernization of legacy data platforms and migration from traditional data warehouses to cloud-based solutions.

### Must-Have Skills

-   **5–8 years of experience in Data Engineering or Data Warehousing.**
-   Strong hands-on experience with **Snowflake Data Warehousing**.
-   Strong expertise in **ETL/ELT development and data pipeline engineering**.
-   Proven experience with **Oracle-to-Snowflake migration** projects.
-   Advanced SQL skills with experience working with complex queries, joins, transformations, and performance optimization.
-   Strong understanding of data warehousing concepts, dimensional modeling, fact and dimension tables, and data integration patterns.
-   Experience with data migration, reconciliation, validation, and troubleshooting.
-   Good understanding of cloud-based data platforms and modern data engineering practices.

### Good-to-Have Skills

-   Experience with ETL tools such as Informatica, Talend, Matillion, or similar platforms.
-   Exposure to Python for data engineering and automation.
-   Experience with AWS, Azure, or GCP data services.
-   Knowledge of Snowflake features such as Streams, Tasks, Snowpipe, Dynamic Tables, and Time Travel.
-   Familiarity with CI/CD, Git, and DevOps practices.
-   Experience working in Agile development environments.

### Qualifications

Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field is preferred.

The ideal candidate should be analytical, detail-oriented, and capable of working independently while collaborating effectively with cross-functional teams. Strong communication and problem-solving skills are essential for successfully managing complex data migration and engineering initiatives.

## Apply

[Apply at Weekday AI](https://apply.workable.com/weekday-1/j/41A532DC50/apply)

---
Powered by [Workable](https://www.workable.com)