Previous Job
Previous
SSIS Developer
Ref No.: 18-54983
Location: Birmingham, Illinois
Position Type:Full Time/Contract
Start Date: 08/02/2018
Skills
• Sound overall experience in Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2/2012/2016
• Extensive Development experience in design, development and deploying the necessary SSIS components
• Experience in preparing detailed Data Mapping information to be used for migration using SSIS
• Proven experience in creating reusable SSIS packages to extract data from multi-formatted flat files and XML files
• Experience in creating complex ETL packages using SSIS to extract data from Staging tables to partitioned tables with incremental load
• Hands-on experience in performing Data Reconciliation, Validation and Error handling operations post data extraction
• Strong SQL Programming experience with proven expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.

Role -
• Responsible for Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2/2012/2016
• Responsible for design, development and deploying the necessary SSIS components
• Responsible for preparing detailed Data Mapping information to be used for migration using SSIS
• Responsible in creating reusable SSIS packages to extract data from multi-formatted flat files and XML files
• Responsible for creating complex ETL packages using SSIS to extract data from Staging tables to partitioned tables with incremental load
• Responsible for performing Data Reconciliation, Validation and Error handling operations post data extraction
• Responsible for SQL Programming experience with proven expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors