2022 – 2024 · E2E ETL pipeline

Healthcare Data Platform

End-to-end ETL for a global wellness brand. POS and ERP APIs into the warehouse.

Overview

Built at Aretove. Pipeline from point-of-sale and ERP feeds into SQL Server. Azure Logic Apps and Fivetran for ingest. Owned VMs, pipeline runs, and data quality. Client name stays generic.

Challenge

Source systems did not agree on keys, types, or timing. The warehouse had to stay queryable while feeds changed.

Approach

Logic Apps for awkward APIs. Fivetran where a connector existed. SQL Server as the warehouse. Data-quality checks before reporting tables.

Outcome

Downstream teams queried one warehouse instead of three source systems. No public URL.

Azure Logic AppsFivetranSQL Server