Secured and enriched test data provisioning
for a large financial organization
Improved delivery speed & reduced storage costs

About the Customer

One of the Largest Canadian multinational investment bank and financial services company with more than 12 million customers providing personal and commercial banking, wealth management and investment services.

Customer landscapes include around 50 applications with heterogeneous data sources including SQL Server, DB2, Oracle, Mainframe files


Customer has highly integrated, sensitive and complex systems that are very crucial to their business operations and needs data provisioning to lower environments protecting sensitive data along with timely availability.

  • Repetitive Time consuming Test Data Setup Process
  • Insufficient Data Refreshes and data overridden
  • Inconsistency of Data across applications / modules
  • Long waiting times because of Manual Test Data Generation
  • Meeting data compliance and regulatory requirements
  • Lack of Referential Integrity of Data
  • Inappropriate Size of Data in different environments

Strategy and Insight

Tech Mahindra defined a phase wise approach for the TDM transformation program


After a detailed assessment and evaluation of the customer requirements and technology landscapes, TechM proposed the solution approach for TDM implementation

Implementation highlights

  • Identified the key tables and the associated child and reference tables to maintain application context
  • Installed and configured CA Data maker components, Fast Data Masker, TDM portal, repository
  • Creation of connection profiles for source and target systems, projects and register objects
  • Discovery of sensitive data using CA TDM portal discovery
  • Creation of data groups, data sets and data pools for subset extract definitions by defining automated queries and data models with driving, PK/FK, reference and standalone tables
  • Transformation maps with masking functions defined for the sensitive attributes
  • Creation of self-service catalog forms to search and generate test data
  • Orchestration workflows set-up in CA TDM portal and adding to Generators for publishing to target environments
  • Establishment of TDM service catalogs with standardized requests for TDM services
  • Building of test data warehouse to maintain gold copy versions
  • Facilitate faster refresh of test data on demand and re-use data across environments
  • Accelerate data refresh with right sized data – subset, mask, test matching, synthetic data creation
  • Centralized TDM work force with defined operational model to manage teams test data needs
  • Define and adopt processes for test data request, data distribution, data storage & maintenance
  • Robust governance model with defined metrics and driven by measurements
  • Training and end user support


  • Consulting support and thought leadership in Test Data Management setup and Enablement.
  • Perform assessment, Tool fitment analysis & recommendation; propose Test Data Management Strategy and implementation approach
  • CA TDM tool components installation, configuration and validation
  • Pilot Implementation for selected use cases/ data requirements
  • Phase wise implementation of TDM solution for key applications in providing TDM services
  • Built automated provisioning platform with data discovery, data masking, data subsetting and synthetic data generation services.
  • Established Test Data As a Service which fulfils On-Demand data requirement for any team.
  • Ensured aspects of Data Quality, Security, Reusability, Governance etc. as part of Data Provisioning


  • Reduced overall cycle times with supply of test data rapidly by automation and self-service, defects identified early in the testing phase with appropriate test data set-up and resulted in shorter testing cycles with less rework
  • Compliance with data privacy regulations by discovering sensitive fields and applying masking on PII, PCI data there by reducing risks to security breaches
  • Improved test coverage by 40% with efficient subsets creation covering various data conditions
  • Minimized required labor by 42% with automated process for data refresh and self-service enablement
  • 40% reduction in test environment storage requirements achieved by slicing and creating smaller datasets matching test requirements

TechM Advantage

  • Extensive expertise in implementing high quality Data archiving & Test Data Management solutions meeting customer business needs and regulatory timelines.
  • Experience in delivering value based solutions to customers in Banking and financial services domain by adopting best practices and defining TDM framework with ability to plug new data sources easily and scalable enterprise wide.

Business Benefits

  • Improved delivery speed by 35% resulting in faster time to market
  • Improved quality of the systems by 40%
  • Reduced costs by 50% with fewer defects, optimal efforts and less storage needs
  • Reduced risk to compliance by 80% with Zero security breaches

Dark Mode

One of the world's first website to run on Dark Mode by default.

Brightness Control

Adjust the brightness as suited.

Hibernate Mode

Save energy when you're not looking at your screen.

Know More

The Eco Engine

Reduce your carbon footprint using any of these modes.
  • Dark Mode
    One of the world's first website to run on Dark Mode by default.
  • Brightness Control
    Adjust the brightness as suited.
  • Hibernate Mode
    Save energy when you're not looking at your screen.