| Company: | SolutionsIQ |
|---|---|
| Type: | Contract |
| City: | Redmond |
| This listing was posted by an external recruiter |
SQL Server Data Warehouse Tester- T-SQL, OLAP, Data Model
SQL Back-end tester needed for Data Warehouse Project. Database testing experience a must. Initial vendor contract through July 3, 2009.
The client supports a PQO (product quality online) composed of site and content managers and business managers from various groups.
Application Info:
Their Data Warehouse is a Terabyte in size and is composed of Support Site data, surveys, and various other customer data built on SQL 2005. They use SSAS to generate reports from the DW, Excel pivot tables and SSRS. They don’t have anyone creating great reports, so just using SSRS.
They have a separate metadata ETL framework with data being brought in by Info brought in using SSIS, which has a set of properties defined in SQL tables (Attributes, objects, etc.).
Qualifications
* Should be able to follow the logic in the DB and understand data model to be able to trace data back through ETL process
* Have DB testing experience
* Be able to read, write and debug T-SQL statements
* Look at a report and know it makes sense, ie, here are 3 numbers that should total a bigger number, but the report doesn’t reflect that
* Ideally, have OLAP and DW testing experience
APPLY ONLINE:
agilerecruiter.solutionsiq.com/ag...php
/j99908
