EDW QA Tester — Banking Data Warehouse (Medallion)

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

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.