At Capgemini India Pvt. Ltd., I develop and maintain SQL, Python, and dbt transformation workflows for Travelex across raw, curated, and enriched data layers.
I maintain fact and dimension tables using dimensional data modelling, and create Apache Superset dashboards for reporting. I also validate reporting data and investigate duplicates, missing records, and other data quality issues.
When records are missing, I extract them from source layers and load them into the curated layer on AWS. I use Apache Airflow to orchestrate pipelines and Git tools to manage version control and promote code from development to production.
