You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Ali LahbabiAL

Ali Lahbabi

Data Architect - Legacy Migration → Lakehouse

€950/day
Paris 11e Arrondissement, FR
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Ali

Data Architect with over 25 years of experience, specializing in the secure transformation of critical data systems.

I support organizations (public sector, finance, industry) on high-stakes programs, including:
  • decommissioning of legacy systems (mainframe, Oracle, SQL Server)
  • migration to modern architectures (Lakehouse, streaming, cloud)
  • implementation of real-time pipelines (CDC, Kafka, Spark)
  • structuring of robust, governed, and scalable data platforms

My approach is based on three pillars:
  • mastery of data dependencies (mapping, lineage, flows)
  • industrialization of migrations (frameworks, automation, patterns)
  • securing trajectories (coexistence, rollback, service continuity)

I work across the entire value chain:
  • strategic scoping and trajectory definition
  • target architecture design
  • implementation and industrialization
  • technical steering and multi-stakeholder coordination

Examples of achievements:
  • design of CDC pipelines synchronizing up to 300 databases
  • development of SQL → Spark migration frameworks
  • definition of decommissioning strategies in sensitive environments
  • migration to Lakehouse architectures (Iceberg / Trino)

Main technologies:
Spark, Kafka, SQL, PostgreSQL, Iceberg, Trino, Debezium, ClickHouse, AWS, Azure

I position myself for complex data transformation missions requiring a high level of expertise and security.

Available for migration, modernization, or decommissioning missions of critical data systems.
  • Spanish

    Native or bilingual

  • English

    Conversational

  • French

    Native or bilingual

Can work on-site
Paris 11e Arrondissement (up to 50km)

Experience

  • GEODIS
    Data Architect
    LOGISTICS AND SUPPLY CHAIN
    January 2025 - January 2026 (1 year)
    Migration of a SQL Server environment to a Lakehouse architecture (Iceberg / Trino).

    Development of an industrial migration framework covering structure, data, and logic.

    Automated transpilation of SQL Server procedures to Spark SQL to accelerate transformation.

    Target modeling in medallion architecture and definition of the decommissioning strategy.

    → Result: industrialization of migration and reduction of rewrite efforts.
    trino Apache Iceberg SQL Server IBM Db2 SAP BODS
  • Ministère de l'Intérieur – ANEF
    Data Architect
    PUBLIC SECTOR
    January 2025 - Today (1 year and 5 months)
    Decommissioning of a critical mainframe system in a sensitive regulatory environment.

    Mapping of business flows and data dependencies to identify impacts and secure the exit trajectory.

    Definition of source/target scopes and structuring of transformation steps.

    Design of a steering tool to track decommissioning progress.

    → Result: reduction of operational risk and control of critical dependencies.
    MongoDB Hackollade
  • Renault / Stellantis
    Data Architect
    AUTOMOBILE
    January 2024 - January 2025 (1 year)
    Implementation of a scalable data architecture with real-time synchronization.

    Deployment of a CDC architecture (Debezium / Kafka) to synchronize MySQL data to PostgreSQL.

    Setup of a PostgreSQL cluster (master + replicas) and a load balancing mechanism (PgPool).

    Structuring of a Data Warehouse in Bronze / Silver / Gold architecture.

    → Result: improvement of performance and reliability of real-time flows.
    ArangoDB SQL Server Apache Kafka Apache Spark

Recommendations

Be the first to recommend Ali

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • DESS in Computer Science and Life Sciences (double degree)
    Université René Descartes Paris V
    1992
    Ce DESS exclusivement réservé au diplômé de l'école de Médecine de Paris était essentiellement orienté vers l'enseignement des réseaux de neurones et les moteurs d'inférence. J'ai présenté mon mémoire sur le sujet des Algorithmes Génétiques qui sont l'un fondements de l'Intelligence Artificielle.
  • Certificate of Clinical and Therapeutic Synthesis (Medical Degree)
    Université René Descartes Paris V
    1992

Certifications

  • Retengr DataScientist
    Retengr
    2019

Skill set

Categories