ETL/Automation Tester with Wealth Management Experience

CGI; Toronto; Hybrid; CAD 85,000 - 110,000; Full time

Job summary

A leading IT and business consulting services firm is seeking an ETL/Automation Tester with expertise in Wealth Management. This hybrid role involves data validation, automation framework development, and collaboration with cross-functional teams to ensure high-quality testing in complex financial environments.

Qualifications

• 5+ years of experience in Quality Engineering with a focus on data validation and automation.
• Mandatory Wealth Management experience.
• Strong knowledge of ETL processes and database systems.

Responsibilities

• Collaborate with teams to design effective test strategies.
• Perform comprehensive ETL testing and backend testing with SQL.
• Develop automation frameworks using tools like Selenium.

Skills

Cucumber

ETL

Jira

Selenium

SQL

Test Planning & Implementation

Software Architecture

Wealth Management

Tools

Selenium

TestNG

Cucumber

Maven

Java

Eclipse

IntelliJ

Job description

ETL/Automation Tester with Wealth Management Experience

This role is hybrid and requires you to be at our downtown Toronto and/or Client office at a minimum 4 days per week - subject to change at any time.

We are seeking a highly skilled and experienced ETL/Automation Tester with a strong background in Wealth Management to join our team. The ideal candidate will bring deep expertise in data validation, automation frameworks, and backend testing, with a proven track record of delivering high-quality solutions in complex financial environments.

Your future duties and responsibilities:

• Collaborate with cross-functional teams to understand business requirements and translate them into effective test strategies.
• Design and implement robust test plans and test cases aligned with user stories and technical specifications.
• Perform comprehensive ETL testing across various data sources including databases, XML, and flat files.
• Conduct backend/database testing using complex SQL and PL/SQL queries; create and validate stored procedures and functions.
• Develop and maintain automated testing frameworks (data-driven, keyword-driven, hybrid, or BDD) using tools such as Selenium, TestNG, Cucumber, and Java.
• Generate detailed test reports using tools like Allure or Extent Reports.
• Utilize tools like JIRA, Confluence, Bitbucket/Git, and test management plugins (e.g., X-ray, Zephyr) to manage test artifacts and track defects.
• Analyze testing scope, estimate effort, and ensure timely delivery of quality assurance activities.
• Ensure data integrity and accuracy across systems by understanding data models and data flow within Wealth Management platforms.

Required qualifications to be successful in this role:

• 5+ years of experience in Quality Engineering with a focus on data validation and automation.
• Mandatory Wealth Management experience with a deep understanding of financial products and services.
• Strong knowledge of ETL processes, data warehousing concepts, and database systems.
• Proficiency in SQL/PLSQL for backend testing and data validation.
• 3+ years of experience in designing and building automation frameworks.
• Hands-on experience with Selenium, TestNG, Cucumber, Maven, Java, and IDEs like Eclipse or IntelliJ.
• Familiarity with test reporting tools such as Allure or Extent Reports.
• Excellent analytical, problem-solving, and communication skills.

Skills:

• Cucumber
• ETL
• Jira
• Selenium
• SQL
• Test Planning & Implementation
• Software Architecture
• Wealth Management

What you can expect from us:

Together, as owners, let’s turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.

Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Come join our team—one of the largest IT and business consulting services firms in the world.

About the company

CGI Inc., also known as CGI Group Inc.,

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at [e-mail] or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report . NYC applicants may request an alternative process or accommodation at [e-mail] or 407-000-0000.