A common challenge in financial industry systems is to replicate large data sets between databases, while applying common business rules, and preventing issues of data inconsistency or data locking in operational data stores.

With performance issues in Informatica (and license costs that were not providing a ROI), we chose to implement custom database tools that could be optimised for the clients situation. While it is clearly preferable to use a standard ETL tool in most situations, it is useful to have the option of implementing a customised solution when the demands and efficacy of the problem demand it.