QA Tester - Ottawa, Canada - Datawind Consulting Inc.

Datawind Consulting Inc.

Verified Company

Ottawa, Canada

2 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Responsibilities:

-
ETL/Data test deliverables: Test Strategies, Test Plans, Test Cases and Test Script
:

SQL querybased data transformation test scripts.
Lead, manage, plan, and coordinate the ETL/Data testing activities: Test Strategies, Test Plans, Test Cases, and Test Scripts.
Write and execute complex SQLbased Test Scripts, on the Azure Databricks platform, for data warehouse/engineering processes based on documented data mapping and data transformation rules.
Record test execution results and evidence of test in Azure DevOps.
Ensure the test activities are planned and performed according to requirements and standards from the Test Center of Excellence.
Coordinate and support the business with User Acceptance Testing.
Lead defect triage meeting. Document defects, work with developers to resolve, and retest.
Develop technical system specifications and standard operating procedures documents.
Documented test results, defects, and execution result evidence.
Status reports of work in progress, accomplished and problems/issues encountered.

Qualifications:

Minimum 5 years work experience writing tests cases and tests scripts based on documented data mapping and business data transformation rules.
Minimum 5 years work experience with various types of software testing such as functional, integration, system integration, performance, etc. for data transformation processes.
Minimum 2 years work experience with Microsoft Azure data platform: Azure Databricks, SQL Databases, Azure Data Lake.

Experience with additional programming languages is an asset:
Scala, Python, R, SQL, Azure functions.

Minimum 5 years experience with the following:

a.) Experience in systems development with analysis, design, development, testing and deployment of software systems.
b.) Experience with the implementation of batch and stream data processing pipelines.
c.) Experience writing complex SQL queries, performance tuning and data optimization.

Preferred Qualifications

Experience working on largescale data analytics projects.
Experience with the development of Microsoft Power BI reports and dashboards.
Ability to communicate clearly in conversation and in presentations to both technical and nontechnical staff, and to provide updates to all levels of management and customer.
Experience with Agile sprint development using Azure DevOps.
Experience working with spatial data is an asset (nice to have).