Aubay PortugalData Engineer
Nov. 2022 - Jan. 2024Lisbon, PortugalSAP HANA: Advanced management of procedures and triggers in SAP HANA, ensuring consistent performance, operational stability, and integrity of critical data. SAP HANA to Snowflake Migration: Technical leadership in the strategic migration of SAP HANA databases to Snowflake, leveraging Airflow to automate processes, ensure operational continuity, and significantly reduce transfer times and associated risks. Airflow: Development and management of robust and scalable data pipelines using Airflow, optimizing data flows and improving reliability and performance across multiple platforms and services. dbt Cloud: Strategic implementation of dbt Cloud for data transformation, modeling, and governance, enabling agile integrations, accurate analytics, and rapid deliveries to business areas. ELT Architecture: Design and maintenance of a structured ETL architecture with clearly defined layers (Stage, Transform, Test, and Product Layers), enhancing quality and standardization of deliverables. Utilized Jira for agile project management and transparent tracking of tasks and project demands.