Etl Developer
Current● Developed SSIS packages to incrementally load from various structured, semi structured (JSON), REST API, relational sources into SQL Server.● Created data pipelines using ETL/ELT mechanisms to fetch data from various sources and load it into target databases for analysis.● Worked on complex SQL scripts to parse through nested JSON data from API sources for data loads. ● Created SSIS workflows to load data from Azure blob storage to SQL Server and unload back to Blob Storage ●… Show more ● Developed SSIS packages to incrementally load from various structured, semi structured (JSON), REST API, relational sources into SQL Server.● Created data pipelines using ETL/ELT mechanisms to fetch data from various sources and load it into target databases for analysis.● Worked on complex SQL scripts to parse through nested JSON data from API sources for data loads. ● Created SSIS workflows to load data from Azure blob storage to SQL Server and unload back to Blob Storage ● Developed and optimized SQL scripts, Stored Procedures in SQL server and orchestrated the data pipelines with triggers. ● Hands-on experience in creating XML files using SSIS. Proficient in taking backups, monitoring, and scheduling SQL Server Agent jobs, as well as database migration and backups.● Captured detailed validation document for all the transformations implemented in SSIS and SQL Server scripts and documented development best practices to boost team efficiency. ● Utilized source control best practices on TFS for SSIS jobs and package management. Show less