Tanya Arya

Oracle to PostgreSQL Data Migration and Modernization

- Migrated data from Oracle to PostgreSQL by ingesting source data into the Data Lake, creating mirror tables, and building dbt models and transformations to load data into the consumption layer. - Developed and managed DAG-based data pipelines to move transformed data from the consumption layer to the serving layer, while performing data quality checks, error analysis, and issue resolution throughout development. - Impact: Supported the decommissioning of Oracle infrastructure, eliminating approximately INR 93 lakhs in annual Oracle licensing costs