Back to jobs

Functional Test Analyst - Data warehouse (EDW)

Kuala Lumpur City Centre, Federal Territory of Kuala Lumpur, Malaysia

Actively hiring, first seen by us 2 days ago
Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Write test plans and test cases from functional and technical specifications

  • Execute tests across ETL processes, data models and reporting interfaces

  • Perform data validation and integrity checks against data quality standards

  • Run regression tests and automate test cases where applicable

  • Document test results, log defects and track them to resolution

From the employer’s posting
Develop comprehensive test plans and test cases based on functional and technical specifications.
Execute tests across different layers of the EDW architecture, including ETL processes, data models, and reporting interfaces.
Perform data validation, integrity checks, and ensure data quality standards are met.
Conduct regression testing to validate ongoing changes and enhancements to the EDW system.
Document test results, identify defects, and track issues to resolution using appropriate tools and methodologies.

What you’ll bring

All qualifications

Core experience

  • 4-5 years of software testing experience
  • Experience as a Data Warehouse Tester or similar role
  • Proficiency in writing SQL queries for data validation and testing
  • Understanding of data warehousing concepts, ETL and database technologies
  • Strong analytical skills and attention to detail
Qualification wording
4-5 years of software testing experience
Proven experience as a Data Warehouse Tester or similar role
Proficiency in writing SQL queries for data validation and testing.
solid understanding of data warehousing concepts, ETL processes, and database technologies
Strong analytical skills and attention to detail.
Apply at Two95 International

Posting record

Report an error

Actively hiringFirst seen by us 2 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20262 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Aug 9, 2024

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 2

Early. Similar jobs usually come down between day 5 and day 43.

From 15,995 similar postings that came down. Coming down is not always a hire.

Two95 International is hiring

30 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Bash
  • Python
  • SQL
Where the posting names them
Nice To Have: Knowledge of scripting languages (e.g., Python, Bash) for test automation. Requirements
• Proven experience as a Data Warehouse Tester or similar role, with a solid understanding of data warehousing concepts, ETL processes, and database technologies. § Proficiency in writing SQL queries for data validation and testing. § Strong analytical skills and attention to detail.

Your next step

Complete your application on apply.workable.com. The employer’s form will show what is required.

Applying through Workable

  • No account needed. You can import your resume to fill in the form, or skip that and fill it in yourself.

Already applied? Track this application

Job description

View original posting ↗

Project Description:

Leading bank of Singapore embarking on various e-commerce platforms integration project and looking for strong functional test engineers to work on integration testing.

Skills required:

• 4-5 years of software testing experience

• Proven experience as a Data Warehouse Tester or similar role, with a solid understanding of data warehousing concepts, ETL processes, and database technologies.

§  Proficiency in writing SQL queries for data validation and testing.

§  Strong analytical skills and attention to detail.

§  Excellent communication and collaboration abilities.

§  Ability to work independently and as part of a team in a fast-paced environment.

Nice To Have:

Knowledge of scripting languages (e.g., Python, Bash) for test automation.

Requirements

1.Test Planning and Preparation:

- Collaborate with stakeholders to gather requirements and define test scenarios.

- Develop comprehensive test plans and test cases based on functional and technical specifications.

- Ensure test cases align with business objectives and regulatory requirements.

 

2. Execution and Documentation:

- Execute tests across different layers of the EDW architecture, including ETL processes, data models, and reporting interfaces.

- Perform data validation, integrity checks, and ensure data quality standards are met.

- Document test results, identify defects, and track issues to resolution using appropriate tools and methodologies.

 

3. Regression Testing and Automation:

- Conduct regression testing to validate ongoing changes and enhancements to the EDW system.

- Automate test cases where applicable to improve efficiency and coverage.

- Maintain and update automated test scripts as needed.

 

4. Collaboration and Communication:

- Work closely with data engineers, business analysts, and project managers to understand requirements and project timelines.

- Communicate test progress, findings, and potential risks to stakeholders in a clear and timely manner.

- Participate in meetings, reviews, and discussions related to EDW development and testing efforts.

 

5. Continuous Improvement:

- Identify opportunities for process improvement and efficiency gains in testing practices.

- Stay updated with industry trends, best practices, and emerging technologies related to data warehousing and testing

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Kuala Lumpur City Centre, Federal Territory of Kuala Lumpur, Malaysia

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.