Senior Test Automation Engineer

PureFacts Financial Solutions Toronto, Ontario, Canada

About this position

About PureFacts Financial Solutions

PureFacts is the leader in the Revenue Performance Management category for wealth and asset management firms. The PureRevenue™ Platform helps organizations maximize revenue potential by connecting pricing, billing, compensation, advisor behavior, and AI-powered intelligence within a single Revenue Book of Record. By transforming fragmented revenue processes into a coordinated growth system, firms gain greater visibility, stronger pricing discipline, improved revenue capture, and more effective advisor alignment. The result is faster organic growth, improved profitability, and increased enterprise value. For more than 25 years, PureFacts has helped leading financial institutions turn revenue from an operational process into a strategic advantage.

At PureFacts, we are building an AI-native platform and company. We embed AI, intelligent automation, and agentic workflows across our products and operations to detect anomalies, surface insights, streamline repetitive work, and support faster, better decision-making. In a highly regulated industry, we believe AI must be practical, governed, and auditable—amplifying human expertise while helping our teams and clients focus on higher-value, strategic work.

About the role

We are seeking a highly skilled and self‑motivated Senior Test Automation Engineer to join our Quality Engineering team. The ideal candidate will have extensive experience in test automation, database validation, AI‑assisted testing, and up-to-date quality engineering practices. This role requires expertise in building scalable automation frameworks, validating complex data migrations,



and leveraging AI‑enabled tools to improve productivity, accelerate testing cycles, enhance test coverage, and continuously improve software quality.

The successful candidate will play a key role in driving AI‑powered quality engineering practices, championing innovation, and ensuring the effective use of AI technologies while maintaining high standards of quality, security, compliance, and reliability.

What you'll do

- Design, develop, and maintain scalable automation frameworks using Java, Python, and Playwright.
- Develop and execute automated functional, regression, integration, API, and end‑to‑end test suites.
- Perform comprehensive database testing, including data validation, data integrity, data consistency, and backend verification.
- Write and optimize complex SQL queries involving joins, subqueries, Common Table Expressions (CTEs), window functions, aggregates, and stored procedures to validate business rules and application data.
- Validate database transactions, triggers, stored procedures, views, functions, indexes, and constraints.
- Perform end‑to‑end validation of data across multiple databases and systems to ensure consistency and integrity.
- Validate ETL processes and data migration activities, ensuring accurate transformation, reconciliation, and completeness of migrated data.




- Perform source‑to‑target data validation for large‑scale migration and integration projects.
- Create reusable SQL validation scripts to support automation and regression testing.
- Analyze database performance and identify data‑related issues impacting application functionality.
- Validate data generated through APIs, batch jobs, scheduled processes, and background services.
- Perform backend testing by validating application data against business requirements.
- Execute performance, load, stress, security, and accessibility testing.
- Work with Snowflake to validate data, execute queries, verify data pipelines, and support reporting validation.
- Develop reusable automation utilities and testing libraries.
- Integrate automated tests into CI/CD pipelines to support continuous integration and continuous delivery.
- Utilize AI‑assisted tools such as Microsoft Copilot, ChatGPT, Claude, Cursor, GitHub Copilot, and similar technologies to accelerate test design, automation development, defect analysis, SQL generation, troubleshooting, documentation, and productivity improvements.
- Leverage Generative AI solutions to create, optimize, and maintain test scenarios, test cases, test data, validation scripts, and quality engineering documentation.
- Evaluate, recommend, and adopt emerging AI‑enabled testing capabilities that improve efficiency, coverage, risk detection, and release confidence.
- Validate and review AI‑generated outputs to ensure accuracy, reliability, compliance, and alignment with business requirements.
- Contribute to AI testing standards, best practices, governance, and responsible use of AI within th

📌 Senior Test Automation Engineer (Toronto)
🏢 PureFacts Financial Solutions
📍 Toronto