Data Quality Test Engineer

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - Independent
Contract - 6 Month(s)

Skills

SQL
ETL
SSIS
SSRS
Jira
SQL Queries
SQL Server
Data Quality
Testing
Regression testing

Job Details

***We are unable to sponsor for this role***

***At the minimum year-long contract***

A prestigious company is on the search for a Data Quality Test Engineer. The Test Engineer will be responsible for ensuring the successful implementation of new features as well as improvement of existing functionality for data architecture projects. This includes Integration testing, Customer Data Quality testing, Data verification testing, Regression testing etc.

Responsibilities

  • Review business requirements, functional specifications, use cases, design, and architecture documents to create effective, value-add test plans.
  • Identify and close gaps, by assisting in QA discovery or analysis of a built or process, in order to facilitate requirements refinements.
  • Identify issues in data, application configurations and screen designs, report and oversee issue resolution.
  • Plan and execute Manual, Functional, and Regression test suite.
  • Independently develop, modify, and execute test plans based on requirements and design documents.
  • Identify, report and track defects and User Experience issues through a system of record.
  • Collaborate with external teams on root cause analysis.
  • Ensuring proper traceability from requirements to test artifacts.
  • Actively participate in requirements and code reviews.
  • Actively participate and drive improvements in Agile Scrum delivery.
  • Be a thought leader in the test design and execution arena (manual and automated).
  • Creation and input of test data, either manually or by using tools, programs, or masked production data to execute test cases.

Qualifications:

  • Bachelor's degree in Computer Science or related area.
  • At least 3-5 years of testing experience in data or ETL projects.
  • Strong experience with writing queries in relational databases like Oracle and SQL server.
  • Familiar with SQL server queries including calling stored procedures by passing parameters, functions, views, and indexes to be used during ETL process.
  • Possess extensive and in-depth knowledge of developing SQL scripts using SQL functions, grouping operations, sub queries, analytical function and joins to test ETL projects.
  • ETL testing using SQL server Integration Services (SSIS) and SSRS.
  • Experience in testing database applications to validate source to destination data movement and transformation.
  • Knowledge of automated data testing is preferred.
  • Hands-on experience in Planning and Manual test execution.
  • Experience in Regression Test Strategies, Regression suite maintenance and execution.
  • Hands-on experience with Jira, ALM, TFS/ADO or similar systems of record.
  • Hands-on experience in Agile and Waterfall methodologies.