Functional Test Analyst - Data warehouse (EDW)
At a glance
Mid-level QA & Test role at Two95 International Inc. Kuala Lumpur City Centre · full-time.
Pay not stated QA & Test salary
techroles summary, based on the employer's posting.
What you'll do
- Turn stakeholder requirements into test scenarios, plans and cases tied to functional and technical specifications
- Test ETL flows, data models and reporting interfaces, checking data validity, integrity and quality
- Record outcomes, raise defects and follow each issue through to resolution
- Rerun checks after EDW changes and automate suitable cases, maintaining scripts as needed
- Share progress, findings and risks with stakeholders while coordinating with data engineers, analysts and project managers
What you bring
- Four to five years of software testing experience
- Hands-on work testing data warehouses or similar, with knowledge of warehousing concepts, ETL and databases
- You can write SQL queries to validate data and support testing
Who this fits
This mid-level, onsite role in Kuala Lumpur suits someone who can work independently and collaborate with a project team. It focuses on integration testing for an EDW project.
From the employer
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