Datawarehouse Tester

Droisys; Richardson (TX); On-site; USD 75,000 - 95,000; Full time

Job summary

A technology services company is seeking a Data Warehouse Tester in Richardson, TX. This role involves designing and executing test strategies, developing documentation, and ensuring requirements traceability. The candidate must have strong SQL and data analysis skills, and familiarity with testing methodologies is essential. Excellent communication skills are vital, and knowledge of Teradata and DB2 is preferred. The position also requires the ability to manage tasks under tight deadlines.

Qualifications

• Data warehouse testing experience is necessary.
• Understanding of database design and implementation is required.
• Experience in writing shell scripts in Unix environments.

Responsibilities

• Design and develop test strategy and plans for data warehouse.
• Execute test scripts and communicate test results effectively.
• Participate in requirements process with user community on UAT.

Skills

SQL

Data Analysis

Communication Skills

Analytical Skills

Problem-solving Skills

Tools

Teradata

DB2

AIX

MS Office

Job description

Location: Richardson, TX[Local Required]

Phone + Face to face required

Desired Start Date: ASAP 12+ months

Position Description:

Responsible for data warehouse and enterprise report testing. Primary responsibilities include designing/ developing test strategy and plans, and executing test scripts. Specific data warehouse test experience is necessary utilizing manual and automated testing skills. Must be well versed in using Test Script Repository, Test Execution, Defect Reporting, Tracking and Resolution capabilities. Excellent skills in communicating test results and ability to work with other teams responsible for supporting test issue resolution. Participates in the requirements process with the user community on UAT (user acceptance testing) definition and develops detailed documentation to facilitate transition from ST to UAT.

Job Requirements:

Specific data warehouse testing experience is necessary. Understanding of database design and implementation. Must have excellent SQL and Data Analysis Skills. Clear and concise verbal, written and interpersonal skills including the ability to work in teams. Ensure traceability of test cases to requirements. Analytical and problem-solving skills coupled with initiative and accountability. Knowledge of testing methodologies and the Software Development *Life Cycle including Agile development methodology. Experience with scheduling tool such as ASG Zena (not necessary) Zena, something similar. Experience in writing shell scripts in Unix environments. Experience in creating automated scripts to create test data. Relational Database Experience. Experience with the implementation of Dimensional Model(s). Strong Data Analysis skills and the ability to track a data element from source through transformation to target. Excellent communication skills. Ability to work with, assist and support project team.

Good communication skills and ability to manage tasks with tight deadlines

Teradata and/or DB2 SQL (strong SQL skills required)

Familiarity with AIX, Windows and MS Office

Familiarity with Dimensional Modeling and Data Mapping

Health Insurance knowledge helpful

For additional support to work on the Medicare Advantage project

Additional Information

All your information will be kept confidential according to EEO guidelines.