One of the largest Financial Service Providers in South Africa provides insurance, investment, financial planning & retirement advice to individuals, groups. As the Business Intelligence Tester you will join their Quality Assurance team and work closely with the business analysts, developers, and project managers in business intelligence delivery stream

Description of Role
All manual testing activities during all phases of the SDLC from analysing business requirements to designing and executing test cases in different environments.

Creating and updating test cases to meet the business functional requirements using HPALM/QC
Verifying the accuracy and credibility of data from ETL Process, staging tables, BI reports and dashboards
Performing manual execution of the test cases within all test cycles (Unit, System Integration, UAT, Regression, Smoke)
Performing manual execution to verify dashboard customization requirements. Performing load and performance test to ensure that data flows and mapping are not corrupted.
Performing manual execution to verify that logs are updated.
Performing manual execution to verify that reports generated are accurate
Perform back-end (database) testing using complex SQL queries on Oracle and SQL Server databases.
Capturing and demonstrating test execution business end users for approval
Making use of defect tracking tools such as JIRA to log, manage, resolve, and report on bugs/defects.
Participating in scrum ceremonies such as sprint planning, retro etc.
Providing progress feedback in daily stand-up meetings
Minimum Requirements:
Minimum 5 years of solid software testing experience
Bachelor’s degree in computer science or equivalent qualifications
ISTQB Certification advantageous
Advanced skills in MS Excel, formulas, and pivot tables
Experience working with JIRA, Confluence, and other collaborative tools advantageous.
Experience with Business Intelligence (BI) reports like Microsoft Power BI or Tableau
Experience in complex ETL mappings, mapplets and complex transformations testing.
Exposure to end-to-end data validation for ETL and BI systems
Exposure to DB tools like Toad/PL SQL developer/SQL Plus/SQL server management studio
Experience in Business Intelligence testing in various reports
Strong in SQL scripting, data issues root cause analysis skills and Data Warehousing concepts
Strong Data warehouse end to end and data completeness testing experience.
Strong Ability to work within team following different development methodologies/ hybrid.
Ability to handle multiple tasks simultaneously.

Competencies:
Ability to work in a fast-paced environment with minimal supervision.
Sense of ownership and pride in your performance and its impact on company’s success
Critical thinking, problem-solving and prioritization skills
Attention to detail.
Demonstrated problem analysis and problem-solving skills in a technical environment.
Excellent written and oral communication skills are required.
Good time-management skills
Great interpersonal and communication skills
Results Driven flexible (able to adapt to change