Consultant Developpeur SQL DB2 HF

Prsentation du cabinet :

a.m.i consulting est une entreprise familiale innovante (Le cabinet a obtenu en2019 la bourse InnovUP de BPI France) qui exploite pour vous la data afin de vous fournir des consultants experts dans ces domaines. Soucieux du bientre de nos collaborateurs et conscient des enjeux environnementaux nous nous engageons rduire notre empreinte carbone grce un processus de qualification de slection et dintgration 100%% digitale.

Prsentation de loffre :

• Secteur: Assurance / Rassurance
• Nombre danne dexperience: 3 5ans
• Contrat: CDI Mission ou freelance
• Statut : Cadre
  • Package de rmunration
    • Entre 38k et 40ken fonction du niveau dexpertise du consultant
    • Prime de panier repas de 5k brut par an
• Dure de la mission:longue
• Lieude la mission: 92
• Mission:Full Time
• Tltravail : 2jours par semaine
• Bilingue Anglais : C1

Prsentation du besoin client

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.

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