Data Engineer Talend - SSIS - Freelance

Mission based in Velizy

2j remote /week

Professional English required

Building required infrastructure for optimal extraction, transformation and loading of data using ETL (Talend, SSIS, ADF) and SQL.

Developing reusable ETL jobs and use cases.

Familiar with ETL feeding mechanisms (Delta/Full Loading, Historical data).

Debugging and problem-solving attitude in ETL jobs and addressing production issues

Follow best practices and guidelines from development to deployment.

Experience building and interacting with Data Lake solutions, integration with source systems through various modes APIs, file transfers, and other data ingestion mechanisms.

Build Data Warehouses, Data Marts and Data Cubes.

Assembling large, complex sets of data that meet functional business requirements.

Working with stakeholders including the, Product Owner, Crew members, Administrator and platform team.

Support the qualification of the projects (Data Scoping / Discovery).

Good knowledge of Agile methodology.

Highly skilled in the Microsoft SQL Server stack, including Database Engine, Integration Services (SSIS), Analysis Services (SSAS), and Power BI Reporting Services (PBIRS).

Advanced expertise in SQL, DAX, and MDX, with strong capabilities in query performance tuning and optimization.

Proven experience in building and operating data infrastructure for efficient data extraction, transformation, and loading (ETL/ELT).

Experience using dbt for data transformation and modeling.

Familiarity with distributed query engines such as Trino (or equivalent).

Knowledge of object storage systems such as MinIO (or equivalent).

Strong understanding of modern data architectures, including the medallion architecture

Nice to have: Experience with scalable data pipelines on GCP (BigQuery, GCS, Dataproc)

Familiar with fully automated CI/CD pipelines (Azure DevOps, Gitlab) for code deployment, integration and test automation, code quality, and orchestration for automated build and release.