ETL Case Study admin September 26, 2022

Increase Transformations in consumer lending using Digital technologies

About the Client

Our client is a full-service, technology-driven consumer finance company focused on vehicle finance and unsecured consumer lending products.


The client has several auto finance programs which are marketed to various banks. Through years of experience, they have gained valuable perspective on the auto origination processes and have approached MotivityLabs for automating data Validation and Integration across different business areas like Servicing, Finance, Risk etc.


The main challenge our client was to find the right technology partner who could translate their purpose of providing a complete auto origination process that could help in data handling and validations at different stages from start to finish, at a low cost and on time.
The client wanted the following challenges to be addressed as quickly as possible:
● Identifying the Test data and preparing the test bed
● Dealing with huge amount of data for validation
● Validation and automating of the data load with Control M
● Validation of reports, dashboards, cubes and Files
● Completion of testing on time in accordance with rally following agile with scrum methodology

What We Did:

The Motivity Labs team worked closely with the vision of our client to drive an automated financing model based on technology-driven business processes.
● We validated the data effectively by writing optimized, less time taking more effective queries
● Validated the Schedules in Control M thoroughly for the data load automation
● Validated the Reports, dashboards, cubes and files using open source tools like beyond compare
● Coordinating with development team and getting work done on time with testing efforts
● Worked on all challenges as a team by coordinating with onshore team.