ETL Quality Engineering Specialist with Wealth Management Experience

Position Description:

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

Your future duties and responsibilities:

Perform ETL Quality Engineering activities within the Wealth Management domain (Wealth Management experience is mandatory).
Validate data across multiple sources including databases text files XML files and other structured/unstructured formats.
Conduct comprehensive backend/database testing including writing and validating medium to high complexity SQL and PL/SQL queries functions and stored procedures.
Analyze testing scope define test coverage and provide accurate work estimates for assigned deliverables.
Understand end to end data flows and data models across integrated systems within the Wealth Management space.
Design test approaches and develop detailed test strategies and plans aligned with business requirements and user stories.
Develop and maintain automated testing frameworks (data driven keyword driven hybrid or BDD) to support continuous testing and delivery.
Build and maintain automation scripts using tools such as Selenium TestNG Cucumber Maven and Java (Eclipse/IntelliJ).
Utilize reporting frameworks such as Allure Extent Reports or similar TestNG based reporting tools.
Manage test cases test executions and defect tracking using Jira and Jira plugins such as Xray or Zephyr.
Collaborate with cross functional teams including business analysts developers architects and DevOps to ensure high quality delivery.
Provide clear communication of test results risks and progress to stakeholders.
Support CI/CD integration for automated test suites where applicable.

Required qualifications to be successful in this role:

Mandatory: Strong Wealth Management industry experience.
Minimum 5 years of experience in ETL/Data Quality Engineering with exposure to multiple data sources (databases text files XML etc.).
Solid understanding of database systems data warehousing concepts and ETL workflows.
Proven experience in backend/database testing with strong SQL and PL/SQL skills.
Minimum 3 years of hands on experience in designing and developing automated testing frameworks (data driven keyword driven hybrid or BDD).
Proficiency in Selenium TestNG Cucumber Maven Java and IDEs such as Eclipse or IntelliJ.
Experience with automation reporting tools such as Allure or Extent Reports.
Strong knowledge of Jira Confluence Bitbucket/Git and test management add ons like Xray or Zephyr.
Ability to analyze complex data flows and system integrations within Wealth Management applications.
Strong communication analytical and problem solving skills.

**CGI is providing a reasonable estimate of the pay range for this role. The determination of this range includes factors such as skill set level geographic market experience and training and licenses and certifications. Compensation decisions depend on the facts and circumstances of each case. A reasonable estimate of the current range is $65000$115000. This role is an existing vacancy.**


Disclaimer : Use of the term engineering in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices engineering or possesses the requisite license as prescribed by the applicable provincial or territorial engineering regulator. We are seeking individuals with expertise in IT engineering-related functions but licensure from an engineering regulator is not a prerequisite for this position. Engineering is a regulated profession in Canada which is restricted in terms of use of titles and designation.

#LI-JP

Use of the term engineering in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices engineering or possesses the requisite license as prescribed by the applicable provincial or territorial engineering regulator. We are seeking individuals with expertise in IT engineering-related functions but licensure from an engineering regulator is not a prerequisite for this position. Engineering is a regulated profession in Canada which is restricted in terms of use of titles and designation.

Skills:

• Delivery Management
• Detail-oriented
• Test Case / Script Development
• Test Design
• Waterfall Model
• Financial Services

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll 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. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll 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.

Youll shape your career by joining a company built to grow and last. Youll 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 value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer being able to perform your best during the recruitment process is important to us. If you require an accommodation please inform your recruiter.

To learn more about accessibility at CGI contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.

Come join our teamone of the largest IT and business consulting services firms in the world.