QA Tester - Ottawa, Canada - Datawind Consulting Inc.
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:
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).
More jobs from Datawind Consulting Inc.
-
Business Process Deployment Coordinator
Ottawa, Canada - 3 weeks ago
-
QA Tester
Ottawa, Canada - 3 days ago
-
Project Manager
London, Canada - 2 weeks ago
-
Technical Business Analyst
Ottawa, Canada - 1 week ago
-
Project Coordinator
Ottawa, Canada - 3 weeks ago
-
System QA Specialist
Ottawa, Canada - 3 weeks ago