Missions ETL : Une multitude d'offres publiées toutes les semaines

Résumé des missions de Wael,
freelance ETL résidant dans la Seine-Saint-Denis (93)

Data Architect
Avanade
3 -
&bull Client: Candriam
&bull Design and Implement a Data pipelines for Datawarehouse, Data Mart
&bull Implement Enterprise Data Catalogue (IDMC) for Instrument Data Domain
&bull Role: Technical leader of Data Integration Team
Environment and Technology: InformaticaDeveloper, IDMC, Azure SQL DB, Azure Synapse, Azure

DevOps
Cognizant
11/2019 - 3/2022
Data Architect:
&bull Client: BNP Paribas Securities Services
&bull Design and Implement a Data Hub as A Service
&bull Role: Technical leader of Datahub team
&bull Environment and Technology: MapRDB / HBase, MapR FS / Hadoop, Ab-Initio, Shell, Spark, JIRA

Big Data Project Manager:
Renault Quality Department
7/2019 - 11/2019
&bull Responsible for Data Lake projects of Quality department, agile methodology
&bull Driving an offshore technical team
&bull Incident management and coordination
Hortonworks 2.6.5, Spark, Hive, JIRA

ETL and BI Architect:
Sofrecom (Orange Business Services)
1/2018 - 4/2019
Implementing Business Intelligence Module for Call Center Cloud Offer
&bull Environment: Cosmo Call, SQL Server 2012, Talend 7.1
&bull Responsible for functional and technical ETL specification documentations
&bull Responsible for Designing ODS, DWH and DM models
&bull Responsible for Facts and Dimensions ETL jobs implementations
- 3 -

Senior Data Modeler: Modeling a Datawarehouse solution for a supplier of energy
Eneo Cameroon (via Data Bridge SUARL)
7/2017 - 12/2017
&bull Animating Workshops of business needsspecification and defining business KPIs
&bull Usage of Kimball approach to design the Datawarehouse model and Data Marts
&bull Writing the technical specifications of the ETL jobs to feed the model put in place
SQL Server 2012, ER Builder, Excel

Senior ETL Architect:Data warehouse Rebuilding
Ooredoo
7/2013 - 6/2017
&bull Datawarehouse Design, Data Modelling, Creating functional and technical ETL specifications
&bull Complex GreenPlum process development, test and validation
&bull Complex Informatica ETL process development, test and validation
&bull Advanced Performance Tuning for the daily load process.
INFORMATICA Power Center, Pivotal GreenPlum, Erwin

ETL Team Leader
Orange Tunisia
-
&bull Project Management (workshop leading, team management, alert reporting, progress monitoring)
&bull ETL process development, test, and validation
&bull ETL process design, Functional and Technical specification validation
&bull Design Data Warehouse model, Design Operational Data Store model, Design Data Mart model
&bull Shell, PLSQL scripting
TALEND ETL, ORACLE data base, Shell UNIX

Informatica Developer: Legacy to SAP DATA MIGRATION
Faurecia
2008 - 2010
&bull Design and development of ETL mappings responsible for migration of data since several ERP (+40)
towards SAP with Informatica POWER CENTER
&bull DATA Quality control with Informatica DATA QUALITY (IDQ)

Architecte ETL et Big Data
Orange Application for Business (OAB)
1/2018 - 4/2019
Responsable Mise en place d&rsquoun système décisionnel (temps différé) pour une plateforme Centre d&rsquoAppels en Cloud
⦁ Concepteur du modèle ODS, Datawarehouse et Data Marts (modèle en étoile et SCD 2)
⦁ Responsable rédaction des spécifications fonctionnelles et techniques des jobs ETL
⦁ Responsable Conception, développement, test et validation des jobs alimentation ODS et Dimensions du Datawarehouse

Responsable Mise en place d&rsquoune solution Dashboard temps réel des KPI des centres d&rsquoappels
⦁ Responsable Conception d&rsquoune architecture lambda (cohabitation des traitements en batch et des traitements temps réels)
⦁ Dashboard temps reel : Nifi, Kafka, Spark, Scala, Druid et Superset
⦁ Data Lake temp différé : Nifi, Kafka, Hbase, Spark, Scala
Cosmo Call, SQL Server 2012, Talend 7.0.1, ER Builder, CentOS 7 HDP 2.6.5 et HDF 3.0.1

Data Architecte : Modélisation des Données
ENEO Cameroun
7/2018 - 12/2018
Responsable Modélisation d&rsquoune solution Datawarehouse pour un fournisseur d&rsquoénergie
⦁ Animation des Workshop expression des besoins et rédaction des KPI métier
⦁ Mise en place de l&rsquoapproche Kimball pour concevoir le modèle ODS, le modèle Datawarehouse (modèle en étoile et SCD 2) et les Data Marts
⦁ Rédaction des spécifications fonctionnelles et techniques des jobs ETL pour alimenter le modèle mis en place
SQL Server 2012, ER Builder, Excel