Business Intelligence Tester – Cape Town (Contract) at Paracon

• 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.