Test Data Engineer (TDM)

Yochana IT Solutions Inc.

Canada

Remote

CAD 80,000 - 100,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A technology company is seeking a skilled professional in Test Data Management (TDM) to define and implement TDM strategies. Responsibilities include creating and managing test data, ensuring data security, and integrating with automation frameworks. The ideal candidate has significant experience in SQL, TDM tools, and Azure Cloud technologies, alongside strong communication skills. This is a full-time remote position in Canada, offering the opportunity to contribute to critical testing operations and mentor team members.

Qualifications

  • 6+ years of software product development, testing, and delivery experience.
  • 5+ years of TDM/SQL experience.
  • 3+ years of experience with Informatica Power Center.

Responsibilities

  • Define and implement TDM strategy and processes.
  • Establish test data supply chain with masking and subsetting.
  • Support and maintain TDM environment, platform, and services.

Skills

Test Data Management (TDM) Strategy
SQL Proficiency
Informatica IDMC
Azure Cloud Tools
Communication Skills

Education

6+ Years of Software Product Development
5+ Years of TDM/SQL Experience
3+ Years of Informatica Experience
Experience with Python

Tools

Informatica Power Center
HP ALM/Quality Center
Jira

Job description

Type of hiring – Fulltime
Location – Remote Canada
Job Description:

Test Data Management (TDM) plays a key role in sourcing the right data with every changing need to ensure software testing is done effectively. Test data administration is the process of creating non‑production data that reliably mimic an organisation’s actual data so that systems can be rigorously tested. It is a measure of the quality and quantity of data that is available in non‑prod environments. This role will be accountable for understanding test data requirements, performing data discovery, protecting sensitive data using masking techniques, creating a test data warehouse, and enabling test data availability to users.

Essential Job Functions:
  • Define, implement, and adopt TDM strategy, technical solution, processes & methodology, delivery model, standards & governance.
  • Establish test data supply chain (from prod to non‑prod) applying masking, sub‑setting to build a gold‑copy test data set.
  • Good understanding of the application architecture/domains and data flows across systems.
  • Implement test data management function with NoSQL & relational data sources.
  • Proficient in TDM tools (Informatica IDMC, CA, Delphix or others) for masking, sub‑setting, synthetic data generation & gold copy.
  • Support, operate and maintain TDM’s environment, platform, and services.
  • Integrate TDM solution with Test Automation framework, automate test data refresh and creation process, integrate with CI / CD pipelines.
  • Service test data requests, perform data identification / analysis across data sources for required scenarios.
  • Analyze business requirements, work closely with project team members, technical leads, and business partners to arrive at an optimal solution design.
  • Conduct feasibility analysis, create high‑level design document, and review it with key identified stakeholders.
  • Perform proof of concept (POCs) on agreed approach and provide presentations to key stakeholders.
  • Excellent in writing complex SQL queries.
  • Capable of handling multiple programs simultaneously and work under offshore and onsite model.
  • Provide support to identify test data required to test specific business scenarios.
  • Coordinate with application DBAs to copy data from one environment to another while protecting customer sensitive information. Document data quality issue findings and recommendations.
  • Demonstrated ability to provide high volumes of test data with referential integrity required to support Test execution.
  • Perform data analysis when needed to analyze issues in Pre‑production and/or Production environments in Cloud and/or on‑premises infrastructure.
  • Prepare test data reports/metrics for stakeholders.
  • Experience in defect management process, and defect triage calls.
  • Mentor and groom team members on product/application features/functionality and domain.
  • Knowledge of any of database systems like SQL Server, Oracle or db2 etc.
  • Working knowledge of test management tools like HP ALM/Quality Center/Jira/QMetry.
  • Excellent verbal and written communication skills.
Minimum Positions Qualifications/Education Requirements:
  • 6+ Years of software product development, testing and delivery experience.
  • 5+ Years of TDM/SQL experience.
  • 3+ Years of Informatica Power Center, IDQ, IICS/IDMC experience.
  • 2+ Years of experience in some of the Azure Cloud tools: ADF, PySpark, Databricks notebooks.
  • 1+ Year of experience with Python and libraries like Pandas, Numpy & Matplotlib.
  • Familiar with Latest Cloud Technologies.
Mandate Key Skills:
  • Expertise in TDM Strategy and Implementation: including defining and driving TDM strategy, governance, and delivery model as a core function.
  • Strong proficiency in SQL for data identification, extraction, transformation, and analysis: SQL, NoSQL, Relational Database.
  • Experience with TDM Tools & Automation: Hands‑on experience with TDM tools like Informatica IDMC, CA, Delphix.
  • Experience with Azure Cloud tools: Azure Data Factory, PySpark, Databricks Notebooks.
  • Experience with test management tools like: HP ALM, Jira, QMetry.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. TDM Engineer
Sr. TDM Engineer

FlexStaf IT • Canada

Remote
CAD 120,000 - 160,000
Lead Test Data Manager – Data Masking & Provisioning
Lead Test Data Manager – Data Masking & Provisioning

Astra-North Infoteck Inc. • Toronto

Remote
CAD 90,000 - 130,000
Remote Test Data Engineer (TDM) & Data Automation
Remote Test Data Engineer (TDM) & Data Automation

Yochana IT Solutions Inc. • Canada

Remote
CAD 80,000 - 100,000
Senior TDM Engineer – Data Masking & Provisioning
Senior TDM Engineer – Data Masking & Provisioning

Astra-North Infoteck Inc. • Toronto

Remote
CAD 120,000 - 180,000
TDM Architect
TDM Architect

Pacer Group • Toronto

On-site
CAD 110,000 - 160,000
Test Data Management Engineer | TDM Platform Lead
Test Data Management Engineer | TDM Platform Lead

The Canada Life Assurance Company • Toronto

On-site
CAD 94,000 - 157,000
Career development
Health & Wellness benefits
Pension plan
+2
TDM Architect
TDM Architect

Viva Tech Solutions • Canada

On-site
CAD 90,000 - 140,000
Sr TDM Engineer
Sr TDM Engineer

Indotronix UK • Toronto

On-site
CAD 90,000 - 120,000
TDM Architect or TDM Lead
TDM Architect or TDM Lead

Indotronix UK • Torbay

Remote
CAD 90,000 - 140,000
Data Engineer
Data Engineer

Global Technical Talent, Inc. • Toronto

Hybrid
CAD 103,000 - 124,000