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
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
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.
No comments:
Post a Comment