Agile data warehouse development - Case If P&C

Large scale implementation of data warehouse needs a team of agile developers. Read below how Ready Solution’s skilled consultants can help you to go live faster.

Background

If is the leading property and casualty insurer in the Nordic region, with more than 3.7 million customers in the Nordic and Baltic countries.

Enterprise data warehouse

If data warehouse is developed on Teradata platform using an industry specific data model. If has large amounts of data in multiple operational systems so integrating it all to

a common data model provides huge benefits for the business amongst other:

• unified metrics
• source data for AI-development
• business analytics

Data warehouse captures the data at most detailed level possible and also keeps track of the version history of records via its bitemporal data model. Building a data warehouse on this scale is highly complex and Ready Solutions consultants played an important role in defining the specifications with the source system experts as well as implementing the data pipelines. Data is extracted from source systems mainly using IBM Infosphere DataStage.

Agile development

When building the data warehouse we used Git and Azure DevOps to facilitate collaboration and version control. Work is done in multiple teams with members located in the Nordic countries. Scrum methodology is used to provide agile and fast development cycle.