Context :
As part of the IFRS17 program, we have set up a data integration platform which serves as a “hub” between the new applications but also as a “golden source” for the reporting and the calculation parameters of the CSM.
This platform aggregates the results produced by the various systems, ensures a minimum level of reconciliation between them but, more than a simple data warehouse, it offers quality control services on the loading, orchestration, historization and cartography.
It stores the IFRS17 parameters (Yield Curve, Risk Adjustment ratio, etc.) used by the Life and P&C Divisions, the quarterly results of their IFRS17 calculations, but also their operational data (contracts, technical accounting, settlements, etc.) which are used in daily.

This platform was built from a previous one, Reinsurance Analytics, which was used for the technical reporting of the Divisions (13 universes, nearly 150 views and more than 600 tables in the ODS).

To reinforce the DIP implementation team we are looking for a SQL DB2 Developer (4/5 years professional experienced) used to work in an Agile methodolgy (Scrum/SAFe). With strong experience in performance optimization to sustain volumetry DIP is dealing with.

Mission:
- Review the functional design
- Elaborate technical conception
- Implement solution
- Optimize interfaces performances
- Production support

Livrables :
- Technical design documentation.
- Implementation commited in Code repo

Compétences Tech
- Agile Scrum
- SQL
- Git

Philippe Marzin : philippe.marzin@lestudiotech.com