Senior Data Engineer - Snowflake, PLSQL

Position Overview

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 architects, DBAs, application teams, business analysts, QA, and data engineering teams.
  • Support production cutover, troubleshooting, and post-migration stabilization.

Required Qualifications & Skills

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

Nice-to-Have 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.