CV/Mission INFORMATICA DATA QUALITY freelance

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

• Data Architect:

  • Client: Candriam
  Jan 2022 - aujourd'hui

  • Design and Implement a Data pipelines for Datawarehouse, Data Mart
  • Implement Enterprise Data Catalogue (IDMC) for Instrument Data Domain
  • Role: Technical leader of Data Integration Team

  • Environment and Technology: InformaticaDeveloper, IDMC, Azure SQL DB, Azure Synapse, Azure

• DevOps Data Architect:

  • Client: BNP Paribas Securities Services
  Jan 2019 - Jan 2022

  • Design and Implement a Data Hub as A Service
  • Role: Technical leader of Datahub team

  • Environment and Technology: MapRDB / HBase, MapR FS / Hadoop, Ab-Initio, Shell, Spark, JIRA

• Big Data Project Manager:

  • Client: Renault Quality Department
  Jan 2019 - Jan 2019

  • Responsible for Data Lake projects of Quality department, agile methodology
  • Driving an offshore technical team
  • Incident management and coordination

  • Environment and Technology: Hortonworks 2.6.5, Spark, Hive, JIRA

• Data Architecte : Modélisation des Données

  ENEO Cameroun
  Jan 2018 - Jan 2018

  ⦁ Responsable Modélisation d’une solution Datawarehouse pour un fournisseur d’énergie
  ⦁ Animation des Workshop expression des besoins et rédaction des KPI métier
  ⦁ Mise en place de l’approche 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

  ⦁ Environnement et Technologies : SQL Server 2012, ER Builder, Excel

• ETL and BI Architect: Implementing Business Intelligence Module for Call Center Cloud Offer

  Sofrecom (Orange Business Services)
  Jan 2018 - Jan 2019

  • Environment: Cosmo Call, SQL Server 2012, Talend 7.1
  • Responsible for functional and technical ETL specification documentations
  • Responsible for Designing ODS, DWH and DM models
  • 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’un système décisionnel (temps différé) pour une plateforme Centre d’Appels 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
  ⦁ Environnement et Technologies : Cosmo Call, SQL Server 2012, Talend 7.0.1, ER Builder, CentOS 7
  
  ⦁ Responsable Mise en place d’une solution Dashboard temps réel des KPI des centres d’appels
  ⦁ Responsable Conception d’une 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

  ⦁ Environnement et Technologies : HDP 2.6.5 et HDF 3.0.1

• Eneo Cameroon (via Data Bridge SUARL
  Jan 2017 - Jan 2017

  Senior Data Modeler: Modeling a Datawarehouse solution for a supplier of energy
  • Animating Workshops of business needsspecification and defining business KPIs
  • Usage of Kimball approach to design the Datawarehouse model and Data Marts
  • Writing the technical specifications of the ETL jobs to feed the model put in place
  • Environment and Technologies: SQL Server 2012, ER Builder, Excel

• Senior ETL Architect:Data warehouse Rebuilding

  Ooredoo
  Jan 2013 - Jan 2017

  • Datawarehouse Design, Data Modelling, Creating functional and technical ETL specifications
  • Complex GreenPlum process development, test and validation
  • Complex Informatica ETL process development, test and validation
  • Advanced Performance Tuning for the daily load process.

  • Environment and Technologies: INFORMATICA Power Center, Pivotal GreenPlum, Erwin

• ETL Team Leader

  Orange Tunisia:
  2010 - 2013

  • Project Management (workshop leading, team management, alert reporting, progress monitoring)
  • ETL process development, test, and validation
  • ETL process design, Functional and Technical specification validation
  • Design Data Warehouse model, Design Operational Data Store model, Design Data Mart model
  • Shell, PLSQL scripting
  • Tools: TALEND ETL, ORACLE data base, Shell UNIX

• Informatica Developer: Legacy to SAP DATA MIGRATION

  Faurecia
  2008 - 2010

  • Design and development of ETL mappings responsible for migration of data since several ERP (+40)
  towards SAP with Informatica POWER CENTER
  • DATA Quality control with Informatica DATA QUALITY (IDQ)