Need.. SSIS ETL Architect

SSIS ETL Architect

Long Beach, CA

6+ months Contract

Interview process: 1 phone interview

 

Description

The SSIS Architect/Developer MUST have extensive hands-on experience designing and setting up of ETL environments (dev/qa/prod) and programming/leading/delivering successful Data Migration/Data Warehousing.

This is a hands-on SSIS development position with SSIS ETL architecture experience as well.

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 will be responsible for the overall ETL design and SSIS programming.

The ideal candidate should have strong analytical, problem solving, and communication skills with a keen attention to detail.

This person must have strong professional consulting skills and the ability to communicate well at all levels of the organization.

 

Required Expertise In Tools & Technologies

SSIS (MUST)

SQLServer 2008 - 2012 ( MUST)

Strong understanding of Data Quality (MUST)

Strong in T-SQL, Stored Procedures

 

Other Skills/Experience Required

More than 6 years experience as ETL Developer using SSIS and SQLServer 2008 - 2012 to implement data warehousing/data migration projects.  Must have extensive experience creating and scheduling SSIS packages and SQL stored procedures.

At least 4 years of experience in architecting and setting up of ETL environments using SQLServer 2008 - 2012 and SSIS (MUST)

Experienced with ETL process control and reconciliation (Audit/Balance/Control) design

MUST HAVE strong SQL skills in SQLServer/T-SQL, stored procedures and package development

SSRS report developer development skills would be a big plus.

A strong knowledge of data quality concepts and implementation experience

Excellent understanding of data migration and warehousing concepts including performance optimization, scheduling dependencies, restart ability, auditing, error handling, etc.

Candidate should be able to clearly communicate fundamental concepts during the interview and demonstrate previous experience in all aspects.

Experience in tuning SQLServer queries/processes and performance management tools

Strong business and communication skills

 

Responsibilities

The Senior Developer should be able to perform the following with minimal supervision:

This is a hands-on SSIS developer and ETL architect position.

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).

Understand Business Requirements and Conceptual Solution

Convert Business Requirements into Technical Requirements

Create High Level Design

Create Detailed Technical Design and Understand the source systems and conduct the data profiling

Be able to profile and create a data quality baseline assessment

Create the data transformation & cleansing rules

Create Source to Target Mapping Specifications

Create SSIS ETL scripts to Conduct Unit Testing and create Unit Testing Results Documents o Provide Support for QA/UA Testing and Experience in configuration management

Provide warranty support and assist and resolve production issues

The Senior Developer should have the following leadership skills:

Provide hands on technical leadership

Establish standards and defined processes for Error Handling and audit/balance/control process

Contribute for process and performance improvements

 

Thanks & Regards

Sunny Mehta

Team Lead- US Staffing & Recruitment

Nityo Infotech Corp.

Direct: 609-378-1235

Email: sunny.mehta@nityo.com

 

GTalk: sunny.recruiter2012 | Skype: sunnymehta89| Yahoo: sunnymehta89

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.