ETL Tester with DBT (Data Build Tool) - Canada based

Overview

$DOE
Contract - W2
Contract - term contract

Skills

ETL
DBT
Testing

Job Details

ETL Tester with DBT (Data Build Tool)

Ontario, Canada

Key Responsibilities:

Design and execute test plans and test cases for ETL processes and data pipelines.

Perform data validation across source and target systems to ensure transformation accuracy.

Perform Manual Data Quality checks, validations.

As and when required, develop and maintain automated test scripts for improved productivity.

Identify, document, and track data defects and anomalies.

Collaborate with development teams to resolve issues and improve data reliability.

Validate data models, business rules

Participate in requirements reviews, design walkthroughs, and release planning.

Required Skills & Qualifications:

5-10 years of experience in ETL testing, data validation, or data QA roles.

Strong proficiency in SQL for data analysis and validation.

Experience with ETL tools (e.g., Informatica, Talend, SSIS) and data platforms (e.g., Snowflake, Redshift, Big Query) is mandatory

Experience with DBT (Data Build Tool) and its testing capabilities is mandatory

Understanding of data warehousing concepts, data modelling, and data lineage.

Experience with test management tools (e.g., JIRA) and version control (e.g., Git).

Strong analytical and problem-solving skills.

Excellent communication and documentation abilities.

Preferred Qualifications:

Experience with automation frameworks for data testing.

Exposure to cloud platforms (AWS).

Knowledge of data governance, privacy, and compliance standards.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Aroha Technologies