Custom ETL Connector for Oracle ERP to Enable Reliable Data Flow

The client is a US-based insurance provider with over 5,000 employees and offices around the world. Founded about a quarter of a century ago, the insurance giant has grown a massive client base and accumulated vast amounts of data.

This strategically valuable data, however, was locked in the client’s Oracle ERP system. The existing setup allowed only for very limited customization and required very labor-intensive data processing workflows. And even so, many attributes and metrics important for further decision-making and refining the value chain remained unavailable.

To capitalize on this data treasure trove and open the door to new insights, the client needed to set up an effective and highly-performant pipeline to extract comprehensive ERP data, clean it and load it into the Financial Analytics Data Warehouse for further analysis. The data-heavy project called for mature ETL development expertise, one of Symfa’s core competence.

With data being at the core of the modern insurance business, ETL projects recently rose to prominence in the client’s company, being the cornerstone of data-driven culture. Now, this robust and reliable ETL pipeline successfully fuels the client’s far-reaching analytical plans. With the ability to transform diverse financial data into analytics-ready data that can be acted upon, the client can inform its strategic planning and open up new revenue streams.

From the perspective of collaboration with the client’s specialists responsible for further analysis, our engineers have become an integral part of the distributed team, enabling an organic data flow and providing each other with extra support whenever it is needed. 

• All the workflows and communication patterns on the project were established according to the client’s requirements.
• All the engineers are actively involved in the project discussions during daily catch ups in Microsoft Teams.
• 24/7 access to Jira and progress reports (daily/weekly/monthly) add to the project transparency, which is a must for a business operating in a strictly regulated environment, like the one of our client’s.