This thesis was conducted at MSC Technology Italia as part of an enterprise-wide initiative to modernize and automate data ingestion processes across key business domains, including Finance, CRM, Logistics, Operations, and Liners. In the current hybrid architecture, Informatica PowerCenter is used to orchestrate ingestion workflows from various structured data sources. Azure Synapse Analytics supports the design and execution of cloud-native data pipelines, particularly for systems based on Oracle. This division reflects MSC’s progressive shift from traditional ETL to scalable, cloud-based processing. The project also aligns with MSC’s strategic objective to migrate toward Microsoft Fabric, a unified analytics platform built on a lakehouse model.