Data Warehouse (DWH) Tester Urgently

Data Warehouse (DWH) Tester

As a Data Warehouse Tester your goal is to validate and improve the quality of our client’s data infrastructure in a transparent and efficient way. This is an initial 6 month contract duration, working from home is a possibility during these difficult times but candidates must be open to working onsite if circumstances change. You will setup the test strategy and build the scripts to test the data from various sources, and support developers to setup their test scripts.

You have proven experience in DWH and BI testing in data validation, and typical test scenarios, and you have strong data analysis, SQL & data analytical skills. Preferably you have experience in testing the migration of an existing (Oracle) data warehouse to the Cloud. Your stack will, amongst others, consist of Azure related services (i.e.: Snowflake, Matillion, Azure functions, Data Factory, Databricks, Spark).The ideal DWH tester will work closely with our development team, and with our stakeholders in the business department

The ideal DWH Tester will have the following responsibilities

• Perform data analytical testing for the BI systems including functional testing and performance testing.

• Validation of data transformations and perform End-to-End data validation for ETL & BI systems.

• Own the test plan and test execution for a strategic and large datawarehouse migration project.

• Identify repeating test scenarios and code them into scripts.

• Design test scenarios for data comparison between environment that are quick to perform, reliable and simple.

• Develop Test strategy, test plan/design , execute test cases and defect management for the ETL & BI systems.

• Client-facing, Presenting the deliverables with project stake holders.

The ideal DWH Tester must have the following skills

• Knowledge of Cloud Computing, Big Data platforms (MS Azure Ecosystem) and BI solutions.

• Fluent in written and spoken English.

• Strong interest in Business Intelligence and Cloud Data Warehousing.

• Minimum 5 years of experience in Data warehousing environment/projects

• Minimum 5 years of experience in ETL & BI testing.

• Strong knowledge on ETL and BI processes.

• Strong in SQL preparation in Oracle /Snowflake RDBMS

• Strong in ETL data validation developed using ETL (PL/SQL, Matillion) environments.

• Strong in BI report validation developed using Cognos/Power BI.

• Bachelor or master degree with 5+ years of experience within IT.

• Understand complex data products which are built in PL/SQL.

• Requirement analysis and understanding of DWBI technical specification documents.

• Analyze and understand the ETL work flows developed.

• Should be strong in SQL and write complex SQL queries for validating business rules using Oracle/Snowflake scripts.

• Good problem solving & debugging.

Location

Amsterdam.

Contract duration

6 months.

Rates

Competitive.

If you are interested please feel free to send me your latest cv and contact details.