SQL objects such as Tables, Complex Stored Procedures, User- defined Functions, Views, Indexes, Triggers, Rules, and SQL Performance Tuning to facilitate efficient data manipulation and consistency.

Creating and executing SQL Server Integration Service packages to populate data from the various data sources, and packages for different data loading operations.

Creating SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.

Designing ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loading the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).