🤖 15+ AI Agents working for you. Find jobs, score and update resumes, cover letter, interview questions, missing keywords, and lots more.
Cookies & analytics consent
We serve candidates globally, so we only activate Google Tag Manager and other analytics after you opt in. This keeps us aligned with GDPR/UK DPA, ePrivacy, LGPD, and similar rules. Essential features still run without analytics cookies.
Read how we use data in our Privacy Policy and Terms of Service.
🤖 15+ AI Agents working for you. Find jobs, score and update resumes, cover letter, interview questions, missing keywords, and lots more.
Cognizant • Toronto, Ontario, Canada
Salary: C$80,000 - C$90,000 / year
Role & seniority: Senior ETL Tester (permanent)
Stack/tools: ETL testing; Python automation; SQL (Advanced), Oracle, Hive; Unix/Linux; data warehousing concepts; test frameworks/tools (Cucumber, Robot Framework, SoapUI, Selenium, TestNG); data validation, data quality checks
Design, develop, and execute test plans/cases for ETL, data warehouses, data lakes, and reporting
Automate test areas/features using the existing framework; build Python scripts; estimate effort
Validate data mappings/transforms, perform complex data validation and quality checks; identify/discrepancies and collaborate to resolve
6–10 years in Data QA/ETL Testing (banking domain preferred)
3+ years automated testing with Python
Strong SQL/Oracle/Hive, complex query writing; ability to compare large datasets
Data warehousing concepts; back-end/log reading; Unix/Linux familiarity
Experience with multiple test automation frameworks and Python scripting
Banking domain experience
Linux shell scripting
Location & work type: Hybrid in Toronto, Canada; 4 days/week in client or Cognizant office; eligible to work in Canada without sponsorship
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, SQL and a strong proficiency in Python automation. 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.
In this role, you will
Design, develop, and execute comprehensive test plans and test cases for data-centric applications, ETL processes, data warehouses, data lakes, and reporting solutions. Conduct thorough testing of ETL (Extract, Transform, Load) processes, ensuring data is accurately extracted, transformed according to business rules, and loaded correctly into target systems. 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 advanced SQL queries to perform complex data validation, data reconciliation, data integrity checks, and data quality assurance across various financial data sources. Implement and monitor data quality checks, identify data discrepancies, anomalies, and inconsistencies, and work with development and business teams to resolve issues. 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 Data Quality Assurance, Data Testing, or ETL Testing roles 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. Solid understanding of data warehousing concepts, ETL processes, and various data testing strategies (eg source-to-target mapping validation, data transformation testing, data load testing, data completeness, data accuracy). 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.
We're eager to meet people who share our mission and can make an impact in various ways. Don't hesitate to apply, even if you only meet the required skills listed. Your transferable skills and experiences matter—help us see how you the right person for this role.
Total Compensation
We regularly assess market data to ensure we offer a competitive compensation package for our associates. The base salary for this position ranges between CAD 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.
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 client or Cognizant office in Toronto, province. Regardless of your working arrangement, we are here to support a healthy work-life balance though our various wellbeing programs.
The working arrangements for this role are accurate as of the date of posting. This may change based on the project you’re engaged in, as well as business and client requirements. Rest assured; we will always be clear about role expectations.
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.
Applications for this position are reviewed by our recruitment team without the use of artificial intelligence screening tools.