# Functional Test Analyst - Data warehouse (EDW)

> Two95 International Inc. · Kuala Lumpur City Centre, Malaysia · Full-time · Posted 2024-08-09

**Salary:** unknown currency 100,000–216,000

**Workplace:** on_site

**Department:** APAC

## Description

**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

## Apply

[Apply at Two95 International Inc.](https://apply.workable.com/two95-international-inc-3/j/453CE121A7/apply)

---
Powered by [Workable](https://www.workable.com)