Jobs.ca
Jobs.ca
Language
Atlantis IT Group logo

Lead Test Data Management- Mainframe, SQL

Toronto, ON
Senior Level

About the role

ROLE : Lead Test Data Management- Mainframe, SQL

Location : Toronto, London, Winnipeg (Hybrid - 3 days on site)

As a Test Lead Test Data Management (TDM), you will play a key role in enabling high-quality, privacy-compliant testing across Canada Life's enterprise systems. You will lead the design and execution of test data strategies, leveraging CA Test Data Manager (TDM) and advanced data masking techniques, including mainframe masking, to ensure secure and efficient test environments. This role is critical to accelerating delivery while maintaining compliance with data privacy regulations.

What you'll do

Lead the development and implementation of test data management strategies for complex, multi-platform programs.

Configure and optimize CA Test Data Manager for data subsetting, masking, and synthetic data generation.

Design and implement data masking solutions for relational databases and mainframe datasets (DB2, IMS, VSAM).

Enable self-service test data provisioning for delivery teams through CA TDM portals and automation.

Perform data profiling and quality checks to ensure completeness, integrity, and compliance.

Collaborate with cross-functional teams (QA, DevOps, InfoSec, Privacy) to align on data governance and security standards.

Integrate TDM processes into CI/CD pipelines to support automated testing and continuous delivery.

Provide leadership, mentorship, and guidance to QA teams on TDM best practices.

Monitor and report on TDM KPIs, including provisioning lead time, masking compliance, and data reuse.

What you'll bring

8+ years in software testing or quality engineering, with 3+ years in Test Data Management leadership.

Hands-on experience with CA Test Data Manager (Broadcom) for masking, subsetting, and synthetic data creation.

Strong knowledge of data masking techniques for structured and unstructured data, including mainframe systems.

Proficiency in SQL, data modeling, and understanding of COBOL copybooks.

Experience with JCL and mainframe utilities for data operations.

Familiarity with privacy regulations (e.g., PIPEDA) and secure data handling practices.

Exposure to DevOps tools (Azure DevOps, Jenkins) and integrating TDM into pipelines.

Excellent communication and stakeholder management skills; proven ability to lead and influence teams.

Nice-to-have:
Experience with service virtualization or data virtualization tools.

Insurance or financial services domain knowledge.

Certifications: ISTQB Advanced Test Manager, CA TDM, or Data Privacy certifications.

Education:
Bachelor's degree in Computer Science, Information Systems, or equivalent experience.

About Atlantis IT Group

IT Services and IT Consulting
51-200

"Atlantis IT Group" is an IT venture that offers end-to-end services and products. The focus of "the Company" is to cater one-stop solutions to small and medium-sized businesses.

"Atlantis" had its first branch in Toronto, Canada, and was established in 1990. The Company has emerged from a small farm to a medium company providing all sorts of solutions, headquartered in Toronto, Canada The Company has had its branches and offices in different countries such as the USA, Canada, and India for the last 32 years.

Atlantis is enlarging its global footprint by offering complementary product and service lines by partnering and strategically working with businesses. The primary specialized area of the Company includes ERP solutions, with cloud-based and on-premise solutions available to meet the requirements of all Industries.

OUR PRODUCTS:

"WORKSWARE ERP" The emergence of WORKSWARE ERP is noticed from a ground level to an upgraded form because of the integrated ERP system, dedicated towards forward-thinking discrete manufacturing enterprises.

"BM-Cloud" BM-Cloud is One of the key offerings of Atlantis consulting as a Cloud-based business management ERP software since 2013. The significant feature of BM-Cloud includes easy usage with the enhancement of simplicity and usability as a complete integrated ERP system. The fundamental modules covered by BM-Cloud are accounting, inventory management, purchasing, sales, and HR/payroll systems. In other words, it is designed primarily to support businesses in the trading and retail sectors and includes all the essential components required for a firm to assist in decision-making.

"BM-POS"

We provide a cloud-based retail solution with all the tools required to manage a retail business, including a sales screen, inventory management, real-time dashboard, employee administration, and other functions that keep retailers in charge of their operations.