Hi, We have an urgent requirement with one of my clients, details given below. If you find yourself suitable for the position, please send me your latest updated resume along with below required information.
*Role: Data Quality Specialist* *Location: Bethpage, NY* *Duration: 6 months +* *Phone screen then face to face interview * *GC / Citizen* The Data Quality Specialist will be expected to identify appropriate opportunities for Data Quality (DQ) automation of OBI solutions and develop associated test DQ frameworks and processes. In addition, this candidate will participate in the establishment of long-term improvement of testing processes and tools, as well as reviewing and improving requirements traceability to ensure appropriate test coverage. Work with project team in test requirements gathering and analysis. Work with Business Analysts, Data Quality Analyst, Developers, ETL and Data warehouse engineers to validate ETL scripts. Create stored procedures and queries to automate testing. Responsible for writing, executing and debugging SQL queries to perform data completeness, correctness, data transformation and data quality testing. Ensure content and structure of all testing documents artifacts are documented and maintained. Prepare review test conditions, test cases and test scripts. Execute test cases scripts. Log and track defects to closure *Responsibilities & Duties* Design of test scenarios and test plans to ensure that tests can be implemented and executed to validate ETL and BI/reporting requirements. Assist with creating project resource estimates, metrics to track completion phase, defect reports, defect prevention, development efficiency and quality. Run test validations at various levels including DB validation, logging validation, and UI validation. ETL testing requires writing SQL statements extensively by testing team or may be tailoring the SQL provided by development team. Upon successful completion prepare summary report and turnover for test results review. *End to end data quality process for ETL/BI and Reporting projects includes:* *Data Collection* a) Check compliance for data quality parameters like completeness, accuracy, consistency, etc. b) Risk assessment for integrating data in new applications. c) Ensuring that all data has been transformed correctly during the extract-transform-load (ETL) process. d) Ensuring that the ETL process correctly rejects, substitutes default values, corrects or ignores and reports invalid data. *Data Integration* e) Check compliance and define approach with custom SQLs for integration rules. f) Validate results based on business rules and integration rules. g) Provide data quality reports. *Data Mart* h) Validate all the measures and measure groups (including derived measures, aggregations). i) Validate all the dimensions (including Slowly Changing Dimensions), attribute hierarchy, etc. *Regression Testing* j) Ensuring existing functionality remains intact each time a new release of code is completed. *Data Presentation* k) Ensure data from the data mart is mapped & designed correctly for reports. Validate data for derived metrics and ‘non-aggregatable’ metrics *Qualifications* - Bachelor’s Degree in Computer Science, Mathematics, Statistics, other applied science field - *3-5 years analytical work experience* - *4+ experience in data quality testing, with a minimum 1 year experience in enterprise data warehouse environments* - Strong hands-on SQL coding experience - Experience testing data for data marts, data warehouses, and data integration solutions - Experience with ETL tools such as Informatica is a plus - *Experience in test automation using tools such as Query Surge, Trillion, QTP* - Excellent verbal and written communication skills - Good Excel, Powerpoint, Word and Visio skills - Experience of working with offshore or outsourcing teams is highly sought - Strong working knowledge of SQL – Able to query complex datasets and derive conclusions, including using all types of joins between multiple tables - Competency in data manipulation and analysis: accessing raw data in varied formats with different methods and analyzing and processing data. - Ability to communicate the results of analyses in a clear and effective manner - Positive attitude with lots of energy - Highly detail oriented and organized with the ability to multi-task and work in a very fast paced environment - Ability to exercise discretion on sensitive or confidential matters *Please send the following details along with the recent updated resume in word format.* Full Legal Name : Contact: Email: Current location (Complete address with zip code) Open to relocate or Location preferences: Currently in project: Availability to start : Visa Status with Validity Last 4 digits SSN Total Years of IT Experience: Experience working in US: Education (Passing year of Bachelors/Masters / University) Date of Birth Skill Set: Skype id: Thanks and Regards, Prabhpreet Singh (Prabh) | IT Technical Recruiter Technology Resource Group Inc. 3736 Hillsdale Court Santa Clara, CA 95051 Office:408-709-1760 Ext : 878 | Alternate :408-689-7776 Hangout: <http://www.tresourceinc.com/> prabh.us.itrecruiter| *YIM:* prabh.usrecruiter | Fax: 408-213-8316 prabhpr...@tresourceinc.com | www.tresourceinc.com -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to corptocorp+unsubscr...@googlegroups.com. To post to this group, send email to corptocorp@googlegroups.com. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
