The Role
Lead an enterprise Oracle-to-Snowflake migration from assessment through production stabilization. Design Snowflake data models, ELT pipelines, Airflow DAGs, Parquet-based ingestion, and cloud data architectures. Convert Oracle SQL/PLSQL logic, stored procedures, and business rules into modern Snowflake implementations. Build reconciliation and regression testing, optimize performance, support CDC and incremental loads, and coordinate with architects, DBAs, application teams, QA, and business stakeholders.
Summary Generated by Built In
Position Overview
Key Responsibilities
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 strong 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.
- 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 architects, DBAs, application teams, business analysts, QA, and data engineering teams.
- Support production cutover, troubleshooting, and post-migration stabilization.
- 6+ years of overall database/data engineering experience.
- 3+ years of hands-on Snowflake experience.
- Proven experience delivering enterprise-scale Oracle-to-Snowflake migrations in production.
- Strong Oracle SQL and PL/SQL expertise, including stored procedures, packages, functions, triggers, views, and complex database logic.
- Strong Snowflake SQL, architecture, data modeling, and ELT experience.
- Hands-on Apache Airflow experience developing and operating production DAGs.
- Strong experience with Parquet and cloud object storage such as AWS S3, Azure Data Lake, or GCP.
- Experience with Snowflake Streams, Tasks, Snowpipe/COPY INTO, stages, and performance optimization.
- Hands-on experience with Snowflake Hybrid Tables is strongly preferred.
- Experience with large-volume data migration, incremental loads, CDC, reconciliation, and migration testing.
- Strong problem-solving, communication, and cross-functional collaboration skills.
- SnowPro Advanced: Data Engineer certification.
- SnowPro Core certification.
- Experience with a Business Rules Engine (BRE) or decision/rules-management platform.
- Experience migrating and modernizing business rules from Oracle/PLSQL.
- Experience integrating BRE with Snowflake and Airflow.
- Python and DBT experience.
- Experience with Oracle GoldenGate, AWS DMS, Fivetran, Qlik Replicate, Informatica, or similar tools.
- Experience with CI/CD, Git, and cloud data platforms.
- Snowflake security and governance experience.
Skills Required
- 6+ years of overall database or data engineering experience
- 3+ years of hands-on Snowflake experience
- Production experience delivering enterprise-scale Oracle-to-Snowflake migrations
- Strong Oracle SQL and PL/SQL expertise, including stored procedures, packages, functions, triggers, views, and complex database logic
- Strong Snowflake SQL, architecture, data modeling, and ELT experience
- Hands-on Apache Airflow experience developing and operating production DAGs
- Strong experience with Parquet and cloud object storage such as AWS S3, Azure Data Lake, or GCP
- Experience with Snowflake Streams, Tasks, Snowpipe, COPY INTO, stages, and performance optimization
- Experience with large-volume data migration, incremental loads, CDC, reconciliation, and migration testing
- Strong problem-solving, communication, and cross-functional collaboration skills
- Hands-on experience with Snowflake Hybrid Tables
- SnowPro Advanced: Data Engineer certification
- SnowPro Core certification
- Experience with a Business Rules Engine or decision/rules-management platform
- Experience migrating and modernizing business rules from Oracle or PL/SQL
- Experience integrating a Business Rules Engine with Snowflake and Airflow
- Python and dbt experience
- Experience with Oracle GoldenGate, AWS DMS, Fivetran, Qlik Replicate, Informatica, or similar tools
- Experience with CI/CD, Git, and cloud data platforms
- Snowflake security and governance experience
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Relanto is a global advisory, consulting, and technology-services partner that helps organizations navigate business transformation as artificial intelligence reshapes the business landscape. Founded in 2021, the company combines advisory expertise with consulting and technology services, operating across a global footprint that includes India and the United States. Its mission centers on applying AI and modern technology to evolving enterprise needs.
