BI DWH optimization solution for an insurance company
A multi-line business insurance company aimed to implement a data warehouse solution for managing its claims operations. They used MS SQL server, and the source systems were a popular multi-line claims system, ERP systems, home-grown applications, AS400, and mainframe systems.
They also had multiple feeds coming in from business sources and digitized forms. They had around 150 TB of data, and the ETL processes that extracted data from these sources took over 30-36 hours, as opposed to an overnight processing requirement.