Direct Client Requirement :: SSIS Developer :: Troy, MI :: 6 months

Hello,

Hope you are doing well
Please go through the following requirement and please let me know on ashah@cybsearch.com if you have any available candidate.

 

Role: SSIS Developer

Location: Troy, MI

Duration: 6 months w/option for additional time

 

Overview:

The SSIS Architect MUST have prior hands-on experience designing and setting up of ETL environments (dev/qa/prod) and leading/delivering successful Data Migration/Data Warehousing. This individual should have skills to participate in all aspects of the Data Migration/ETL development lifecycle using Microsoft BI technology, with emphasis on Data Quality Services implementation and ETL development. The individual will be working with the data architects/DBAs, and the development team to deliver the artifacts and the code.

 

Requirements:

1. Must have 2+ years of experience in architecting and setting up of ETL environments using SQL Server 2008 - 2012 and SSIS
• SQLServer 2008 - 2012 (MUST)
• Strong in T-SQL, Stored Procedures
• Thorough knowledge and experience with XML and ability to generate, parse and modify XML

 

2. Participate in customer team meetings and conversations with client personnel to understand business and technical requirements including requirements definition, data quality, ETL (SSIS), and development, testing, deployment, and post-deployment support.
• Create and maintain a variety of related artifacts (e.g., requirements, process models or diagrams, data matrices, project deliverables).
• Create High Level Design
• Create Detailed Technical Design
• Understand Business Requirements and Conceptual Solution
• Convert Business Requirements into Technical Requirements and Design

 

3. Should be able to create the following ETL content
• Be able to profile and create a data quality baseline assessment
• Create the data transformation & cleansing rules
• Create Source to Target Mapping Specifications
• Source to Target Mapping Specifications
• SSIS ETL scripts
• Understand the source systems and conduct the data profiling

 

4. Must be able to conduct Unit Testing and create Unit Testing Results Documents
• provide Support for QA/UA Testing
• Some experience in configuration management

 

5. Must be able to interface effectively with all levels of the organization.
6. Must have excellent interpersonal skills and be strong and effective communicator

 

 

 

Thanks,
Arjun
Cybersearch Ltd
ashah@cybsearch.com

Hangout : arjunshah.rec@gmail.com

 

 

 

This email was sent using GroupMail