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.

Reply via email to