• Having around 3.5 years of Experience in Business Application Software Development, involved in Development, Report Developing and Implementation.
• Exposure and expertise in Microsoft Business Intelligence tools like SQL Server 2012/15/2017 Integration Services and SQL Server 2012 Reporting Services
• Created mapping documents (i.e. for Source and destination), unit test case documents for SSIS ETL packages.
• Extensively worked on Data Extraction Transformation and loading the data from source to target system using SSIS.
• Created SSIS packages to load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Experience in integration of various data sources like MS Excel, SQL Server, Flat Files and files into the staging area.
• Proficiency at Data Transformations, Tasks, Containers, Sources and Destinations like Derived Column, Conditional Split, Sort and Merge Join Transformations to load data into Data Warehouse.