Data Engineer FR (Porto)
Summary
Design and maintain ETL pipelines with PowerCenter, optimize PL/SQL for Oracle, and build enterprise data warehouses while ensuring data quality and governance.
🚀 What You'll Do
- Design, develop, and maintain robust ETL pipelines using PowerCenter or similar ETL tools.
- Develop and optimize complex PL/SQL procedures, functions, and queries.
- Design and evolve enterprise Data Warehouse solutions, ensuring data quality and integrity.
- Collaborate with business and technical teams to translate data requirements into scalable solutions.
- Monitor, maintain, and optimize existing ETL processes and data pipelines.
- Troubleshoot data integration issues and improve platform performance.
- Apply best practices in Data Governance, security, and data quality.
- Contribute to reporting and dashboard development using Power BI (nice to have).
- Mentor junior team members and promote engineering best practices.
🛠️ What We're Looking For
- Minimum 6 years of experience as a Data Engineer, ETL Developer, or similar role.
- Strong experience with PowerCenter (or Talend, ODI, or equivalent ETL tools).
- Excellent knowledge of PL/SQL and Oracle databases.
- Solid understanding of Data Warehouse architecture and relational/dimensional data modeling.
- Experience designing, optimizing, and supporting enterprise data pipelines.
- Strong analytical and problem-solving skills.
- Ability to work independently and collaborate within multidisciplinary teams.
Technical Stack
- PowerCenter
- Talend (Nice to Have)
- Oracle Data Integrator (ODI) (Nice to Have)
- PL/SQL
- Oracle Database
- Data Warehouse
- ETL
- Power BI (Nice to Have)
Languages
- 🇫🇷 French – Fluent (C2) – Mandatory
- 🇬🇧 English – Nice to Have