EDW Tester (Bronze, Silver and Gold)

Click Global Talent; Kuala Lumpur; On-site; MYR 67,000 - 112,000; Full time

Job summary

Click Global Talent is seeking a data warehouse QA tester to validate a Huawei DWS-based enterprise warehouse using a Medallion architecture (Bronze/Silver/Gold). You will confirm that source data, transformations and business rules are correctly implemented across all layers.

You will write test scenarios, execute batch runs from daily to yearly, perform reconciliations, and log defects in ALM/Jira while supporting UAT with business users.

Qualifications

• 3+ years testing data warehouses, data lakes or ETL/ELT pipelines in banking.
• Strong SQL on large volumes with own validation queries.
• Understand Medallion architecture and SCD types 1 and 2.
• 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.

Responsibilities

• Write test scenarios from STTM, functional and technical design specs and SCD design, traced in the RTM.
• Bronze (ODS): test file arrival, size, control records, schema, duplicates, 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.

Skills

SQL on large volumes

Data warehouse testing

Medallion architecture

Source-to-target mappings

Batch scheduling testing

Test management

English communication

Tools

ALM

Jira

Informatica

Job description

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.
• Banking domain knowledge: core banking, cards, treasury, trade finance or GL.
• Python or shell for test automation.
• Chinese (Mandarin), spoken or written.

Reporting line

Reports to the Test Lead. Works closely with the data engineers, business analysts and data modellers.