Experience with and deep knowledge of Visual Studio 2012 and later, SQL Server Integrations Services (SSIS), SQL Server Data Tools (SSDT), and SQL Server Management Studio (SSMS).
Experience with performance profiling and optimization of SSIS, SQL Server queries, stored procedures, triggers, and functions.
Perform data cleansing/scrubbing and transformation of data to ensure data quality.
Develop SSIS packages to extract, transform and load data to enterprise-level data warehouses and data mart databases.
Use various containers, tasks, transformations, connection managers, script task to develop SSIS packages.
Gather requirements working with business analyst, developers, database architect and business users.
Developed complex and extended stored procedures and user defined functions in SQL Server.
Optimize existing SSIS packages with options like delay validations, buffer sizes, parallel processing and maximum concurrent executions etc.
Experience deploying SSIS packages into various environments (development, test, and production).
Experience with the import and export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
Experience with Sybase ODBC connectivity, queries, stored procedures, and triggers desired but not required.
Experience with all areas of .NET development including server-side, client-side, data retrieval, and management.
Good communication skills.
Analytical and problem-solving skills.
Develop technical changes / enhancements based on specifications provided.
Research, test, and recommend how to properly adopt new technologies.
Ensure that all development projects adhere to strict development guidelines including testing, acceptance and rollout