Junior EDW Tester: Data Migration & Validation

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

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.