SQAFYI - Software QA Resource - FYI

US-CA-SanJose: Sr. Data Warehouse QA Engineer

To see other opportunities, please visit http://sqa.fyicenter.com
Date: 14-Nov-2013

Sr. Data Warehouse QA Engineer

Validate the actual data mart outputs against the intended outputs

Use your understanding of our business domain to identify and report anomalies

Setup multiple QA environments to work with fabricated source data, QA source data and production source data

Test SSAS cubes; execute and test SSIS packages

Configure SSIS packages for different QA setup environments

Modify the source data and test the changes in transactional & snapshot facts tables and also all types of dimension tables

Write Transact-SQL queries to stress test the Data Marts and implement/extend our automated regression test

Prepare test cases to test user requirements against the reports and Data Marts

Write equivalent Transact-SQL queries to validate Micro Strategy and SSRS reports

8+ year work experience in software quality assurance.

Masterís degree in computer science, information science or engineering is required

Experience testing products built in Microsoft SQL Server and the Microsoft Business Intelligence Stack (database engine, SSRS, SSAS and SSIS)

Experience defining and executing test plans along with documenting detailed test scripts.

Formal understanding of various QA methodologies

Familiarity with white-box (unit, integration and system level) and black-box testing

Developing automated test suites using Transact-SQL Programming

SQL Server Profiler

Data validation and exploration using MS-Excel and VBA

Micro Strategy reports and dashboards

Build test automation for Data warehouse testing

Any Microsoft platform programming language is a plus

To apply for this position, please visit this Website.

Thank you,
Team SQAFYI - Software QA Resource FYI

US-CA-SanJose: Sr. Data Warehouse QA Engineer