· Collaborating in an Agile Data Engineering team, utilizing technologies such as SQL, Informatica, Azure DataServices, and PL/SQL to innovate and refine ETL pipelines, optimizing data loading into the Data Warehouse.· Engineered an OAuth2-secured mapplet for data extraction from ODATA and SOAP APIs, serving as a crucialintegration tool organization-wide.· Implemented Azure Data Factory (ADF) pipelines for extracting files from Azure Data Lake Storage (ADLS)and enhancing data loading into on-premises database staging tables.· Migrated workflows from Informatica to Azure, significantly improving the dashboard's refresh rate andaligning with cutting-edge technologies.· Automated daily staging data cleanup, resulting in an annual cost savings of $21,624.· Designed a dashboard in MS Excel to monitor storage usage by the Data Warehouse, this helped in analyzingthe data usage by each module.· Designed scripts in PySpark for optimal extraction, transformation, validation and loading of data from a widevariety of data sources.