full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
- Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
- Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
- Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.
- Experienced in designing Star, Snow flake Schemas and OLAP cubes.
- Experienced in migrating data from one SQL Server version to another.
- Experienced in database server performance tuning and optimization of Complex SQL queries.
- An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
- Flexible and versatile to adapt to any new environment and work on any project.