Ensure the quality of all solutions through functional, non-functional, automated, and AI-enabled testing practices, delivering sustainable quality, data integrity, and continuous improvement across the Data capability.
Key Responsibilities:
This person is responsible for end-to-end manual and automated testing for the business solutions. The solution should be tested in terms of functionality, performance, reliability, stability, compatibility and integration with other legacy and/or external systems.
- Assist with the testing gap analysis between requirements and existing environments accurately for all data capabilities.
- Ensure that user stories are clearly defined and written correctly with acceptance criteria in preparation for the backlog refinement meeting.
- Define quality standards upfront in the PI and sprint meeting and ensure they are achieved.
- Document the test plan prior to the start of any project or planned operational work and keep the test plans up to date.
- Document, maintain and monitor test scenarios, acceptance criteria and the final results.
- Create effective ETL test cases and scenarios based on ETL database loading technology and business requirements.
- Create effective dashboard/data visualization test cases and scenarios based on business requirements.
- Perform SQL queries, stored procedures, and test scripting to delete, define, load, and merge data for tests.
- Ensure that test cases are aligned to business data and metadata (data sources, data tables, data dictionary, business terminology).
- Demonstrate an understanding of data models, data mapping documents, ETL design, and ETL coding by using these resources to inform test cases.
- Troubleshooting of ETL (e.g., Informatica/DataStage) sessions, workflows, and logs
- Implementation of automated testing for ETL processes.
- Reporting on defects/bugs identified to all relevant team members.
- Continuously build test automation artifacts.
- Execute and maintain the manual and automation regression tests.
- Demonstrate deliverables to key stakeholders.
- Report on the team QA way of work, feedback on trends and solutions and continuously optimize the way of work to ensure effective and efficient QA practices in the team and with the company's Investments IT.
- Contribute to the team's predictability by maintaining a view of the teams holistic test coverage.
- Minimize team defects by ensuring upfront code quality.
- Drive collective ownership for testing.
- Ensure the agreed quality standard is always maintained.
- Leverage AI-enabled testing and automation tools to improve test coverage, accelerate test execution, and enhance defect detection across data solutions.
- Apply AI-assisted techniques to analyze datasets, identify anomalies, data quality issues, and testing trends, supporting proactive quality assurance.
Experience, knowledge and qualifications:
- Bachelor of Science: Computer Science or Statistics, or
- Bachelor of Science/Commerce: Information Systems or Informatics or
- Minimum: Diploma in Information Technology.
- Overall work experience: 8+ years
- 5+ years in BI and/or data analysis and testing
Competencies and skills:
- Working with people
- Presenting and communicating information (written and verbal)
- Applying QA and Technology expertise
- Analyzing, Planning and Organizing
- Ability to prioritize and sequence.
- Delivering results and meeting customer expectations
- Following instructions and procedures
- Coping with pressures and setbacks
- Can work in a team
- Able to multi-task
- Skilled with end-to-end testing
- Sharing knowledge
- Ability to drive and enable data quality
- Creating and innovating
- Persuading and influencing
- Learning & researching
- Adapting & responding to change
- Curiosity and adaptability in adopting emerging technologies, including AI-enabled testing tools.
- Ability to assess and validate AI-generated outputs for accuracy, quality, and business relevance.
- Continuous improvement mindset with a focus on leveraging automation and AI to enhance delivery efficiency.
Technical skills:
- Commercial/Cloud technology: AWS
- Data querying tools/languages: SQL
- Understanding of data mesh frameworks
- Intermediate understanding of analytics coding languages: Python, Java
- Understanding of Data Integrity validation and data testing methodologies.
- Must have very strong knowledge and extensive experience in MS Office.
- Must have experience in an Agile work environment.
- Expert integration testing skills
- Automated and/or manual testing certifications (e.g. Selenium or Cypress (Preferred))
- Exposure to AI-assisted software testing and quality engineering tools.
Skills
Working with people Presenting and communicating information (written and verbal) Applying QA and Technology expertise Analyzing, Planning and Organizing Ability to prioritize and sequence Delivering results and meeting customer expectations Following instructions and procedures Coping with pressures and setbacks Can work in a team Able to multi-task Skilled with end-to-end testing Sharing knowledge Ability to drive and enable data quality Creating and innovating Persuading and Influencing Learning & researching Adapting & responding to change Curiosity and adaptability in adopting emerging technologies, including AI-enabled testing tools Ability to assess and validate AI-generated outputs for accuracy, quality, and business relevance Continuous improvement mindset with a focus on leveraging automation and AI to enhance delivery efficiency Commercial/Cloud technology: AWS Data querying tools/languages: SQL Understanding of data mesh frameworks Analytics coding languages: Python Java Data Integrity validation and data testing methodologies MS Office agile work environment integration testing Automated and/or manual testing certifications (e.g. Selenium or Cypress) AI-assisted software testing and quality engineering tools