• Supported the data migration from Heterogeneous sources and different formats to relational data warehouses, staging databases using complex stored procedures, SSIS packages as well as command prompt scripts
• Expertise in Data Extraction, Transforming, and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Bulk insert, and BCP for Enterprise Data Warehouse (EDW)
• Skilled in creating SSIS packages providing specific functionality like Data Profiling, and Data Cleansing for clean ETL process and population Data Warehouse, and Data-Marts
• Well-versed in configuring Master-Child packages for Dynamic execution using proper SSIS package configurations
• Optimized the performance of slow executing SSIS packages by modifying Control Flow and Data Flow to avoid blocking transformations and increase the buffer size
• Developed SSIS package template to accelerate similar development practices are followed by other SSIS developers for logging, configuration, and error handling
• Designed and implemented complex ETL strategies using SSIS packages that extracted the data from sources like Flat files, and Excel files
• Designed SSIS packages to transfer data between servers, load data into the database, and archived data files from various heterogeneous sources such as SQL Server, Excel, CSV on SQL Server 2008R2