• Excellent SQL Server Development & Maintenance experience (Ver. 2008/2012)
• Strong control over designing and developing backend functionality in SQL Server 2005 with development experience of DDL statements and DML statements, Transact SQL (T-SQL) Coding, writing queries, stored procedures, cursors & triggers.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers.
• Involved in ETL architecture enhancements to increase the performance using query optimizer. • Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.