Sign in

Data Warehouse/ ETL Tester

Company:
vTech Solution Inc
Location:
Middle River, Maryland, United States
Posted:
March 15, 2019

Description:

The tester/QA will test the reports and dashboard developed by the developer and QA must validate data's, Data quality.

More on side of Data Warehouse / BI testing

SSMS - Management Studio experience required; experience with SQL Queries

Should be quick to understand the Data discrepancies and inform the management.

Strong test case and scripts development experience.

Any Database and BI experience is fine

QA will be involved in Data analysis and Data governance too..

•Need to be able to speak clearly and concisely to directors, executive directors, and chiefs both written and verbally.

•Need to be able to navigate a data warehouse.

•Not an expert, but must have the ability to write basic SQL commands preferably using Microsoft SQL Management Studio, understand table relationships, read data models, and know how to aggregate data.

•Also, an intermediate understanding of Excel is needed to be able to navigate data sets and run functions against them.

•Will be validating data files, data warehouse loads, reports, dashboards, and cubes.

The Data Warehouse Team is looking for 2 Quality Assurance Analyst. These positions will:

•Support the Data Warehouse Team in testing data extracts, reports, and dashboards to ensure data quality before release.

•Create, execute, and monitor test plans including tracking and documenting findings.

•Creating test scripts using SQL programming to validate data points against transactional systems and the data warehouse.

•Help to implement a formal QA process including creating templates and documenting standards/processes.

•Collaborating with business owners and subject matter experts to clarify requirements and to complete user acceptance testing.

•Creating documentation needed to support repeatability of testing metrics.

The ideal candidate will have the following skill set as described in the contract:

•2+ years of testing experience

•5+ years of SQL programming experience

•Experience using Excel including vlookup, pivot tables, and basic formulas

•Strong analytical, organizational, and team skills

•A bachelor’s degree in Computer Science, IT, MIS, Business Management, Engineering, Project Management, or related field. This may be substituted with relevant experience of 5+ years.

•Ability to work on multiple priorities and meet project delivery dates

•Knowledge of Software Development Lifecycle (SDLC)

•K-12 education experience preferred but not required

•Ability to effectively communicate with all levels of users and teammates both written and verbally

•Ability to analyze and interpret requirements and file layouts into test cases

•Ability to work independently and as part of a team

•Ability to perform unit, system, and performance testing

•Ability to produce status reports and communicate status of projects on a regular basis