Job Description: Test Data Management (TDM) Specialist

Location: Toronto

Hybrid

1yr contract

Position Summary:
We are seeking a highly skilled Test Data Management (TDM) Specialist to lead the creation, optimization, and management of test data for complex testing environments. The ideal candidate will have deep expertise in TDM tools, automation, and database technologies, combined with strong engineering and scripting skills. This role is pivotal in enhancing testing efficiency, ensuring data compliance, and supporting enterprise-level testing strategies.

Key Responsibilities:

• Test Data Creation and Optimization:
  • Utilize TDM tools to create and mine test data, automating data generation to support rapid testing scenarios.
  • Identify inefficiencies in test data and optimize processes through scripting or other innovative methods.
• Automation and Engineering:
  • Develop and implement automation solutions using tools like Selenium and UIPath.
  • Leverage strong engineering skills in database technologies (RDBMS concepts), programming (Java, Python, Shell scripting), and performance testing tools like Load Runner.
• Database Management:
  • Implement and manage SQL Server, Oracle DB, MySQL, Netezza, and NoSQL databases such as MongoDB.
  • Apply expertise in data ingestion, loading, processing, transformation, batch, and stream processing.
• Data Compliance and Masking:
  • Ensure compliance with IT security guidelines and data regulations.
  • Apply data masking techniques to protect sensitive data while provisioning for testing purposes.
• Strategic TDM Development:
  • Develop and execute long-term strategies for enterprise test data management.
  • Design and maintain consistent, repeatable processes for provisioning, refreshing, and updating test data across applications.
• Collaboration and Compliance:
  • Work closely with QA, user acceptance testing, and performance testing teams to provision required data.
  • Ensure alignment with organizational policies and regulatory standards.
• Task Estimation and Process Implementation:
  • Estimate tasks related to TDM, analyze testing requirements, and design and develop supporting tools.
  • Test and implement TDM processes and solutions to support robust software testing.

Qualifications:

• Proficiency in TDM tools like CA TDM, SQL Developer, and DBVisualizer.
• Strong programming skills in Java, Python, and Shell scripting.
• Expertise in database technologies, including SQL Server, Oracle DB, MySQL, Netezza, and MongoDB.
• Hands-on experience with automation tools such as Selenium and UIPath.
• Familiarity with performance testing tools like Load Runner.
• Deep understanding of data masking techniques and IT security guidelines.
• Experience in provisioning data for various testing phases, including QA, UAT, and performance testing.
• Strong problem-solving skills and the ability to create innovative solutions to optimize testing processes.

Preferred Skills:

• Knowledge of mainframes and CCaps.
• Experience with data compliance regulations and guidelines.
• Strong communication and collaboration skills to work effectively with cross-functional teams.