Looking for a job

Aditya Oak

@adityaoak

I build AI-ready data platforms and modernize enterprise ETL systems.

At IAT Insurance Group, I modernize legacy actuarial reporting into Microsoft Fabric, Python, and Spark workflows, reducing 30,000 lines of SQL into a modular framework and building foundations for RAG and GraphRAG knowledge bases.

Across Capital One, CVS Health, Thermo Fisher Scientific, and Vsoft Consulting, I've engineered high-scale ETL, cloud migrations, orchestration, and data validation—supporting billions of records, reducing AWS spend by $20,000 monthly, and automating operational work.

Experience

Work history, roles, and key accomplishments

Current

Sr. BI Data Engineer

Current

IAT Insurance Group

Sep 2024 - Present (2 years)

Leading modernization of legacy ETL pipelines and infrastructure for AI-readiness, including migration to Microsoft Fabric and implementation of RAG and GraphRAG knowledge bases.

Python Spark SQL GitHub Co Pilot RAG Graph RAG Microsoft Fabric Airflow PySpark Pandas Openpyxl JSON Git Azure DevOps

Sr. Test Data Engineer

Capital One

Apr 2022 - Sep 2024 (2 years 5 months)

Architected ETL strategies for over 2,500 datasets, managed 1 billion+ records, and reduced AWS costs by $20,000 per month. Led a team of junior engineers and streamlined 500+ stakeholder requests.

ETL Apache Spark Snowflake AWS EC2 SnowSQL Parquet Avro CSV Data Validation Team Leadership

Data Orchestration Specialist

CVS Health

Jul 2021 - Mar 2022 (8 months)

Spearheaded migration of workflows from Teradata to GCP and Azure, audited DAGs in Airflow, and built ETL solutions in Python and PySpark. Implemented MD5 hash validation for data fidelity.

GCP BigQuery Azure Airflow Python PySpark ETL MD5 Data Validation

Sr. Data Engineer

Thermo Fisher Scientific

Sep 2020 - May 2021 (8 months)

Led distributed data processing on Databricks with PySpark, developed SQL extraction pipelines, and designed Power BI dashboards for revenue and campaign performance.

Databricks PySpark SQL Oracle Redshift Power BI Data Modeling

Automation Solutions Engineer

Vsoft Consulting

Aug 2019 - May 2020 (9 months)

Developed an automated Python extraction engine for Tableau, built CI/CD pipelines in Azure Data Factory, and architected Snowpipes for real-time data synchronization.

Python Tableau Azure Data Factory Snowflake Snowpipe CI CD ETL