Test Data Engineer (TDM)

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.