Senior ETL Tester with Python Automation Experience

Cognizant; Toronto; Hybrid; CAD 80,000 - 90,000; Full time

Job summary

A leading technology solutions provider is seeking a Senior ETL Tester for a permanent position in Toronto. The ideal candidate will have extensive experience with ETL processes, Python, and SQL, playing a key role in enhancing automated testing. Responsibilities include designing test plans, automating test scripts, and managing data quality checks. The role supports a hybrid work arrangement with flexibility, and offers a competitive salary ranging from $80,000 to $90,000 annually, along with bonuses and benefits.

Benefits

Performance-based bonus

Well-being programs

Flexible work arrangements

Qualifications

• 6-10 years of experience in ETL/DW Testing within the banking domain.
• Minimum 3 years in automated testing with Python.
• Experience with SQL and complex SQL queries.
• Strong ETL process knowledge and skills.

Responsibilities

• Design and develop test plans and scripts for ETL processes.
• Automate test areas and provide estimations.
• Develop Python scripts for data validation.
• Perform data quality checks and manage data efficiently.

Skills

ETL Testing

Python

SQL

Automated Testing

Unix/Linux Commands

Test Automation Frameworks

Data Validation

Tools

Cucumber

Robot Framework

SoapUI

Selenium

TestNG

Job description

Overview

We are looking for a Senior ETL Tester to join our team for a permanent role. The ideal candidate will have deep hands‑on experience with ETL, Python and a strong proficiency in SQL. You will play a critical role to enhance our automated regression testing coverage, maintain our test automation framework and ensuring the accuracy of large datasets, validating ETL processes, and contributing to automation initiatives across projects.

Responsibilities

• Design, develop, and execute test plans, test cases, and test scripts for ETL processes.
• Automate assigned areas/features using the existing Framework and provide the test estimations, build automation scripts using Python & Unix.
• Develop Python scripts to automate data validation and transformation tasks.
• Develop automated test scripts using SQL, Python, or other testing frameworks.
• Utilize SQL or any database querying language to compare, manage and manipulate data efficiently.
• Perform data quality checks and identify anomalies across multiple sources.
• Write optimized SQL queries and stored procedures for data extraction, transformation, and loading.
• Validate data mappings and transformations to ensure they meet business requirements.

Required skills

• Overall 6-10 years of hands‑on experience in handling ETL/DW Testing projects in the banking domain.
• Minimum 3 years of experience in automated testing with Python.
• Must have good experience with SQL database and writing complex SQL queries.
• Must have strong ETL process/SQL, ORACLE, Hive complex query writing skills.
• Ability to compare large datasets using SQL, Python.
• Strong understanding the database concepts (indexes, constrains, normalization).
• Familiarity with Back end data flows.
• Ability to read backend logs/application logs.
• Must have Unix/Linux command knowledge.
• Experience in a variety of test automation frameworks/tools e.g., (Cucumber, Robot Framework, SoapUI, Selenium, TestNG) and script development using Python.

Preferred skills

• Experience in the banking domain is a plus.
• Experience with Linux and shell scripting.

Working Arrangements

We believe hybrid work is the way forward as we strive to provide flexibility wherever possible. Based on this role’s business requirements, this is a hybrid position requiring 4 days a week in a Cognizant or client office in Toronto. Regardless of your working arrangement, we are here to support a healthy work‑life balance through our various well‑being programs.

We strongly encourage you to apply even if you only meet the required skills listed. Consider what transferrable experience and skills make you a unique applicant and help us see how you’d be beneficial to this role.

Cognizant will only consider applicants for this position who are legally authorized to work in Canada without requiring employer sponsorship, now or at any time in the future.

We regularly assess market data to ensure we offer a competitive compensation package for our associates. The base salary for this position ranges between 80,000 – 90,000 per year. Where the successful candidate may fall within the range depends on relevant education, work and/or management experience and other business‑related and job‑necessary qualifications. This position is also eligible for Cognizant’s discretionary annual performance‑based bonus, as well as benefits that support your physical, mental and financial wellbeing.