*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.me...@nityo.com *GTalk*: sunny.recruiter2012 | *Skype*: sunnymehta89| *Yahoo*: sunnymehta89 -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.
