Permanent QA Technical Tester: BI, Location, Other, Northern Suburbs, Advertised By Agency, Job Type Full-Time

Experienced Business Intelligence Technical Tester required. The successful candidate will be working together with the QA Manager and Test Lead to ensure that testing needs for all supported projects are met in a timely manner and that all software products meet the quality levels set by Business.

 Duties will include, but not be limited to: Test stored procedures, views, triggers and functions. Troubleshoot database and software interfaces. Deployment of SQL Server Integration Services and SQL Server Reporting Services. Troubleshooting performance related DB issues at both the SQL server and storage level. Review, analyse and identify test requirements based on the functional specifications from technical documentation (Business/Development briefs, Use Case Diagrams, Architectures and/or Integration Documents) and ensure full understanding of individual deliverables. Working with BI, Development & Product teams to understand the requirements and prepare QA documents pertaining to planning, design, implementation, execution and exit reporting. Proactively raise questions and seek resolution of outstanding clarifications required for testing. Create, document and maintain test scripts, test plans, test cases and test procedures around new and existing business requirements and technical specifications. Potential writing of custom test solutions (automated scripts, test harnesses, SQL scripts etc.) Hold and facilitate test plan/case reviews with Testing, BI, Development & Product Teams. Ensure that validated deliverables meet functional and design specifications and requirements. Troubleshoot with development team to identify, replicate, verify and report defects Performance, Load & Stress testing. Setup and maintain Automation for monitoring and regression. Perform regression and ad-hoc testing of system components potentially affected by system changes. Actively participate in daily Scrum and project planning meetings. Working together with QA Manager and Test Lead to ensure that testing needs for all supported projects are met in a timely manner and that all software products meet the quality levels set by Business. Communicate with Product Owners & PSA’s to ensure all QA projects are managed, tracked and delivered to customer expectations with highest quality standards, within required timelines. Provide management with metrics, analysis, and other relevant reports regarding the quality of testing. Identify any potential quality issues per defined process and escalate immediately to management. Create and maintain constant communication and healthy working relationships between BI, QA, and Product Teams.

Requirements Technical Skills: Experience with Database Lifecycle Management. Experience coding complex stored procedures (using T-SQL). Strong SQL Server Knowledge (2008 and above/2014 will be used). Experience with SQL Server (MCITP/MCSE/MCSA). Experience of BI processes. Experience with SQL Server Management Studio. Experience with SSRS (Reporting Services). Experience with SSIS (Integration Services). Experience with SSAS (Analysis Services). Experience is SQL Profiler. Experience with XML. Visual Studio. Familiarity with contemporary load/stress/performance/automation testing tools. Have knowledge on domain specific applications (eg Kibana, RabbitMQ, Mongo). Backend database testing, including validating stored procs, jobs and triggers. Good general Development programing knowledge. Good general IT knowledge. Understanding of systems and architecture (DB's, Servers, Networks etc.) Understanding of the Software Development Life Cycle (SDLC). Creative solving of technical problems and ability to translate technical requirements into test plans. Ability to focus on deadlines and deliverables – ensures the ability to find defects and bugs quickly. Ability to think abstract. Functional/Technical Skills. Experiences in Quality Management Software and Processes. MTM (Test Manger) or any test case tools. ISTQB. Knowledge and experience in technical aspects of software solution being tested. Back End Testing Experience (Black box & White box). Automation

Should you be interested please submit your CV together with your supporting documentation to: recruitment@surgo.co.za