Khaled k

Designed and built a reusable Data Ingestion Layer during a GCP (GCS, BigQuery, dbt Cloud) to AWS (S3, Redshift, dbt Core) migration. Developed a metadata-driven ingestion framework handling schema inference, schema reconciliation, schema evolution, and normalization of heterogeneous Parquet datasets before exposure to downstream analytics and dbt transformations. Implemented monitoring, logging, idempotent loading strategies, and operational tooling for production-grade data pipelines. Compétences: Python, PyArrow, AWS S3, Amazon Redshift, SQL, Parquet, JSON, Redshift SUPER, dbt Core, dbt Cloud, BigQuery, GCS

Worked in a multi-project TMA environment as a technical reference on Talend pipelines, supporting critical production workflows across several data initiatives. • Led maintenance and evolution of Talend pipelines across multiple projects • Investigated and resolved production issues in critical data flows • Contributed to knowledge transfer and onboarding on various tools (SSIS, Qualtrics, Genio) • Provided cross-team support on data integration and data quality topics • Upskilled on cloud environments (GCP, BigQuery) and Microsoft data stack → Ensured service continuity across multiple critical pipelines → Improved stability and maintainability of legacy data workflows Tech stack: Talend (TIS Big Data 7.3.1, TAC), Teradata, SQL Server, SSIS, GCP, BigQuery

Worked on a large-scale legacy data platform (400+ pipelines), combining production ownership, platform modernization (Snowflake/dbt), and delivery of business-oriented data products. Key role across 3 main areas: • Legacy platform stabilization • Migration to modern data stack • Business data use cases 🔹 Legacy Data Platform (Talend / Airflow / Oracle / Redshift) • Ownership of ~400 batch pipelines (Talend) in production • Production monitoring & incident management (Airflow) • Optimization of critical SQL pipelines (high-complexity queries, margin calculation – 800+ lines) • Data contracts with business teams (Finance, operations) → Ensured daily availability of reporting for ~30 agencies 🔹 Migration to Modern Data Stack (Snowflake / dbt Core) • Designed migration strategy after an initial full-Python approach was not retained • Built generic pipeline: Oracle → S3 (JSON) → Snowflake • Migrated 400–500 tables with dbt (staging → DWH → marts) • Leveraged dbt lineage for dependency management • Implemented data quality tests with dbt (uniqueness, not null, relationships) • Reduced margin pipeline runtime: 1h → 5 min • Reduced batch time: 7h → 3h • Decommissioned 40–60% of legacy Airflow pipelines 🔹 Business Data Products • Built automated financial data product (Google Sheets) • Replaced manual Excel process (3–4x/year) with daily updates • Enabled proactive financial monitoring across agencies → Shift from reactive to proactive decision-making

Delivered end-to-end data engineering solutions across multiple industries (media, banking, retail), from data ingestion to BI reporting. • Designed and developed ETL pipelines using Talend (APIs, files, databases) • Built and modeled data marts (star/snowflake schemas) aligned with business KPIs • Integrated data into cloud and BI environments (Azure SQL, Power BI, Salesforce) • Maintained and optimized data pipelines (performance, reliability, monitoring) • Worked in Agile environments (Kanban, backlog, user stories) Key achievements: • Delivered Azure-based data marts for FranceTV Publicité (Freewheel, Mediasquare) • Built API → Azure → Salesforce integration pipelines • Improved data quality and performance across multiple projects Tech stack: Talend Cloud, TMC, SQL Server, Azure, Power BI, Salesforce, MariaDB, Alfresco, Airflow

Worked on BI and data platform projects across banking, insurance, and retail sectors, focusing on ETL development and data warehouse design. • Developed and maintained ETL pipelines using Talend (Oracle, SQL Server, DB2, flat files) • Designed data warehouse architectures (star, snowflake, constellation schemas) • Optimized SQL queries and ETL performance (indexing, tuning) • Built and maintained BI reports using Jaspersoft • Participated in technical design, specifications, and production support Key achievements: • Reduced processing times by up to 70% on critical pipelines • Delivered end-to-end BI pipelines (ODS → DWH → reporting) • Improved data quality and reliability across systems Tech stack: Talend (TIS, TAC), Oracle, SQL Server, DB2, MySQL, Jaspersoft, SQL Developer

Client: EDF Expertises : MySQL, VBA, php-myadmin, Talend Open Studio, wamp Suivi de production pour un portail SIRH, conception & maintenance évolutive d’une datamart BI Durée : 1 an. Période De oct 2012 à sept 2013 Expertises: MySQL, VBA, php-myadmin, Talend Open Studio, wamp Analyse • Audit des besoins de la MOA • Conception, modélisation MERISE et développement d’une base BI MySQL • Traitement « qualité de données » des fichiers de log Excel/csv Maîtrise d’œuvre • Création de jobs Talend TOS : afin d’alimenter la base BI à partir des fichiers de logs Excel. • Maintenance évolutive, Documentation de suivi et reporting BIRT.

Expertises : Balsamic mockup, Talend Open Studio, Mysql, postgresql, Testlink, Fusion Forge, Mantis, Afresco, Ubuntu 10.10, centOS Audit technico-fonctionnel d’une Forge (fusionForge) intégrée avec manis, testlink, alfresco , et son intégration technique Spécifications technico-fonctionnelles - projet fusionForge (système de gestion collaboratif de logiciels open -source) : Aout 2011-Sept 2012 • IHM de l’interface de fusionForge v2 • Spécifications technico-fonctionnelles • Audit du besoin • Design des IHM de fusionForge v2 • Conception fonctionnelles des scénarii users, étude du périmètre technique de la v2, conception d’une documentation Road Map Talend. • Validation auprès des utilisateurs et du manager Intégration d’une forge - projet fusionForge (système de gestion collaboratif de logiciels open -source) : Février 2011 -Juillet 2011 Analyse • Audit du besoin & étude des spécifications • Montée en compétences sur Talend Open Studio Maitrise d’œuvre • Développement de jobs Talend & orchestration de flux entre les DB • Déploiement & installation d’un serveur apache, de Alfresco, Testlink et Mantis en local • Déploiement de la forge Fusion Forge sur ubuntu 10.10 puis sur centOs en VM Maintenance & qualité • Campagne de tests fonctionnels avec les utilisateurs et équipes MOE, • Tests performances/qualitatifs Développement : Décembre 2009 - Février 2011 • Renfort technique • Développeur J2EE, cake php, javascript. Intégration outil « splunk ».