You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Jean-Marie DofontienJD

Jean-Marie Dofontien

Data Engineer

€700/day
Paris, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Jean-Marie

Data Engineer with over 5 years of experience specializing in data analysis and management, database model design, and data architecture development for efficient visualization.
Proven expertise in Snowflake models and Talend flow management, with particular skill in the Industry, Finance, Hospitality, and Human Resources sectors.
Possessing a high degree of autonomy, capable of working in multinational and English-speaking environments, and rigorously applying Agile or Scrum methodologies.
  • French

    Native or bilingual

  • English

    Fluent

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

Experience

  • Sanofi CHC Finance,
    Data Engineer
    September 2024 - January 2025 (4 months)
    France
    Mission: Fx Rates management Role: Snowflake Data Modeler & Data Architect
    • Technical architecture design: Definition of the data architecture in Snowflake to meet performance, scalability, and compliance requirements.
    • Data modeling: Development of the data model for storing and analyzing exchange rates, including the creation of dimensions and relationships between tables.
    • Writing technical specifications: Definition of the tables, schemas, and Snowflake views necessary for the data structure.
    • Multi-currency exchange rate calculation: Design of calculations for currency conversions, ensuring data accuracy for end-users.
    • Compliance and traceability: Design of C2 compliant models and lineage to ensure data compliance and traceability.
    • Integration with Power BI: Connection tests and validation of the integration between Snowflake and Power BI to facilitate reporting.

    Technical environment: Snowflake, Jira, Draw.io
  • Groupe Accor,
    Data Engineer - Cognizant
    May 2022 - April 2024 (1 year and 11 months)
    Paris, France
    Mission: Design and migration of HR and Payroll data Role: Snowflake Data Modeler
    • Specification of technical document for API link mapping and creation of the data dictionary,
    • Design, implementation, and maintenance of the data migration infrastructure,
    • Design, management of Snowflake models, and implementation of a data warehouse for reporting using the CI/CD process
    • Development of Talend tasks for extracting, processing, and loading data into AWS compartments,
    • Optimization of flows for better performance,
    • Planning and monitoring of tasks under TMC and Terraform/Snowflake,
    • Performing tests to ensure data quality,
    • Management of Production incidents on the Backend part

    Technical environment: Talend Cloud Big Data, Postman, TMC, Datahub, AWS S3, Terraform, Snowflake
  • Sanofi MDM Factory,
    Data Analyst - Cognizant
    October 2021 - April 2022 (6 months)
    Paris, France
    Mission: Analysis and optimization of ETL flows (IICS) Role: ETL Developer & Data Analyst

    • Analysis of ETL flows and SQL code update
    • Data update and validation
    • Performing unit tests
    • Implementation of flow specification documents

    Technical environments: IICS, PostgreSQL

Recommendations

Be the first to recommend Jean-Marie

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

  • Diplôme d'Ingénieur Informatique mention Ingénierie des Logiciels et de la Connaissance
    Université de Technologie de Belfort Montbéliard (UTBM)
    2020
    Diplôme d'Ingénieur Informatique mention Ingénierie des Logiciels et de la Connaissance
  • Licence Informatique, ingénieur des travaux.
    Institut Africain d'Informatique
    2015
    Licence Informatique, ingénieur des travaux.

Skill set

Categories