Parth Panchal

Curriculum vitae

Resume

Data platform engineering — roughly seven years across Oracle, Snowflake, and orchestration tooling.

Download PDF Get in touch

Experience

Technical Project Lead — Data Engineering

2021 — present

  • Led a multi-entity Oracle-to-Snowflake migration covering a dozen business units, including stored-procedure conversion and medallion-layer redesign.
  • Built an automated cross-system validation framework that compares source and target metrics nightly and reports directional mismatches with tolerance handling, cutting manual reconciliation to near zero.
  • Designed incremental Gold-layer dynamic tables and null-safe SCD2 change detection patterns used across the platform.
  • Audited an inherited orchestration project for reachability from scheduled entry points, identifying several hundred unreachable jobs for retirement.

Data Engineer

20XX — 2021

  • Built and maintained ETL pipelines in Oracle PL/SQL and ODI.
  • Delivered internal training material on SQL, PL/SQL, and orchestration fundamentals.

Skills

Warehouses — Snowflake, Oracle, dimensional and medallion modelling Orchestration — Matillion, ODI, scheduled pipeline design Languages — SQL, PL/SQL, Python Practices — data validation and reconciliation, SCD2, incremental loads, CI for data

Education

Your degree, your institution

20XX