Strategic Optimization of ETL Architectures for Financial Data Warehouse Systems: A Multi-Objective Analysis
Journal of Data Science and Information Technology · 2026 · 3 (1) · 1-8
DOI: 10.55124/jdit.v3i1.276 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Data Science and Information Technology, 2026. Verfasst von Rakesh Mittapally.
Abstract (Originalsprache)
In the ever-changing landscape of financial technology, organizations struggle with the dual imperative of handling massive data volumes while adhering to strict regulatory frameworks and maintaining market dominance. This study refines the extraction, transformation, loading (ETL) algorithms designed for financial data warehousing in the fintech industry. As financial transactions grow in complexity, the ability to seamlessly integrate, process, and analyze data from disparate sources emerges as a key factor in organizational performance. This research has particular relevance in mitigating systemic inefficiencies that often plague large-scale financial data warehouses, such as computational lags, resource allocation challenges, and scalability barriers. By evaluating state of-the-art ETL methods, this study provides financial institutions with empirically based strategies for improving data processing efficiency, while preserving data integrity and complying with evolving regulatory mandates. Using a systematic approach, this research uses the MOORA (Multi-Objective Optimization Based on Ratio Analysis) technique to rigorously evaluate six stateof-the-art ETL frameworks: PySpark-Optimized ETL Framework, AWS Glue-Pipelineed S Dabrita-Bas Redshift, Athena-Driven Server less Analytics, Data Lakehouse with Delta Lake, and Hadoop-based Batch Processing. The evaluation is structured around seven Key Metrics: processing speed, data integrity, query efficiency, cost-effectiveness, execution time, data propagation latency, and computational resource consumption. The comparative investigation identifies the AWS Glue-based data pipeline as the most effective framework, securing the highest evaluation score (0.07604) over the PySpark-Optimized ETL Framework (0.07496) and Athena-Driven Server less Analytics (0.077). The results underscore AWS Glue’s exceptional ability to preserve data consistency while simultaneously improving query execution and overall processing efficiency. This study highlights how cloud-based ETL solutions are revolutionizing financial data processing by delivering better scalability and cost-effectiveness. Furthermore, embedding artificial intelligence within ETL workflows strengthens data integrity through intelligent anomaly detection and dynamic transformation algorithms. Beyond technological advancements, research underscores the need for financial institutions to rigorously implement data governance to mitigate the persistent issues of redundancy and inconsistency. By providing a well defined framework, these findings equip financial institutions with the tools to evaluate and deploy ETL systems according to their operational landscapes, ultimately refining analytical accuracy and securing a strategic edge in an industry where data is at its peak. Keywords: MOORA method, multi-objective optimization, AWS Glue, PySpark, Data consistency, Query performance, Cloud- based ETL, Big Data processing and Artificial intelligence in ETL.
Zitieren
APA
Mittapally, R. (2026). Strategic Optimization of ETL Architectures for Financial Data Warehouse Systems: A Multi-Objective Analysis. Journal of Data Science and Information Technology, 3(1), 1-8. https://doi.org/10.55124/jdit.v3i1.276
Vancouver
Mittapally R. Strategic Optimization of ETL Architectures for Financial Data Warehouse Systems: A Multi-Objective Analysis. Journal of Data Science and Information Technology. 2026;3(1):1-8. doi:10.55124/jdit.v3i1.276
BibTeX
@article{Mittapally2026,
author = {Mittapally, Rakesh},
title = {Strategic Optimization of ETL Architectures for Financial Data Warehouse Systems: A Multi-Objective Analysis},
journal = {Journal of Data Science and Information Technology},
year = {2026},
volume = {3},
number = {1},
pages = {1--8},
doi = {10.55124/jdit.v3i1.276}
}
EUVIMED