Data Engineer Talend - Ssis H/F - Tactik Consulting
- Vélizy-Villacoublay - 78
- Indépendant
- Télétravail accepté
- Tactik Consulting
Les missions du poste
Le besoin
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 operatingdatainfrastructure 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.