Freelancer profile translated to English.

Description

Data & Cloud Consultant with over 13 years of experience in designing and modernizing data platforms. Expert in Snowflake, Azure, and Informatica, I assist companies in transforming their data ecosystem: cloud migration, integration, industrialization, and governance. Accustomed to complex environments, I work on both technical and strategic levels, driving evolution, best practices, and team skill development.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Paris (up to 50km), Paris (up to km)

Saint-Gobain
Snowflake Technical Leader
RAW MATERIALS INDUSTRY
November 2023 - Today (2 years and 7 months)
Paris, France
MISSION: Snowflake Technical Leader, Saint Gobain – 11/2023 To Present:
• Technical leadership for the migration of the SQL Server Data Warehouse to Snowflake, including the redesign of integration and orchestration logic.
• Implementation of CDC (Change Data Capture) for data synchronization between SQL Server, SAP, and Snowflake.
• Design of an automated ingestion pipeline:
o External stages (Azure Blob Storage) for SAP data reception,
o Snowpipe for automated loading,
o Streams & Tasks for real-time change capture and processing.
• Migration and optimization of SQL Server procedures to Snowflake SQL, with refactoring and performance tuning.
• Redesign of log management and incremental loads on Snowflake.
• Development and orchestration of Azure Data Factory (ADF) pipelines replacing SAP BODS.
• Setup and security of the Azure ecosystem: Blob Storage, Key Vault, Snowflake Stages, Resource Groups.
• Automation of Power BI triggers via ADF.
• Development of Python / Streamlit applications connected to Snowflake for data supervision and visualization.
• Use of DBT and Airflow for transformation and industrialization of Snowflake flows.
• Backlog tracking on JIRA, code review, and CI/CD deployments via Azure DevOps (Snowflake & ADF).
• Technical mentoring, definition of best practices, coordination with Data Platform and business teams.
• Technical and functional documentation on Confluence.
• Define and develop logic and frameworks for industrialization and incremental load.
Technical environment: Snowflake, Azure, Azure Data Factory, Azure DevOps (CI/CD), Python, Streamlit, DBT, Airflow, Terraform, Power BI, SQL Server, SAP BODS, CDC, Snowpipe, Streams, Stages.
Snowflake Azure DevOps Azure Data Factory SAP S/4 HANA Microsoft Power BI
DANONE
Data Technical Leader
AGRICULTURE
January 2019 - November 2023 (4 years and 9 months)
Paris, France
MISSION: Data Technical Leader, Danone – 03/2019 To 11/2023:
• Design and modernization of the Data Cloud platform on AWS, Azure, and Snowflake.
• Design and population of Snowflake Data Lake / Data Warehouse, including the implementation of RLS (Row-Level Security).
• Development and orchestration of pipelines with Informatica IICS, integrating Snowflake, AWS S3, Azure ADLS GEN2, DB2, Postgres.
• Development of advanced integrations in Python (SQL data, semi-structured, REST API).
• Use of Databricks (PySpark) and AWS Glue for transformation and preparation of analytical data.
• Implementation of incremental load frameworks and development standards on Informatica IICS and Snowflake.
• Automation of deployments and continuous integration via Azure DevOps and GitHub.
• Utilization of AWS services (S3, RDS, Lambda) and Azure (ADLS, Blob Storage) for multi-cloud management.
• Execution of Cloud POCs: migration to Snowflake, API integration, archiving on S3 and ADLS.
• Technical mentoring and skill development for the Data team.
• Contribution to the transition from Informatica BDM/PowerCenter to IICS + Snowflake in a cloud-native approach.
• Provide support, onboarding, and skill development for new team members.
• Act as tech-lead for Snowflake and Informatica Cloud technologies.
• Integrate data from various source systems into Hive, Impala, Kudu databases using Informatica BDM and Python.
Technical environment: Snowflake, Informatica IICS, AWS (S3, RDS, Glue, Lambda), Azure (ADLS, Blob Storage), Databricks, Python, SQL, REST API, GitHub, Azure DevOps, Power BI.
informatica cloud Snowflake Microsoft Azure Python AWS S3
Ooredoo
Business Intelligence Senior Engineer
TELECOMMUNICATIONS
October 2011 - January 2019 (7 years and 3 months)
Alger, Algeria
Business Intelligence Senior Engineer
Project: Data Warehouse Migration to Greenplum (2014–2018)
• Project breakdown into phases: Subscriber/Customer, Traffic & Recharge, Invoice, Post-Production.
• Requirements analysis, Source-to-Target Mapping (STM) writing, functional and technical validation.
• Migration and development of Informatica PowerCenter flows, use of PowerExchange 9.6 CDC.
• Technical support for the Greenplum project team and validation of SIT & UAT developments.
• Post-production optimization and maintenance.
Other projects:
• BI Automation – Development of KPI flows with Informatica PowerCenter.
• Churn & Segmentation – Extraction and validation of customer data.
• Loyalty Program – ETL development under SAP Data Services (BODS).
• Migration ETL SAP BODS to Informatica PowerCenter – Analysis, STM, integrator support, ETL development.
• CBIO Migration – Adaptation of ETL processes to new source systems.
• Maintenance & ETL batch – Daily monitoring, correction, enrichment of processes.
Technical environment: Informatica PowerCenter 9.5/10, PowerExchange 9.6, SAP Data Services 12 (BODS), Greenplum, Oracle, UNIX, Erwin, SQL Server.
Green Plum Informatica Power center Oracle ETL Datawarehouse