Functional Test Analyst - Data warehouse (EDW)

Two95 International Inc.; Kuala Lumpur; On-site; MYR 60,000 - 80,000; Full time

Job summary

A leading financial services provider in Kuala Lumpur is seeking a strong Functional Test Engineer to join their team. The ideal candidate will have 4-5 years of software testing experience, with proven skills in data warehousing and SQL proficiency. This role requires excellent analytical abilities and effective communication skills, while working on integration testing for various e-commerce platforms. Competitive package and a collaborative work environment provided.

Qualifications

• 4-5 years of software testing experience required.
• Proven experience as a Data Warehouse Tester with strong understanding of ETL processes.
• Proficiency in writing SQL queries for data validation.

Responsibilities

• Collaborate with stakeholders to gather requirements and define test scenarios.
• Document test results, identify defects, and track issues.
• Conduct regression testing to validate ongoing changes.

Skills

Software testing experience

Data Warehouse Testing

SQL proficiency

Analytical skills

Communication abilities

Team collaboration

Tools

ETL tools

Test automation tools

Job 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.

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.

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.

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.

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.

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