Senior Snowflake Data Engineer
Bangalore
6+ Years

We are seeking a highly experienced Senior Snowflake Data Engineer / Migration Lead to drive an enterprise-scale Oracle Database to Snowflake migration. The ideal candidate will have hands-on experience designing and executing Oracle-to-Snowflake migrations and solid expertise in Snowflake, Oracle SQL/PLSQL, Apache Airflow, Parquet, and modern data engineering.
This role will be responsible for migrating not only data, but also database logic, business rules, and data pipelines, while ensuring data quality, performance, scalability, and a smooth production transition.

Key Responsibilities
Lead the end-to-end Oracle-to-Snowflake migration, including assessment, architecture, development, testing, cutover, and stabilization.
Analyze Oracle schemas, tables, views, stored procedures, packages, functions, triggers, and dependencies and translate them into Snowflake.
Design and implement scalable Snowflake data models, ELT pipelines, ingestion frameworks, and transformations.




Convert Oracle SQL/PLSQL and database logic into optimized Snowflake SQL and modern cloud data patterns.
Develop production-grade Apache Airflow DAGs for data ingestion, transformation, scheduling, dependencies, monitoring, and error handling.
Design efficient Parquet-based data pipelines, including extraction, staging, loading, partitioning, compression, and schema evolution.
Evaluate and implement Snowflake Hybrid Tables for appropriate transactional/operational workloads.
Identify, document, and migrate business rules embedded in Oracle PL/SQL, ETL processes, database objects, and application logic.
Determine appropriate implementation of business rules using
Snowflake SQL, Python, dbt, Airflow, or a Business Rules Engine (BRE).
Build automated data reconciliation, validation, and business-rule regression testing between Oracle and Snowflake.
Perform Snowflake query, warehouse, pipeline, and data-load performance optimization.
Collaborate with a

📌 Data Engineer (India)
🏢 Sourcebae
📍 India