EDW Tester (Senior)

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, aggregations, derived measures and report totals; compare with Netezza output for the same business dates.

•       Run row-count and value reconciliation from source to Bronze to Silver to Gold for every business date tested.

•       Test the batch across daily, weekly, monthly, quarterly and yearly cycles, including month-end and year-end runs.

•       Test data quality rules as code: each rule gets a pass case and a fail case.

•       Run regression on every code drop, since releases share ODS tables, Silver and Gold models and the scheduler.

•       Log and retest defects in the Bank's ALM tool, and support the Bank's business users during UAT.

•       Support batch performance testing against the agreed batch window.

Required skills and experience

•       3+ years testing data warehouses, data lakes or ETL/ELT pipelines, preferably in banking.

•       Strong SQL on large volumes, including writing your own validation and compare queries.

•       Understands layered architectures (Medallion or staging, integration and presentation layers), dimensional models and SCD types 1 and 2.

•       Can read and test against source-to-target mappings and transformation rules.

•       Experience testing batch schedules and file-based ingestion.

•       Experience with a test management and defect tool (ALM, Jira or similar).

•       Good written and spoken English.

Nice to have

•       Huawei DWS or GaussDB, Greenplum, Netezza or another MPP database.

•       Sunline DataMind, IBM DataStage, Informatica or a similar ELT or orchestration tool.

•       Data quality testing (completeness, accuracy, validity, consistency, uniqueness, timeliness).

•       Banking domain knowledge: core banking, cards, treasury, trade finance or GL.

•       Python or shell for test automation.

•       Chinese (Mandarin), spoken or written.