Missions ETL : De nombreuses offres mises en ligne quotidiennement

Résumé d'expériences de Wael,
freelance ETL résidant dans la Seine-Saint-Denis (93)

• DevOps

  Cognizant
  Jan 2019 - Jan 2022

  &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
  Jan 2019 - Jan 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

• Data Architecte : Modélisation des Données

  ENEO Cameroun
  Jan 2018 - Jan 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

• ETL and BI Architect:

  Sofrecom (Orange Business Services)
  Jan 2018 - Jan 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 -

• Architecte ETL et Big Data

  Orange Application for Business (OAB)
  Jan 2018 - Jan 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

• Senior Data Modeler: Modeling a Datawarehouse solution for a supplier of energy

  Eneo Cameroon (via Data Bridge SUARL)
  Jan 2017 - Jan 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
  Jan 2013 - Jan 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)

• Data Architect

  Avanade
  aujourd'hui

  &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