Qa Tester (c)

Ottawa, ON, Canada

Apply Now

Responsibilities:

ETL/Data test deliverables: Test Strategies, Test Plans, Test Cases and Test Script.
SQL query-based 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 SQL-based 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:
Candidates must clearly demonstrate the necessary skills and experience:

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.
d.) Designing, developing, implementing, and testing data solutions for reporting applications such as Power BI.

Preferred Qualifications

Experience working on large-scale 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 non-technical 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).

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.