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.

Reply via email to