QA Data/ETL Tester

QA Data/ETL Tester

Rate: Open

Location: Chicago, IL

Hybrid: 2 days on-site, 3 days remote

Duration: 6-12+ months (open to Contract-to-hire)

Qualifications

Bachelor's degree

At least 3-5 years of professional experience on a variety of projects in Test Strategy, Test Design, Test Execution analysis & reporting.

experience with writing queries in relational databases like Oracle and SQL server.

with SQL server queries including calling stored procedures by passing parameters, functions, views, and indexes to be used during ETL process.

extensive and in-depth knowledge of developing SQL scripts using SQL functions, grouping operations, sub queries, analytical function and joins to test ETL projects.

testing using SQL server Integration Services (SSIS) and SSRS.

in testing database applications to validate source to destination data movement and transformation.

of automated data testing is preferred.

experience in Planning and Manual test execution.

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, to facilitate requirements refinements.

Identify issues in data, application configurations and screen designs, report and oversee issue resolution.

Become an expert in business rules, system functionality and architecture.

Plan and execute Manual, Functional, and Regression test suite.