Job Description

Purpose of the role

Help test a bank's new enterprise data warehouse, built in layers: Bronze (raw source data), Silver (cleaned and integrated data) and Gold (business-ready data and data marts). You also help migrate historical and current data from the legacy warehouse and check that it arrived complete and correct. This is an entry-level role: you work alongside experienced EDW testers and the Data Migration Lead, who coach you, so you learn data warehousing and data testing hands-on in a large banking programme.

Key responsibilities

Run test cases written by senior testers, and help write simple ones from the mapping and design documents.
Bronze: check that source files arrive, load fully and match the agreed layout.
Silver and Gold: run SQL checks on transformation rules, keys, duplicates and report totals, and compare results with the legacy warehouse.
Run record counts and totals from source to