Test data management is a common use case. When conducting testing in lower environments, we want to avoid exposing sensitive information. To achieve this, we use Data Masking to modify the data. 

For example, we change personally identifiable information, phone numbers, and emails so that they cannot be viewed. The modified data retains the structure and format but doesn't reveal the actual information.

Our clients need to perform data masking to comply with GDPR rules or the company's internal data security policies. Data masking restricts who can look at the private customer data. Informatica provides a comprehensive solution for on-the-fly or real-time data masking. 

One use case is masking the data for a test environment, so developers and testers can't see production data. This is something you have to do regularly with large amounts of data.

The second use case is in a production environment. Sometimes you need to mask the data on the fly when the data consumers are retrieving reports from the data platform. You are masking the data for certain groups who don't have permission to see that data. 

We use Informatica to extract data from production. It's mainly the configuration of the systems. We extract data from one site in the same system and mass customer data to the test system. It's a list of customers that is a subset of the data. 

In our CRM, we have data on our customers, and the data in that system is a copy of the production environment. We have all the configurations manually modified to work as a test, but we can extract only new clients, which is a problem. We need to have a CRM with only the configuration but not the customers. 

My plan is to make Informatica work with the CRM. If it works, I am sure that I can get the budget to make it work with other systems, but the first system that I need to work with is CRM. The other ones are less important and don't have the same impact of making it work with the CRM. We're at about 80 percent completion with this project. 

We have a lot of applications with different functionality. We use Informatica mainly for sensitivity tests. 

We provide services mostly to banks. 

I am currently working at a bank where they are using Data Masking and Data Transformation at the same time. They are an old core banking system, which is COBOL, and it's unstructured data. We are using Data Transformation to transform and structure the data into a relational format.

We use the test data management to create test data from the relational data. To create the test data, we mask using different techniques for the discovery. After that, we re-transform the relational data into unstructured data to be fed into the core banking system.