EDW Tester (Bronze, Silver and Gold)

Click Global Talent

📍 Kuala Lumpur, Malaysia On-Site ⏳ 3d ago
AI assistant

Job Description

Purpose of the role

Test the bank's new enterprise data warehouse on Huawei DWS, built on a Medallion architecture. Bronze (ODS) holds source-aligned history from up to 76 source systems; Silver holds integrated, cleansed data; Gold holds business-ready data and data marts. You confirm that data flows correctly through each layer, follows the mapping and business rules, and matches the legacy warehouse where it has been migrated.

Key responsibilities

  • Write test scenarios and cases from the STTM, functional and technical design specs and SCD design, traced in the RTM.
  • Bronze (ODS): test file arrival, size, control records, schema against the agreed layout, duplicate files, load completeness and history retention for each source.
  • Silver: test transformation and integration rules, keys, deduplication, reference data, SCD handling and data quality rules.
  • Gold and data marts: test business rules,