Backend Etl Developer/etl Data Tester
Ottawa, ON, Canada
Job Description
b'
About the Job
Our Ottawa-based reputable client has an immediate requirement for an ETL Data Tester/ ETL Developer/ Backend Developer with focus on Data Test automation. The ideal candidate will have experience in extensive software development experience with ETL and Backend services and test automation. Experience with Data test automation that involves Azure Data platforms such as Databricks, Azure SQL Server, Azure Data Lake, Delta lake, and Azure Event Hub/Service Bus is an asset. The successful candidate will be working in a team environment, for a minimum of 1 year.
Online Job posting end date: Mar 15, 2023
Work environment: Hybrid with one day in the office
Responsibilities:
- ETL/Data test deliverables: Test Strategies, Test Plans, Test Cases, and Test scripts.
- SQL query-based data transformation test scripts involving PL/SQL
- 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 demonstrate the necessary skills and experience:
- Minimum 5 years of work experience writing test cases and test scripts based on documented data mapping and business data transformation rules.
- Minimum 5 years of work experience with various types of software testing such as functional, integration, system integration, performance, etc. for data transformation processes.
- Minimum 2 years of 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, and Azure functions.
- Minimum 5 years of 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 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.
Related Jobs
Job Detail
-
Job IdJD2128570
-
IndustryNot mentioned
-
Total Positions1
-
Job Type:Full Time
-
Salary:Not mentioned
-
Employment StatusPermanent
-
Job LocationOttawa, ON, Canada
-
EducationNot mentioned