Landry Charlier
Senior Data Engineer | Snowflake & ETL
Salaire / Taux journalier
Montpellier, France
Freelance, ouvert au CDI
Peut venir sur site
Expertises
Langues
À propos
Introduction
Data Engineer with 10+ years of experience specializing in cloud data warehouses and ETL solutions. Led development of automated Snowflake warehouses using C# APIs and designed high-performance data flows for major enterprises like Orange and Sanofi. Expert in modern data stack including Snowflake, Azure, and SQL Server with proven track record of optimizing data pipelines and training development teams.
Expérience de travail
Software R&D Engineer - BI Lead developer
YooSoft
juin 2022 - Présent
4 ans 5 mois
Montpellier, France
Development of a C# application enabling the creation and automated population of Snowflake data warehouses via API. Management and administration (RBAC) of the various Snowflake accounts. Management, development, and support of client projects. Technical environment: - Snowflake - Postgre SQL - C# - Source control: Git (via TFS) - Windows
Business&Decision
sept. 2019 - juil. 2022
2 ans 11 mois
Montpellier, France
BI consultant
janv. 2020 - juil. 2022
2 ans 7 mois
Montpellier, France
Consultant at Orange (Montpellier) - Technical Lead on the Fiber Project and Developer on the Intervention Project: developed SQL data flows using the SSIS ETL to feed data marts and generated SSAS cubes for data analysis. - Developed an automation tool for processing index and column statistics based on a maintenance window. - Created an ETL development methodology enabling automatic extraction of rejected records during source data integration. - Conducted performance testing and query optimization. - Provided support and maintenance. - Trained new developers. Technical environment: - SSIS - SSAS - SQL Server - Windows - Source control: Git (via TFS)
BI consultant
sept. 2019 - déc. 2019
4 mois
Montpellier, France
Consultant at Sanofi (Montpellier), 3-person team Developed SQL data flows using the Informatica ETL to feed the data warehouse and conducted non-regression testing. Technical environment: - Informatica - Oracle - Windows
Acelys Services Numériques
juil. 2014 - oct. 2019
5 ans 4 mois
Montpellier, France
BI consultant
sept. 2018 - oct. 2019
1 an 2 mois
Montpellier, France
Consultant at Orchestra-Prémaman (Saint-Aunès) Development of SQL data flows and monitoring reports: - Drafted functional analyses. - Analyzed and fixed issues in existing monitoring reports (performance, stability, relevance). - Developed SQL data flows using the Genio ETL to feed the monitoring datamart. - Created reports using SAP BusinessObjects. - Conducted testing and validation (functional, performance, volume). - Provided support and maintenance for developed data flows and reports. Technical environment: - SQL Server 2014 - Genio (ETL) - SAP BusinessObjects - Windows
C# consultant
août 2018 - août 2018
1 mois
Montpellier, France
Consultant at Idéalys (Montpellier) Added functionalities to a CQRS API: - Backend development - Frontend development Technical environment: - .NET 4.5 / C# - AngularJS - nHibernate (ORM) - SQL Server 2017 - Source control: Git (via TFS) - Windows
C# consultant
juin 2018 - juil. 2018
2 mois
Montpellier, France
Consultant at Smag (Montpellier) Backend development of a database synchronization application between ElasticSearch and SQL databases (SQL Server and MariaDB) Technical environment: - .NET 4.5 / C# - ElasticSearch - nHibernate (ORM) - SQL Server 2017 - MariaDB - Windows - Source control: Git
C#/WPF consultant
mai 2016 - mai 2018
2 ans 1 mois
Montpellier, France
Consultant at Hélios (Lattes) Development of a cash register application in WPF: - Drafted functional analyses. - Developed the application using the MVVM pattern. - Conducted testing and validation (functional, performance). Technical environment: - .NET 4.5 / C# - WPF - Entity Framework (ORM) - SQL Server 2008 - Caliburn.Micro (WPF Framework) - Windows - Source control: TFS
ETL consultant
juil. 2014 - mai 2016
1 an 11 mois
Montpellier, France
Consultant at Orchestra-Prémaman (Saint-Aunès) Development of SQL data flows between the Colombus ERP, Manhattan WMS, and the customs service provider: - Drafted functional analyses. - Developed SQL data flows using the Genio ETL. - Conducted testing and validation (functional, performance, volume). - Provided support and maintenance for developed data flows. Technical environment: - SQL Server 2014 - Genio (ETL) - Colombus (ERP) - Manhattan (WMS) - Windows
ETL consultant
Acelys Service Numérique
août 2018 - oct. 2018
3 mois
Montpellier, France
Consultant at Idéalys (Montpellier) Integration of ElasticSearch data into a SQL Server database for activity report generation: - Developed a custom SSIS component in C# to extract data from ElasticSearch and integrate it into a T-SQL database. - Designed and implemented SSIS data flows. Technical environment: - .NET 4.5 / C# - SQL Server 2017 - ElasticSearch - SSIS - Windows - Source control: Git
Postdoctoral Researcher in molecular modeling
Institut des Biomolécules Max Mousseron
févr. 2012 - janv. 2014
2 ans
Montpellier, France
- In silico construction and simulation of molecular models. - Development of Perl scripts based on the project's functional specifications. - Development of a web server for file transformation using HTML/PHP/CSS. - My research resulted in the publication of five articles in peer-reviewed scientific journals. Technical environment: - Perl - Bash - PHP - Linux (Fedora)
Postdoctoral Researcher in molecular modeling
CERMAV-CNRS
déc. 2009 - déc. 2011
2 ans 1 mois
Grenoble, France
Responsible for the development of the molecular model construction protocol - Defined project specifications. - Developed the GUI using Perl/Tk. - Wrote the user manual. - Trained users on the developed scripts and GUIs. - Constructed and simulated in silico molecular models via the GUI. - Developed Perl scripts for: • File conversion between various software tools. • Job automation. - My research resulted in the publication of four articles in peer-reviewed scientific journals. Technical environment: - Perl/Tk - Bash - Linux (RedHat)
PhD student in molecular modeling
LCMBA - Université Nice Sophia Antipolis
oct. 2006 - oct. 2009
3 ans 1 mois
Nice, France
- In silico construction and simulation of molecular models. - Development of Perl scripts based on the project's functional specifications. - Responsible for C programming practical sessions for second-year undergraduate students: • Assisted during lab sessions (guidance and debugging). • Supported students in their end-of-year projects. - My research resulted in the publication of ten articles in peer-reviewed scientific journals. Technical environment: - Perl - Bash - Linux (OpenSuse)
Formation
Université Côte d'Azur
Doctorat en Bioinformatique
2006 - 2009
4 ans
Licences et certifications
MCSA: SQL 2016 Database Development
Délivré le : janv. 2021
Portfolio
Responsable technique sur la datamart Fibre
Développement d'un automate de traitement des statistiques d'une base de données
