Snowflake Data Warehousing for Multi-Region BFSI Analytics

Authors

  • Niranjan Reddy Rachamala Independent Researcher, USA Author

DOI:

https://doi.org/10.32628/CSEIT25113393

Keywords:

Snowflake, Cloud Data Warehousing, Multi-Region Analytics, BFSI Sector, Data Scalability, Data Sharing, Regulatory Compliance, Cloud-Native Architecture, Financial Services Analytics, Data Governance

Abstract

The countless customer and transactional records are managed efficiently in the BFSI sector with the help of data warehousing. Since BFSI institutions are active in different regions, it is very important to have multi-region analytics that comply with rules. By using a cloud native system, Snowflake’s data warehouse splits storage from compute, offers flexibility, aids in securely sharing data, and follows key compliance rules. In this work, it analyze data collected from multiple sources to examine how Snowflake helps with distributed analytics in BFSI. The new findings show that Snowflake addresses key problems associated with old data warehousing systems by improving scalability, following regulations and making data available anywhere at any moment. The findings can be important for BFSI organizations working towards revamping their data analysis tools and making sure they follow regulations smoothly.

📊 Article Downloads

References

Ahuja, A., 2019. A Comprehensive Review of EMV Compliance in Cloud-Native Architectures: Challenges and Frameworks.

Alemu, M. and Omer, A., 2014. Cloud computing conceptual security framework for banking industry. Journal of Emerging Trends in Computing and Information Sciences, 5(12), pp.921-930.

Bagade, R.S., Pawar, R.G. and Dandnaik, A., 2022. Data Compliance Architecture for Managing Organizations Local and Global Data Using Data Virtualization. IITM Journal of Management and IT, 13(2), pp.19-25.

Chen, Y., Pan, A., Lei, H., Ye, A., Han, S., Tang, Y., Lu, W., Chai, Y., Zhang, F. and Du, X., 2024. TDSQL: Tencent Distributed Database System. Proceedings of the VLDB Endowment, 17(12), pp.3869-3882. DOI: https://doi.org/10.14778/3685800.3685812

da Silveira, D.M., 2022. Lean Data Engineering. Combining State of the Art Principles to Process Data Efficientlys (Master's thesis, Universidade NOVA de Lisboa (Portugal)).

Dageville, B., Cruanes, T., Zukowski, M., Antonov, V., Avanes, A., Bock, J., Claybaugh, J., Engovatov, D., Hentschel, M., Huang, J. and Lee, A.W., 2016, June. The snowflake elastic data warehouse. In Proceedings of the 2016 International Conference on Management of Data (pp. 215-226). DOI: https://doi.org/10.1145/2882903.2903741

Heinonen, J., 2020. From classical DW to cloud data warehouse. Obtenido de https://helda. helsinki. fi/bitstream/handle/10138/322467/JyrkiHeinonen_Masters_Thes is_V1. 0. pdf.

Hodgins, W., 2008. The snowflake effect: The future of mashups and learning. Retrieved January, 8, p.2009.

Jampani, S., Cheruku, S.R., Thakur, D., Prasad, M., Kaushik, S. and Goel, P., LEVERAGING AI IN SAP FOR REAL-TIME DATA PROCESSING.

Kovalenko, E., 2020. Advancements in Cloud-Based Infrastructure for Scalable Data Storage: Challenges and Future Directions in Distributed Systems. International Journal of AI, BigData, Computational and Management Studies, 1(1), pp.12-20. DOI: https://doi.org/10.63282/3050-9416.IJAIBDCMS-V1I1P102

Ly, D.H., 2019. Data analytics in cloud data warehousing, case company.

Rehman, K.U., Ahmad, U. and Mahmood, S., 2018. A comparative analysis of traditional and cloud data warehouse. VAWKUM Trans. Comput. Sci, 6, pp.34-40. DOI: https://doi.org/10.21015/vtcs.v15i1.487

Downloads

Published

25-02-2025

Issue

Section

Research Articles

How to Cite

[1]
Niranjan Reddy Rachamala, “Snowflake Data Warehousing for Multi-Region BFSI Analytics”, Int. J. Sci. Res. Comput. Sci. Eng. Inf. Technol, vol. 11, no. 1, pp. 3767–3771, Feb. 2025, doi: 10.32628/CSEIT25113393.