At Hexaware Technologies, I design parameterized, metadata-driven Azure Data Factory pipelines for the SSIS-to-ADF cloud migration project with Ernst & Young (EY). I integrate data from REST APIs, SFTP, ADLS Gen 2, and SQL Server, and process it in formats including JSON and Parquet.
On the GFIS cloud migration and purge project, I developed pipelines to migrate Oracle Financial data to Azure and implemented purge logic using PySpark and SparkSQL. I reduced notebook runtime by 60% through performance tuning.
For the Deltek Data Warehouse project, I implemented a Star Schema with SCD Type 1 and 2 and developed T-SQL objects for reporting. I also automated ETL scheduling with Control-M and SQL Server Agent.
