Client and Business Goals
The client is a niche specialty property and casualty insurance company operating globally. Recently, the giant with nearly 6,000 employees embarked on a series of IT projects in a pursuit of digital transformation of their entire business.
As the insurance sector is embracing data technologies to create new valuable offers meeting the demands of time for their customers, it’s only logical our client started from an ETL project. They approached AIS Novations because of our robust ETL expertise lying at the core of any data-heavy endeavor.
The project objective was to improve and optimize data processing workflows in the Fortune 500 company with offices all over the globe, generating dozens of millions of rows on a monthly basis.
Why do businesses need ETL software in the first place? Any company that uses an ERP system at some point understands that the data within their ERP is a total mess. There are two main reasons that cause it:
- Accidental errors during data input, transfer or occurring because of the bugs.
- Different data formats in the adjacent IT systems.
Even with the first cause eliminated (which is possible in theory, but rarely in practice), the second one will persist. Controlled differences in data formats and structure technically aren’t an error, but they do cause businesses problems.
Thus, our team had two key tasks for this project:
1. Align all the data to the required format (a single system of values and data break-down), at this ensuring data quality and reliability.
2. Provide an audit trail for the data transformation. Thus, data users can see how the target data came into being by tracing it back to the original state, if needed.