Our client, a premier player in the financial services sector, is seeking an autonomous Senior QA Engineer (Data/ETL Specialist) to join their Toronto-based Data & Analytics team. This team manages the critical financial data domain, overseeing ETL transformations that generate the organization's corporate financial statements.
Currently operating on an Oracle database and Informatica PowerCenter, the team is launching a high-priority platform migration over to Snowflake. As a senior specialist, you will act as a true self-starter, jumping directly into the project without baseline training to ensure data integrity, validate complex data transformations, and support this large-scale cloud migration.
Location: Downtown Toronto, ON (Hybrid – 2 days/week in office)
Position Type: 6-Month Contract (Strong potential for extension)
Hours: 35 hours per week (Strict corporate policy)
Advantages
High-Profile Migration: Gain valuable, hands-on experience driving a legacy on-prem to cloud migration utilizing cutting-edge Snowflake technologies.
Strong Extension Potential: Establish yourself within a major enterprise team on a long-term roadmap, presenting excellent prospects for contract renewals.
Balanced Hybrid Model: Enjoy flexibility with a 2-day hybrid schedule, allowing you to spend 1 day downtown and the 2nd day at a local regional office closer to home (e.g., Richmond Hill).
Streamlined Interview Process: Move quickly through a single-round, combined technical and situational virtual interview.
Responsibilities
Data Validation & Testing: Design, write, and execute complex SQL test scripts to validate end-to-end data integrity, ETL pipelines, and corporate financial transformations.
Cloud Migration Quality Assurance: Actively test and support the migration of data environments from legacy Oracle and Informatica architectures to the Snowflake cloud platform.
Test Lifecycle Management: Create, organize, and manage comprehensive data test cases and defect tracking using Jira and Xray.
Cross-Functional Collaboration: Partner daily with internal business groups, functional QA testers, and data developers to resolve defects and ensure smooth delivery.
Autonomous Execution: Proactively manage your own testing deliverables, driving quality assurance processes forward with minimal supervision.
Qualifications
Must-Have Qualifications:
- Senior-Level Autonomy: 7+ years of experience as a Senior QA Analyst/Engineer, with a proven track record of delivering immediately in fast-paced contract environments.
- Database Expertise: Exceptional, advanced proficiency with Oracle databases and writing complex, high-performance SQL queries.
- Snowflake & SnowSQL: Direct, hands-on experience with the Snowflake data platform, SnowSQL scripting, and familiarity or exposure to Cortex code.
- Informatica Utilities: Professional experience validating data transformations driven by Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS).
- Test Management Tools: Direct proficiency utilizing Jira and Xray for test case creation, management, and execution.
- Communication & Collaboration: Elite interpersonal and communication skills; must be comfortable translating technical defects to business teams and developers without friction.
Asset Qualifications (Nice-to-Haves):
- Prior experience handling large-scale data migrations from on-premises systems to cloud environments.
- Strong domain experience within the Insurance or Banking sectors.
Summary
This is an exceptional contract opportunity for an expert Data QA Analyst to take ownership of a major Snowflake migration for a top-tier financial organization. If you are a highly communicative, technically precise professional who excels in complex database environments, apply today!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to
[email protected] to ensure their ability to fully participate in the interview process.
