EDW Tester (Entry Level)

Click Global Talent; Kuala Lumpur; On-site; MYR 48,000 - 72,000; Full time

Job summary

Click Global Talent is seeking an entry-level EDW tester in Kuala Lumpur to learn data warehousing and data testing in a large banking programme. You will support migration from legacy systems and verify data across Bronze, Silver and Gold layers under the guidance of experienced testers and the Data Migration Lead.

You will run test cases, execute SQL checks, perform record-count verifications, and document results and defects.

Qualifications

• 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).
• 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.

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.

Skills

SQL

Data testing

English communication

Attention to detail

Education

Bachelor's degree in CS/IT/Data Science

Tools

DataStage

Informatica

Talend

SSIS

Job description

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.

Reporting line

Reports to the Test Lead. Takes direction from the Data Migration Lead on data migration and validation work.