Sr. ETL Tester with Python Automation Experience

About the Position

We are looking for a Senior ETL Tester with Python Automation Experience 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 in enhancing our automated regression testing coverage, maintaining our test automation framework, 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 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.

Requirements

Overall 7-10 years of overall testing experience with a focus on ETL/Data Testing projects in the banking domain.
Minimum 3 years of experience in automated testing with Python.
2+ years of hands-on experience in UNIX. Strong knowledge and expertise of Unix/Linux commands and scripting including file operations, manipulation, and compare.
Must have good experience with SQL databases and writing complex SQL queries.
Must have strong ETL process/SQL, ORACLE, Hive complex query writing skills.
3+ years of hands-on experience in SQL. Should be able to write complex joins, unions, case, and aggregations. Ability to compare large datasets using SQL, Python.
Strong understanding of database concepts (indexes, constraints, normalization).
Experience in a variety of test automation frameworks/tools (e.g., Cucumber, Robot Framework, SoapUI, Selenium, TestNG) and script development using Python.
Proficient with Quality processes, test deliverables, defining Test Strategies, Test Plans, and evaluating Risk Coverage.

Nice to Have

Experience in the banking domain is a plus.
Experience with AI/ML-powered testing tools and techniques.
Cloud platform experience (AWS, Azure, GCP).
Experience with Linux and shell scripting.

We Offer

Total compensation: The base salary for this position ranges between CAD 70,000 – 90,000 per year. 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: This is a hybrid position requiring 4 days a week in a client or Cognizant office in Toronto, ON. We strive to provide flexibility wherever possible.

About the Company

Cognizant (Nasdaq: CTSH) is an AI Builder and technology services provider, building the bridge between AI investment and enterprise value by building full-stack AI solutions for our clients. Our deep industry, process, and engineering expertise enables us to build an organization’s unique context into technology systems that amplify human potential, realize tangible returns, and keep global enterprises ahead in a fast-changing world. See how at www.cognizant.com or @cognizant.

Cognizant is an equal opportunity employer. Your application and candidacy will not be considered based on race, color, sex, religion, creed, sexual orientation, gender identity, national origin, disability, genetic information, pregnancy, veteran status, or any other characteristic protected by federal, state, or local laws.

If you have a disability that requires reasonable accommodation to search for a job opening or submit an application, please email [email protected] with your request and contact information.