← Back to projects

Professional Experience

Legacy Migration Platform

Resumable ETL from Azure SQL to PostgreSQL

2022 - Present

Overview

Batch migration platform designed to move legacy operational data into a modern PostgreSQL schema with reliability, security, and auditability.

Tech Stack

PythonPostgreSQLAzure SQLDockerAzure Blob StorageAES-256-GCM

Key Contributions

  • Implemented checkpoint-resume flow and dry-run modes for safer long-running migrations.
  • Added target schema preflight validation to fail fast before writes.
  • Built normalization logic for inconsistent source data and idempotent upsert patterns.
  • Secured PII fields with encryption and key-management aware configuration.