ETL Testing Automation Solution to Revolutionize Data Validation & Integration

Overview

The client is a leading legal outsourcing company, offering a full range of general legal and Intellectual Property (IP) support services throughout the entire lifecycle. The client wanted to validate that source data is imported into the application and defined business rules are applied on source data before it’s put in destination database. It also wanted to ensure that imported data is displayed on the application UI, and all the features were working fine

Challenges

Contata faced the following challenges with the project:

• Selection of data from different sources, including MS Excel, MS Access, database server, etc.
• Less test coverage
• Long test cycles
• Complex and different business rules for various clients
• Normalization issues in source database wrt application requirements
• Less time for testing
• Frequently, source data was getting changed before final import

Insight

Contata ETL Testing Automation Solution to validate that the data generated by the client is transformed and loaded into the target as expected.

Solution-ETL Testing Automation Solution

In the first phase, Contata validated data import through SQL scripts—and on UI through manual testing. We analyzed source database and business rules to identify critical issues and save project efforts. In the designing phase, Contata created SQL scripts to automate ETL testing including business rules. We performed count testing to validate data completeness and sample testing to validate data integration with the application.

Benefits

• Application released on time and within budget
• Reduced test cycle by 30% using ETL automation
• Reusable SQL scripts for future uses
• Higher test coverage in production
• Increased visibility of the testing infrastructure

Download