Innovations technological

Hi

Hope you are doing great.

Please find the requirement below , If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number 609-378-1162

Job Title: SSIS ETL Architect

Job Location: Long Beach, CA

Duration: 6+Months

Mode of Interview: Phone Then Skype

SSIS ETL Architect

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 SQL Server 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 and Regards,

Sarthak Bhatia

Sr. Technical Recruiter

Nityo Infotech Corp.

Email: sarthak.bhatia@nityo.com

Phone: 609-378-1162

Gtalk: sarthak.ramy@gmail.com

LinkedIn: https://www.linkedin.com/in/sarthak-bhatia-80a28aa5

666 Plainsboro Road, Suite 1285 Plainsboro, NJ 08536

http://www.nityo.com

USA | Canada | India | Singapore | Malaysia | Indonesia | Philippines | Thailand  | UK | Australia / Zealand 

_______________________________________________________________________________

Nityo Infotech has been rated as One of the top 500 Fastest growing companies by INC 500

_______________________________________________________________________________

Disclaimer: http://www.nityo.com/Email_Disclaimer.html