Description:
Purpose of the role:Anayze solution architecture and design documents including source to target, and detail design documents needed to plan test design activitiesTechnical SkillsTesting/Agile Tools: Jira, ZephyrRDBMS (Databases): MS SQL Server 2023Scripting Languages: SQL scriptsOperating Systems: Microsoft WindowsMS Office: MS Word, MS Excel, MS PowerPoint, MS OutlookOther Tools: Box, Confluence, MigFX (advantageous)QualificationsDegree/Diploma in Information Technology, Computer Science, or similar ISTQB Foundation Certificate in Software TestingData analytics/analysis certification (advantageous)Skills Required:5+ years of experience in software testing having extensively worked in the entire testing life cycle, which includes designing, developing, and execution of the entire testing processInvolved in preparing the test plans, test strategy documents, test cases, and test scripts based on business requirements, rules, data mapping requirements and system specificationsExperience on functional testing, system testing, regression testing, integration testing, smoke testing, system integration testing (SIT).Involved in preparation of requirement traceability matrix (RTM), defect report, weekly/daily reports, test summary reportsExperience in data analysis, data migration, web interface testing, data validation, data cleansing, data verification, and identifying data mismatchExtensive experience in writing complex SQL queriesExpertise in Jira, Zephyr, Confluence, and BoxExcellent skills in logging and tracking defects via JiraExperienced in interacting with project managers, business analysts, UAT users, developers, and respective stakeholdersUnderstanding of data models, data schema, ETL, SQL queries to perform back-end data warehousing testingExperience in testing ETL LoadsKnowledge on the phases of agile methodologyExcellent interpersonal, communication, documentation, and presentation SkillsResponsibilities:Using SQL server to develop and execute test scripts in SQL, to validate the test casesResponsible for testing relevant loads of ETL jobsCreating test cases for ETL to compare source and target database systemsCreate test data to test all the scenarios and test cases plannedAnalyzing the testing progress by conducting walkthrough sessions with the relevant stakeholders/project teamsReview the test activities through daily stand-up meetingsValidate the target table column(s) definition with the source column(s) definationValidate database structures with the ERD (Entity Relationship Diagram)Hands on experience with using web service such as SOAPValidate data stage mappings that load files into staging tablesExtensive end-to-end data validation and back-end testing using SQL queries   Â
23 Apr 2024;
from:
gumtree.co.za