BI/BW QA Tester: SAP Hana (JB1137)
Location: Fully remote for candidates living in South Africa
Salary: Contractor R450.00 per hour | Permanent R65 – 72 000 per month
Duration: Permanent or Contract
Our client is a global IT Engineering Consulting firm whose services expand into the logistics, insurance, retail, banking, and telecommunications industries.
We are currently looking for a candidate to join their organisation in either a Contractor or Permanent capacity to engage in projects with their clients. Previous experience in the retail or logistics sector is preferred and candidates living outside of Cape Town must be willing to travel to Cape Town twice a month for a 1 – 2-day period.
The successful candidate will be required to perform testing activities for the implementation of business solutions, defect fixes and system enhancements for the Business Intelligence stream for a retail client.
Particular focus towards data quality and validity for a SAP BW system will require that the candidate has strong SQL skills and a good understanding of various data flows to also contribute innovative ways to enable efficient and reliable data testing services.
· Responsible for validating the data sources, extraction of data, applying transformation logic, and loading the data in tables.
· Working experience in ETL testing including Data Completeness and Data Quality for various data feeds coming from the source
· Experience in Data Warehousing / BI Testing
· Working knowledge of SQL and relational databases
· Working experience with developers, support, offshore/onshore for various testing activities including test case/scriptwriting, clarification, data load, etc
· Good understanding of various data models
· Good knowledge of Data Warehousing concepts
· Experience in creating Stored Procedures, Functions, Tables & handling big data
· Experience on working of Joins, Subqueries, CTEs and complex query writing skills
· Using data analytics tools to validate data such as Eclipse, SAP Analysis for Office
· Advanced experience in Microsoft Excel
· Extensive experience in writing and troubleshooting SQL Queries
· Develop automated test scripts for testing ETL, Data warehouse and BI layers
· Perform SQL validation to verify the data extracts in the database tables by writing SQL queries
· Design and execute test cases to verify functionality, data integrity, security and overall usability of the solution
· Provide Test Metrics, reports and schedules for Automation & Manual test activities
· Work experience in SAP BW testing/development roles
· Work experience with SAP HANA and SQL Server with advanced SQL skills
· Experience in ERP systems
· Graduate/Postgraduate (BSc, or equivalent professional qualification) in IT, Computer Science, Engineering or related disciplines
· Strong analytical and problem-solving skills
· Ability to communicate with senior executive level stakeholders
Please email CV to firstname.lastname@example.org and quote JB1137 in the subject line
View and apply for this and other vacancies online via freerecruit.co.za Companies can expire their jobs at any time at their own discretion and without notice. Please beware of recruitment scams in the market. If something seems out of place about the company or agency please Contact us immediately or report it to the Department of Labour or your nearest South African Police Services.
Share this job post
Business Analyst (JB1158) Durban R30 000 – R37 000 per month Role Purpose and Objectives: To manage and support...Apply For This Job
Bachelor’s degree plus minimum of one year experience working within an office environment and or with database management. Demonstrated ability...Apply For This Job
Senior PHP Developer (JB1167) Location: Randburg, Johannesburg Salary: Negotiable up to R70 000 per month cost to company + bonus...Apply For This Job
This internship program is suitable for those with little or no experience and those who are temporarily in employment. The...Apply For This Job
Reference Number CG-874 Description This position is primarily responsible for repairing equipment to a fully functioning condition by performing the...Apply For This Job
A rapidly growing business who is the first-of-its-kind in its industry is currently seeking for a Scrum Master to join...Apply For This Job