Functional Test Analyst - Data warehouse (EDW)

Two95 International Inc.; Kuala Lumpur; On-site; MYR 150,000 - 200,000; Full time

Job summary

An established industry player is seeking skilled functional test engineers to join their dynamic team. In this role, you will be integral to the integration testing of various e-commerce platforms for a leading bank in Singapore. Your expertise in data warehousing concepts, ETL processes, and SQL will be crucial as you collaborate with stakeholders to develop comprehensive test plans and execute tests across the enterprise data warehouse architecture. This position offers an exciting opportunity to contribute to innovative projects in a fast-paced environment while continuously improving testing practices. If you are passionate about quality assurance and eager to make an impact, this role is perfect for you.

Qualifications

• 4-5 years of software testing experience required.
• Proven experience as a Data Warehouse Tester or similar role.

Responsibilities

• Collaborate with stakeholders to gather requirements and define test scenarios.
• Execute tests across different layers of the EDW architecture.

Skills

Software Testing

Data Warehouse Testing

SQL Queries

Analytical Skills

Communication Skills

Team Collaboration

Scripting Languages (Python, Bash)

Tools

Testing Tools

Job description

Project Description:

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

Skills required:

1. 4-5 years of software testing experience
2. Proven experience as a Data Warehouse Tester or similar role, with a solid understanding of data warehousing concepts, ETL processes, and database technologies.
3. Proficiency in writing SQL queries for data validation and testing.
4. Strong analytical skills and attention to detail.
5. Excellent communication and collaboration abilities.
6. 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.

Responsibilities:

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.