SUBMIT YOUR RESEARCH
Saudi Journal of Engineering and Technology (SJEAT)
Volume-11 | Issue-02 | 96-104
Review Article
Engineering Resilient ETL: PowerCenter Performance Limits and Cloud Migration Pathways
Venkat Sunil Kumar Indurthy
Published : Feb. 6, 2026
DOI : https://doi.org/10.36348/sjet.2026.v11i02.004
Abstract
The goal of this project is to modernize BP's OPSD2 Downstream Logistics ETL Solution by moving away from Mainframe DB2 database systems and using Oracle-based DBs and incorporating multiple source data sources through Informatica Mappings using an Agile Governance framework for ETL solutions. This study uses InformaticaPowerCenter's Repository-Integration service architecture to analyze the performance characteristics of InformaticaPowerCenter and find that Read Operations can scale efficiently under high levels of concurrency while Write Operations experience rapid degradations in performance due to the use of exclusive locks on certain tables. Therefore, there is a risk of failure if high-volume deployments are attempted using a Write Operation approach. Performance analysis performed using multiple tools have identified that the write latency is the primary cause of the performance constraint. To alleviate this issue, it is recommended that cache tuning, repository clustering and asynchronous bulk logging be used to meet the operational demands of fuel distribution. Looking forward, OPSD2 intends to evolve into BP's Real-time Net-Zero Analytics Platform by leveraging cloud-native solutions based on Informatica IDMC and Advanced Streaming capabilities.
Scholars Middle East Publishers
Browse Journals
Payments
Publication Ethics
SUBMIT ARTICLE
Browse Journals
Payments
Publication Ethics
SUBMIT ARTICLE
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
© Copyright Scholars Middle East Publisher. All Rights Reserved.