We are seeking a detail-oriented and experienced BI Tester to join our dynamic team. The successful candidate will play a critical role in ensuring the accuracy and reliability of our Business Intelligence (BI) solutions through comprehensive testing processes.

What you’ll do:

The Business Intelligence Tester will join the QA team and work closely with the business analysts, developers, and project managers in the business intelligence delivery stream.

  • All manual testing activities during all phases of the SDLC from analyzing 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 the 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 tests 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.

Qualifications Required:

  • Relevant IT/ Testing qualification.
  • ISTQB.
  • Data/SQL Certification preferred.

Skills Required:

  • Advanced skills in MS Excel, formulas, and pivot tables
  • Experience working with JIRA, Confluence, etc.
  • Experience with Business Intelligence (BI) reports like Microsoft Power BI or Tableau.
  • Experience in complex ETL mappings, applets, 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.
  • Ability to work within a team following different development methodologies/ hybrid.
  • E2E Data Validation.
  • E2E Testing (Planning, Analysis, Design, Execution, Defect Management, Re-testing, Test closure).
  • ETL mapping and complex data testing.
  • Strong SQL.
  • Data Warehouse Testing.
  • Reconciling data to source.
  • Testing reports.

Other information applicable to the opportunity:

  • Level/ year’s experience: Intermediate – Senior (5+ years).
  • Location: Cape Town – hybrid way of work.

Desired Skills:

  • Adaptability
  • Authenticity
  • Partnership
  • Ingenuity
  • Mastery

Learn more/Apply for this position