Elhaouti A.

Within the DATA AND AI DEPARTMENT of BPIFRANCE, the objective is to manage the data quality process by implementing quality rules across the entire Bpifrance scope, and to meet regulatory requirements for data quality.

Roles and responsibilities:

• Work using SAFE methodology with all stakeholders, particularly other teams in the train.

• Gather client needs to define quality requirements, participate in workshops.

• Train junior developers on Informatica Cloud and ensure their skill development, particularly on data quality tools.

• Develop Informatica Developer interfaces (LDO, Mapping, Mapplet, complex rule specification).

• Participate in Informatica Developer version upgrades.

• Set up the Informatica Cloud platform (on-premise secure agent/EC2 configuration, creation of different connection types, project authorization & access...).

• Control data quality of a Topic, REST API, S3, Athena…

• Create Informatica Data Integration CDI mappings & Mapping tasks.

• Create Informatica Application Integration CAI Processes & APIs (uploading scorecard metrics, IDMC repo backup, IPU consumption metrics).

• Develop data quality interfaces using Informatica Cloud (Data Quality, Data Profiling).

• Scan databases, taskflows… to perform lineage and data classification for GDPR data (Metadata Command Center, Data Governance and Catalog).

• Production delivery via GitHub – CI/CD.

Technical environment:

Informatica IICS (Administrator, Data Integration, Data Quality, Data Profiling, Application Integration, Metadata Command Center, Data Governance and Catalog), Informatica Developer 10.5.3, AWS (Athena, EC2, IAM, GLUE, Lambda, etc…), Qliksense, Terraform, Jenkins, Postman, REST API V2, Legacy Databases (Oracle, DB2, Postgresql..), Snowflake

Informatica/PowerBI/SSAS Expert: Within RESG/CFT/FIN/PAC/PRO (entity attached to the accounting domain of SG) which is responsible for managing and implementing innovative solutions and enabling secure data access for the largest number of users:

BI: OSERIS: Solution for controlling risky manual entries at the Group level with a scope-based view (multi-source Informatica ETL, SSAS cube, PowerBI).

Big/Data: Ara: is an analysis tool that helps to quickly and effectively identify significant/unusual variations during a monthly analytical review process of the SGPM entity, based on the Group Data Lake, on the SSAS OLAP cube, and on PowerBI (visualization tool):

BI Solutions Expert: Within the POSEIDON Hub (Entity attached to the Customer Relations Domain of GRDF IT Department) which aims to manage data-related projects, implement innovative solutions, and enable data access with partial or total autonomy for the largest number of users:

- In collaboration with project managers and product owners to ensure the integration of necessary internal and external data:

- Implement high-value reporting and data publication solutions.

- Participate in the design of BI solutions in compliance with the technical architecture of the data foundation, particularly in the construction of different data spaces (Reception Space, Simplification Space, Presentation Space (DM)).

- Participate in Informatica version upgrades.