For one of our clients, a leading insurance company, we support the early detection of data processing and integration issues by testing backend systems before the user interface is completed, helping reduce development risks.
Sector
Service & Technology
The Challenge
Our client operates in a complex insurance IT environment where new digital features affect multiple interconnected applications and backend systems. For example, the correct functioning of a new data field introduced in a partner portal depends not only on the user interface but also on the systems responsible for processing, storing and transferring data.
During development, backend functionality may already be available while the frontend is still under construction. The challenge is to verify the entire data processing flow without a user interface, preventing late defect detection and reducing the risks associated with a shortened testing period.
The Solution
We begin backend testing independently of the completion of the frontend by manually preparing XML test data. These data packages are submitted directly to the receiving system, and the processing results are verified at multiple checkpoints.
Using SQL queries, we check the records created in DB2 databases and validate the values of newly introduced fields. Where relevant, we also verify how the data appears in the IBM AS/400 core system and whether it is correctly synchronized with the Oracle-based data warehouse.
Throughout testing, we combine technical validation with an understanding of the underlying business processes. Working closely with developers and system analysts, we identify the affected systems, data connections and potential sources of errors. This allows backend testing to proceed in parallel with frontend development.
Technology
IBM AS/400, DB2, Oracle, SQL, XML
The Result
By introducing backend and integration testing at an early stage:
- Data processing and integration defects can be identified before the frontend is completed.
- Defects can be located more precisely across individual stages of data ingestion, storage and transfer between systems.
- Backend testing and frontend development can proceed in parallel.
- The pressure on later testing phases caused by development delays can be reduced.
- Project management can gain earlier visibility into outstanding technical risks, supporting more informed go-live decisions.


