Senior Automation Test Engineer (python + Etl/sql)

Senior Automation Test Engineer

We are looking for a Senior Automation Test Engineer to join our team for a permanent role. The ideal candidate will have deep hands-on experience with Python, Robot Framework 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 ensure the accuracy of large datasets, validating ETL processes, and contributing to automation initiatives across projects.

If you have a strong background in Python test automation and enjoy collaborative environment, we encourage you to apply.

In this role, you will:

• 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.
• 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.
• Responsible for automating functional test cases using existing framework and perform integration and regression testing using this framework.
• Responsible for improving automation for all project deliverables and for following defined processes and tools and alignment with overall QE strategy and framework.
• Support the implementation of the QE Program and overall QE process and standards through continuous test preparation and execution.

What you'll need to succeed (required skills):

• Overall 6-10 Yrs. of experience in test automation with at least 3+ yrs. of hands-on automation testing using Python and 4+ years using Java-Selenium Webdriver automation.
• Minimum 3 years of experience in automated testing with Python.
• Must have good experience with Robot Framework automation.
• 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.

What will help you stand out (preferred skills):

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

At Cognizant, we're eager to meet people who believe in our mission and can make an impact in various ways. 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.

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.

Note: 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.

What we offer:

• The chance to work with impact. Here, you're empowered to bring your biggest thinking to help our company and clients improve everyday life.
• Ownership over your career. Stay at the top of your game through our award-winning learning and development ecosystem. And when your ambitions change or we offer new opportunities, we help you pivot by providing reskilling, on-the-job learning and guidance to find new roles that might be a better fit.
• The opportunity to thrive on a high caliber team with heart. We celebrate each other's experiences and perspectives and promote a sense of belonging through our affinity groups and diversity and inclusion initiatives.
• A comprehensive total rewards package, including a competitive salary and pension plan with matching contributions.
• Flexible health and financial benefits to support you and your eligible dependents —from day one.
• True work-life balance. Be at your best through paid time off, flexible work arrangements, volunteering opportunities, social events, and so much more.

About us Cognizant is one of the world's leading professional services companies, transforming clients' business, operating, and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build, and run more innovative and efficient businesses. Headquartered in the U.S., Cognizant (a member of the NASDAQ-100 and one of Forbes World's Best Employers 2024) is consistently listed among the most admired companies in the world.

Other employment-related information 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, provincial or local laws.

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

Language requirements vary depending on roles, but we ask that all candidates have basic English proficiency for company-wide communications purposes. For roles based in Quebec, professional English proficiency is required, as you'll deliver services to and collaborate with stakeholders outside the province who may not speak French.