Test Data Analyst

Apply Now

Your central responsibility as the Data Analyst will be to develop, optimize and work with the Test Data lead in overseeing our company’s conceptual and logical Test data systems, and formalize the Test Data Management Framework and Capabilities


To succeed in this role, you should be able to examine existing and new data system requirements, prepare, recommend and assist to implement migration models. The ideal candidate will also have proven experience in Test Data Management, possess data-driven mindset, with excellent analytical and problem-solving abilities. Reporting into the Test Data Lead, you will be responsible for building enterprise test data management strategy focusing on enhanced data provisioning capabilities, data Optimization/integration and devising efficient TDM processes.

Responsibilities and Duties

  • Analyzes requirements during the requirements analysis phase of projects. Keeps track of the requirements from the project and manages Change of Scope (COS).
  • Schedules the project effort in conjunction with the PMO.
  • Checks for timely delivery of project milestones.
  • Arranges the hardware and software requirement for the TDM setup.
  • Escalates the issues about project requirements (Software, Hardware, Resources) to the Project Manager/Test Manager. Identifies training requirements and forwards it to the Project Manager.
  • Deliver Test Data Management capabilities to TCOE, Test delivery, provide TDM services listed in the catalogue, drive adoption of Global standards, and implementation of common toolsets.
  • Analyze existing Test Data Management practices/tools for reuse.
  • Coordinate with clients, data users and key stakeholders and develop and achieve various long term objectives for Test Data Governance.
  • Determine procedure to identify and collect all required data, validate process and recommend improvements.
  • Oversee and monitor all frameworks to manage data across organization.
  • Design and provide support to all data management methodologies according to required standards.
  • Coordinate with Test Data Leads, project supervisors and business heads and manages all projects regarding Test Data.
  • Manage various data associated problems such as system configuration and integration on multiple platforms.
  • Collaborate with new and existing external vendors and provide support to all objectives and assist to create various Test data processes.
  • Develop & implement long term Enterprise Test Data Management Strategy.
  • Analysis, Estimation, Design, Development, Testing, Implementation of data Archiving /Test Data Management/ Data Privacy solutions.
  • Provide a consistent and repeatable process to support multiple Applications including identifying data elements for masking in Applications, Data Reset and Update Process.
  • Provide right sized, production like, reusable and secured test data per test data requirements utilizing discovery, generation, transformation, enrichment, cleansing, extraction, sub setting, masking, validation, refresh, reset, purging and other suitable capabilities using industry standard Test Data Management (TDM) tools and other complementary mechanisms like automation tools, SQL scripts, jobs and programming languages.
  • Work with IT Security and Compliance to ensure Policies were consistently followed.
  • Coordinated activities across multiple operations teams including Test Managers, Testers, Env and DBA teams.
  • Provide required Test data for Performance Test, User Acceptance Test, QA Test, Application Development, and other Non-Production Environments.
  • Identify, design, and implement Test Data process improvements that involve automating manual processes of existing Test Data Generation, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Work with our internal TDM tool and help to automate the TDM tool process and data generation models.
  • Work with API connectivity model to connect the TDM tool with our different internal applications.
  • Coordinate communication with testing services end user and expectations management.
  • Identify and implement optimization for making the test data creation process efficient and faster.

Qualifications and Skills

  • Bachelor’s degree in Computer Science, Computer Engineering or relevant field.
  • A minimum of 5 years’ experience in a similar role.
  • Strong knowledge of database structure systems and data mining.
  • Excellent organizational and analytical abilities.
  • Outstanding problem solver.
  • Good written and verbal communication skills.
  • Test data management concepts and techniques as well as implementation experience.
  • Good understanding of Data archival, subsetting, masking, synthetic data generation, shuffling, etc.
  • Technical expertise regarding data models, data flow diagrams and database design development.
  • Automation experience using QTP, Excel Macros or similar tools.
  • Good understanding and experience of various database technologies (DB2, Teradata, Oracle 10g/11g, SQL server, Big data/Hadoop, MariaDB).
  • Test Data subject matter expert supporting the Quality Architect.
  • Able to analyze Current state of TDM with the relevant stakeholders.
  • Experience with the following Test Data responsibilities: Data Strategy, Test Data Planning, Data Preparation/Provisioning, Data Refreshes, SQL/NoSQL, Files, Mainframe, Cloud, Synthetic Data, Masking, ETL, Data Warehousing, Analytics and Tooling.

Essential Technical Skills

  • Data Masking / Obfuscation and Synthetic Data Creation
  • Data and Refresh Optimization
  • Data Comparison Testing
  • In-depth knowledge of Test Data Tools preferred – (i.e. Informatica, CA Test Data Manager, Oracle Data Masking and Subsetting, IBM InfoSphere Optim Data Privacy, HPE SecureData, Delphix, DataFactory, DataGenerator)