I am happy to provide the following services
1. Design and Develop the ETL packages using SSIS (MSBI).
2. Design and Develop the architecture and solution for data migration using SSIS.
3 . Experience in data migration into SQL Server2005/2008 R2/ 2012/2014 from various heterogeneous sources e.g flat files (txt , csv), raw files, excels, databases etc
4. Robust experience in deploying the SSIS package - file system, MSDB database and SSIS Catalog development.
5. Design and Develop the reporting solution using SSRS.
6. Performance Tuning of SSIS packages.
7. Performance Tuning of T-SQL, procedures, functions and views in SQL Server.
8. Developed custom auditing and logging framework to track high-level execution details including package starting, ending, and failure times as well as row counts that assist in validating data volumes and processing.
9. Develop various supporting documents for successfully running and managing ETL jobs e.g SSIS Deployment Document , SSIS ETL package Execution document, SSIS ETL architecture document, Release notes document etc
Reviews For This Service