EDW Tester

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 Bronze to Silver to Gold for each business date tested.

•       Data migration: run extraction and loading jobs for historical and current data under the Data Migration Lead's plan, monitor runs, and report failures.

•       Migration validation: run SQL comparisons between the legacy and new platforms (counts, totals, record-level checks) and record the results.

•       Log defects with clear evidence and retest fixes.

•       Re-run checks as regression when new code is delivered.

•       Prepare test evidence and run logs for the senior testers reports.

Required skills and experience

•       Degree in Computer Science, Software Engineering, Information Technology, Data Science or a related field.

•       0 to 2 years of experience; fresh graduates are welcome.

•       Good working knowledge of SQL (select, joins, group by), from study, internships or projects.

•       Basic understanding of relational databases: tables, keys and data types.

•       Careful and methodical, with a willingness to learn and to ask questions.

•       Good written and spoken English.

Nice to have

•       Internship or project work with databases, ETL, data pipelines or software testing.

•       Exposure to data warehouse concepts (facts, dimensions, history tables) or any ETL tool (for example DataStage, Informatica, Talend or SSIS).

•       Python or shell scripting.

•       Interest in banking or financial data.

•       Chinese (Mandarin), spoken or written.