Clément Mattei

The State of Geneva is the public administration responsible for the canton, providing essential services to over 500,000 citizens. With a critical information system and thousands of employees, data management and analysis are at the heart of the proper functioning of public services (security, justice, education...).

I joined the Business Intelligence (BI) team of the State of Geneva, consisting of about fifteen people, as an Informatica Tech Lead to ensure the reliability, evolution, and performance of strategic data flows for various business departments.

I performed the following tasks:

- Development and optimization of complex mappings in Informatica Powercenter (API integration, XML parsing...).

- Diagnosis, redesign, and bug fixing on decision-making reports (Cognos).

- Monitoring of functional evolutions and management of production incidents in a critical environment.

- Close collaboration with various internal clients (Police, Justice, Education) to translate their needs into data solutions.

Since the beginning of my assignment, I have been contributing to the reliability of the BI environment by streamlining incident management and ensuring high data availability for public services.

Technical environment: Informatica PowerCenter 10.5.8, Oracle 19, PostGreSQL 17.6, DBeaver 24.1.3, Cognos 11.2.4, Postman, DataChain, Control M, OpenMetadata, Splunk, Jira, Confluence, Kanban

Richemont is one of the world's leading luxury groups, owning prestigious Maisons such as Cartier, Van Cleef & Arpels, and IWC. With a turnover exceeding €20 billion, the group is undergoing a major digital transformation supported by a global and interconnected data ecosystem.

I joined Richemont's Integration team as an Informatica Tech Lead to manage and develop critical data flows between the Cloud (GCP), the ERP (SAP), and the CRM (Salesforce), serving the Supply Chain, Finance, and Retail departments.

I performed the following tasks:

- Management and development of hybrid integration flows (On-premise to Cloud) via Informatica PowerCenter and IDMC (CDI).

- Industrialization of complex interfaces between SAP and Anaplan for planning needs.

- Implementation of advanced mappings using APIs (WebDAV, JMS, Service Connectors, CAI).

- Data lifecycle management: from development to resolution of production incidents in a critical environment.

- Transversal collaboration in an international and bilingual environment (French/English).

My mission helped secure and automate data exchanges between the group's technological pillars (SAP, Salesforce, GCP). This industrialization reduced manual interventions on financial and logistics flows, ensuring better data integrity for closing and inventory reports.

Technical context: Informatica IDMC (CAI/CDI), PowerCenter 10.4.1, GCP, SAP BW/CRM, Salesforce, Anaplan, REST/WebDAV APIs, JMS, Postman, Jira, Confluence, Agile.

Within Richemont's Wholesale team, the challenge was to modernize the global B2B platform to streamline commercial relationships with luxury partners and resellers. This digital transformation project aimed to migrate the entire transactional ecosystem to a modern Salesforce infrastructure.

I joined the Wholesale team as an Informatica Tech Lead to manage the integration and migration of data for over 20,000 international points of sale, ensuring service continuity during deployments (roll-outs).

I performed the following tasks:

- Complete migration of critical data from the old platform (SQL Server) to the new one (Salesforce).

- Development and optimization of complex PowerCenter mappings integrating API calls (REST/SOAP).

- Technical orchestration of international deployment waves (roll-outs).

- Gathering business requirements, technical effort estimation, and coordination with functional teams.

- Automation of integration processes to ensure data exchange reliability.

During my assignment, I successfully migrated over 20,000 points of sale without service interruption. The automation of recurring flows and tasks reduced manual interventions by 30%, significantly increasing the productivity of the support team and the reliability of customer data.

Technical context: Informatica PowerCenter 10.4.1, Salesforce, SQL Server 2019, REST/SOAP APIs, Postman, Jira, Confluence, Agile Methodology.