Automation of PL/SQL-based ETL Process Using Shell Script

Malarkodi M

Abstract: This paper presents an automated ETL (Extract, Transform, Load) framework using SQL, PL/SQL, and Bash scripting to process structured data files and insert them into an Oracle database. The system is enhanced with a critical notification mechanism via SMS alerts using public SMS APIs. The primary focus is on database automation, error logging, and alert integration, providing a lightweight yet scalable solution for ETL operations in academic and real-world settings.

Keywords: ETL, PL/SQL, Shell Script, Oracle, Alert Notification, Automation