Hi, Please check and let me know.
*Position: Sr. SQL Developer/Data Analyst Location: New York, NY Length: 12+ months Interview: Phone screen then Face to Face Interview DESCRIPTION: * *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* -- Best Regards Mohit Arora [email protected] *201-620-9700* ** 152 * -- You received this message because you are subscribed to the Google Groups "Vendors" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/vendors. For more options, visit https://groups.google.com/d/optout.
