Johannesburg, GP, South Africa
Data Warehouse Tester / QA Analyst
Cape Town, Western Cape
South African Citizens Only
PBT Group has a role for a data warehouse analyst who will be responsible for the testing and quality assurance of all data warehouse integration processes.
This will cover processes relating to the integration of data into the data warehouse as well the testing of data warehouse outputs, such as reporting.
The candidate will be required to develop test strategies and document and execute test plans.
There will also be a requirement to develop regression testing processes and standards for existing warehouse structures, with an emphasis on automation.
Duties and Responsibilities
Develop test strategies, plans, test cases and test scripts based on project requirements. Prepare test data sets and scenarios for evaluation. Execute regression, functional and integration tests. Track testing progress and work with the team to manage outstanding test cases. Establish standards and processes for testing. Support ongoing work to automate ongoing data quality and regression testing.
Experience and Qualifications
Minimum of 4 years’ in software/data testing and preferably within a data warehouse or business intelligence-related architecture, with a strong SQL proficiency for the purposes of interrogating data. T-SQL Excel Desired Qualification(s) Graduate in: Computer Science, Information Systems, Engineering, Accounting or Investment Management Desired Skills As a gatekeeper to data quality and reliability, a strong attention to detail will be required. An uncompromising attitude to quality and accuracy. A structured and methodical approach, ensuring testing is adequately documented. An ability to foresee risk and system inadequacies. A strong sense of ownership. Innovative in their approach to testing and ensuring ongoing data quality. The ability to communicate technical concepts and principles to co-workers. The ability to communicate with business stakeholders, particularly around testing strategies/approach, testing progress and cross-stream impacts. The ability to interpret business requirements and technical specifications to develop testing plans and strategies. Experience and understanding of financial markets. Willingness to mentor co-works and proven capacity to be mentored. Experience in Agile Software Development practices A strong SQL competency for the purposes of analysing and interrogating data. A strong competency of MS Excel for the purposes of analysing and visualizing data and testing results. Knowledge or experience of ETL practices, typical to a data warehouse, that would involve the transformation of data from disparate source systems into a standardised warehouse structure. A knowledge of data warehouse concepts, such as dimensional data modelling. An ability and desire to develop a thorough knowledge of the data warehouse structures and data coverage. Willingness to learn business domain and technology concepts to achieve team goals. Proven self-management; most notably in areas of time management and context shifting
Business Intelligence, Data Warehouse, Database Developer, Software Tester, Systems Tester