AI/ML2025

Swickard ADF

Enterprise Azure Data Factory for automotive dealership data integration

Swickard ADF
( Overview )

Production Azure Data Factory implementation for Swickard Auto Group. Built end-to-end data pipelines processing vendor feeds and CSV data through Bronze/Silver/Gold medallion architecture with Data Vault 2.0 patterns. Includes 27+ business entities, Azure Functions for ETL, and comprehensive CI/CD pipelines.

( Highlights )
  • 01Designed Bronze/Silver/Gold medallion architecture for enterprise data warehouse
  • 02Built 2 Azure Function Apps for SFTP and CSV processing
  • 03Implemented Data Vault 2.0 patterns for Silver layer modeling
  • 04Created dimensional star schema for Gold layer analytics
  • 05Established Git-connected CI/CD workflow with automated PR reviews
( Next project )

GPT Extract