*Send me your profile only at - **braj...@rgtalent.com <braj...@rgtalent.com>*
Hi, I have an urgent requirement with one of my clients, details given below. If you find your self suitable for the position, please send me your latest updated resume along with contact details. Please include your employer details as well. *Job Title* Sr. SQL Developer/Data Analyst *Project Location* Nyc, NY *Duration* 12 months /Contract *Skills Required and Job Description:* *MOI :: Telephonic + Face to Face* *Need USC, GC or EAD GC Only* *Notes from Manager: * * Write requirement documents. If I see data architect on the resume, or project management I am not interested in those people * In terms of sql querying - Data cleansing *** - Understand how the data is collected * Pension exp is a huge plus * I want someone who did Transactional Data Profiling and Cleansing of that Data .I need to see that they cleaned data in a live system for purposes of consumption in a live system. I need to see many years of experience doing specifically that type of work. * This is the type of bullet points I am looking for: - Identified Data issues that became evident during functionality testing. Defined targeted population, course of action, update logic, report layout and testing conditions for an additional 21 data cleanup initiatives ranging in effort from 1- 6 months each. - Identified and addressed recurring/ root cause issues that were affect Data Integrity. - Performed User Acceptance Testing (UAT) or both Data and Functionality Issues. *Senior SQL Server ETL (SSIS, SSRS) Developer* *POSITION SUMMARY* This position is for a Senior SQL Server ETL Developer who can work independently to develop and test very complex data cleansing scripts, SSIS data migration/conversion packages, SSIS Data Bridging programs and SSRS reports in support of a multi-phase legacy system replacement effort. The developer is expected to bring SQL Server development expertise and participate in design sessions with application engineers, ETL designers, data analysts and Quality Assurance resources. The developer will also be expected to perform advanced, in-depth analysis of database models, data integrity issues and programming requirements. *KNOWLEDGE, SKILLS AND ABILITIES* - Design, Develop and Deploy SSIS Packages - Design complex ETL using loop containers and data transformation tasks - Write complex T-SQL queries and also able to do data cleansing writing the same - Provide expert technical feedback to functional spec designers / business analysts - Tuning T-SQL queries to improve performance - Develop complex program logic using T-SQL - Lead and make design decisions to create simple, elegant and re-usable software components as a part of larger enterprise application framework - Demonstrated skill in understanding relational table design and applying optimized indexes - Detailed knowledge of Data Modeling, both relational and dimensional - Strong grasp of ETL protocols - Strong analytical and data management skills - Exposure to Data Profiling Best Practices - Conduct extremely thorough Unit Testing that yields very low defect code - Develop reports in SQL Server Reporting Services - Experience in Data Modeling and Data Analysis in MS SQL Server 2012/2008 - Ensure accuracy & integrity of data & applications through analysis, coding, writing clear documentation & problem resolution - Analyze & translate functional specifications & change requests into technical specifications. - Excellent written and verbal communication skills - Experience with legacy data migrations is greatly preferred - Experience with public retirement systems is also preferred - Experience with DB2 legacy systems is a plus - Advanced analytical and problem-solving ability is required for this position *EDUCATION AND EXPERIENCE* - Bachelor’s degree in the field of computer science or similar - A minimum of 8 years’ development experience with MS SQL Server, SSIS, SSRS is required Thanks & Regards, *Brajesh Kumar Singh* Technical Resource Specialist *RG Talent Inc.* 39120 Argonaut way Suite # 157, Fremont CA 94538 Phone : 510-443-0757 EXT- 178 Email : braj...@rgtalent.com Hangout : brajesh.rgtal...@gmail.com URL : www.rgtalent.com -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at https://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
