Hello Partner, Hope you are doing great.
Please let me know your Updated profile for the below position. Please send me resume ASAP khalandhar....@gmail.com *Position: **Data Quality Specialist * *Location: **BethPage NY* Interview: *phone and F2F REQUIRED – no skype Need Locals* Duration: 3-6+ months *Responsibilities & Duties:* They must have ETL, OBIEE, DW, AND STRONG AUTOMATION TESTING along with SQL 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 -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-vendor+unsubscr...@googlegroups.com. To post to this group, send email to sap-vendor@googlegroups.com. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.