Role Overview:
Teqfocus is seeking a Test Engineer with strong functional testing, SQL, data validation, and test automation experience to support master data management (MDM) and data integration initiatives. The role involves validating complex data flows across systems, ensuring accuracy and consistency of master records, and collaborating with cross-functional teams in an Agile delivery environment.
About Teqfocus:
Teqfocus is a Data and AI company that helps enterprises build and scale the Agentic Enterprise - connecting the data foundation, the intelligence layer, and the applications teams run their businesses on into a single, coherent architecture.
As a Salesforce Summit Partner, we work in Healthcare, Life Sciences, Financial Services, Insurance, and Hi-Tech - industries where getting AI right matters and the tolerance for failure is low. Our delivery model is senior-heavy by design. The same team that scopes an engagement ships it to production. There are no junior shadow teams, no sub-contractors brought in when the problem gets hard, and no hand-off to a separate managed services vendor when the project closes.
We run an internal innovation practice that builds the reusable patterns, pre-tested architectures, and industry-specific frameworks that give every Teqfocus client a head start - and give every Teqfocus practitioner work that compounds over time.
We are a diverse, immigrant-entrepreneurial company. We were built on the conviction that the best outcomes come from people who take genuine ownership of what they build - and are trusted to do so.
www.teqfocus.com
Key Responsibilities:
- Design and execute test scenarios, test cases, and test data for functional, integration, regression, and end-to-end testing.
- Write and optimize SQL queries to validate source-to-target records, identify missing or duplicate values, and reconcile data discrepancies.
- Validate ETL pipelines, data mappings, transformations, migrations, integrations, interfaces, and data-quality rules.
- Test MDM processes including master record creation, hierarchies, matching and merging, duplicate detection, survivorship rules, and golden-record generation.
- Build, enhance, and maintain automated test cases for data validation, APIs, and relevant application workflows; integrate tests with delivery processes where applicable.
- Log and track defects with reproducible evidence, investigate root causes with developers and data teams, and verify fixes through retesting.
- Collaborate with business analysts, developers, data engineers, and product owners to understand requirements, clarify acceptance criteria, and report test outcomes in Agile/Scrum teams.
Required Skills & Qualifications:
- Hands-on experience in both functional testing and test automation, including authoring and maintaining reliable automated tests.
- Strong SQL skills for joins, aggregations, reconciliation, duplicate detection, and source-to-target data validation.
- Practical experience with ETL, data integration, data migration, and data-quality testing across enterprise systems.
- Working knowledge of MDM concepts: master data, golden records, hierarchies, match-and-merge logic, and survivorship rules.
- Ability to test APIs and data interfaces, investigate issues systematically, and document defects and evidence clearly.
- Experience working in Agile/Scrum delivery teams and using defect tracking tools such as Jira.
- Excellent analytical, communication, and stakeholder collaboration skills; ability to work from the Toronto-area office twice weekly.
Preferred Qualifications:
- Exposure to Informatica MDM, Reltio, TIBCO EBX, Stibo, or a comparable MDM platform.
- Hands-on REST API testing using Postman or similar tools.
- Insurance or financial-services domain experience, especially with customer, broker, policy, or product data.
- Performance or volume testing for large-scale data loads, batch jobs, or integrations.
