Securing Test Data at Scale
ABN AMRO Bank N.V. must balance strict regulatory compliance with high-speed software delivery. By implementing DATPROF’s Test Data Management platform, the bank anonymizes enterprise-scale data. This includes data masking on relational databases as well as complex Parquet files containing nested JSON with PII data.
CHALLENGES
Strict Regulatory Mandates
GDPR, DORA, and Central Bank regulatory requirements strictly prohibit the use of real customer data in non-production environments to prevent data leaks.
Complex Data Formats & Cross-Platform Consistency
Masking PII across a wide range of data formats and structures, while ensuring 100% data consistency across heterogeneous database and file environments.
Infrastructure & Adoption
Overcoming infrastructure-related file access hurdles while motivating engineering teams across the bank to adopt centralized TDM processes.
SOLUTION
High-Performance File Masking
DATPROF anonymizes both relational databases and files, ensuring consistent and referentially intact PII masking across heterogeneous database platforms and file types.
RESULTS
Enterprise-Wide Data Consistency
Reliable extraction and masking of nested JSON PII data, maintaining deterministic consistency between flat files (Parquet) and core enterprise databases (DB2, MS SQL), ensuring end-to-end data compliance.
Proven Performance for large files
Successfully verified load and functionality on massive 5.8 GB Parquet files (100 columns / 30 PII fields) with masked file loading in 19 minutes.
KEY INSIGHT
“DATPROF has already been in the market and working with customers for a long time, they know the ins and outs of how the market works. Everything that we could possibly think of is already covered by the platform.”
– Romil Kapadia, Product Owner at ABN AMRO Bank