Job location: TORONTO
Required skills: Test Data Management (TDM)
Experience range: 10 & Above
Job description:
Key Responsibilities
o Test Data Strategy Planning
Develop and own the enterprise TDM strategy for multisystem multi release testing programs.
Analyze application landscapes (admin systems PAS underwriting claims CRM billing) to design optimal data provisioning approaches.
Partner with QA Test leads to understand data needs across SIT UAT performance testing and automation pipelines.
o Data Provisioning Optimization
Create extract mask subset refresh and maintain reusable data sets for testing environments.
Implement automated data provisioning workflows using TDM tools (e.g. Informatica TDM Delphix CA TDM IBM Optim).
Develop synthetic data models for highrisk missing or complex data scenarios.
o Data Governance Compliance
Ensure all test data practices comply with Canadian privacy and regulatory rules (PIPEDA OSFI guidelines).
Implement GDPRPIPEDA aligned data masking standards to protect sensitive personal and financial information.
Coordinate with InfoSec Data Governance and Privacy teams to maintain compliance posture.
o Environment Integration Support
Collaborate with environment management teams to align test data availability with deployment cycles.
Troubleshoot data issues and improve data related stability across test environments.
Support continuous integration continuous testing (CICT) pipelines by enabling on demand data provisioning.
o Reporting Continuous Improvement
Track TDM KPIs provisioning lead time masking coverage environment stability and defect leakage due to data gaps.
Build dashboards and documentation for TDM policies capacity plans and best practices.
Identify automation and optimization opportunities to accelerate testing velocity.
Required Qualifications
Technical Skills
o 5-10 years of experience in Test Data Management QA Data Engineering or related roles.
o Handson expertise with at least one enterprise TDM platform Informatica TDM CA Broadcom TDM Delphix IBM InfoSphere Optim.
o Strong SQL skills (Oracle DB2 SQL Server PostgreSQL).
o Experience with data masking subsetting cloning and synthetic data generation techniques.
o Understanding of cloud data ecosystems (Azure AWS or GCP).
o Familiarity with mainframe distributed and APIbased systems integration.
Domain Skills
o Strong understanding of Life Insurance products policy administration underwriting claims billing and regulatory frameworks.
o Experience supporting testing in complex BFSI environments policy conversions modernization digital transformation or integration programs.
Soft Skills
o Excellent communication and documentation abilities.
o Strong problem solving analytical and stakeholder management skills.
o Ability to work independently in fast paced cross functional teams.
Essential skills:
Seeking an experienced Test Data Management Consultant to support largescale transformation programs across the Life Insurance Group Benefits and Wealth business lines.
The consultant will design implement and optimize TDM strategies to ensure high quality compliant and production like data is available across all testing cycles including functional integration regression and UAT environments.
This role requires strong expertise in TDM processes data masking synthetic data generation environment coordination and automation with a deep understanding of Life Insurance domain systems and regulatory expectations in Canada.