Source-to-target data mapping and SQL integrity checks for an HR-to-payroll migration (synthetic data)
-
Updated
Oct 21, 2026 - Python
Source-to-target data mapping and SQL integrity checks for an HR-to-payroll migration (synthetic data)
Full production-grade, Python-based ETL workflow built for Sutter Health’s ABSMC campuses. Automates bidirectional data migration across MS Access, SQL Server, Excel, and Revit BIM using mainly pyodbc, SQLAlchemy, Pandas, Prefect, BIMLink, and pyRevit. Enables seamless facility operations, real-time BIM sync, and audit-ready reporting.
To associate your repository with the datamapping topic, visit your repo's landing page and select "manage topics."