Automated ETL Intelligence: Metadata-Orchestrated Framework with Rule-Based Heuristics for Monitoring and Reporting

In the era of large-scale data ecosystems, ensuring adaptability, transparency, and operational intelligence in ETL (Extract, Transform, Load) pipelines is paramount. This paper introduces a metadata-driven, SQL-native ETL orchestration framework designed to automate data integration tasks while embedding observability and anomaly detection capabilities directly