BI Tester

JOBNUMBER

**iOCO02790**
- CONTRACT TYPE

**Contract**
- STATE/PROVINCE

**Western Cape**
- CONTRACT TYPE:
**Hybrid**

**The Role**:
**Skills and Experience**:
**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**:
**Other information applicable to the opportunity**:

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