Payment Services – Data Factory for Payment Flows

Within the client’s Data Factory and its payment flows team, T&S supports the monitoring of payment transactions and routing activities for a major financial institution serving other financial organisations.

Client context

The mission includes exposing business data, deploying new payment methods, and enabling inter-entity billing processes across the group.

Business challenges

• Address business needs by exposing payment flow data
• Provide greater visibility on strategies for marketing and agency teams
• Deploy new payment methods
• Enable billing of services between Natixis and its subsidiaries
• Migrate legacy tables and cubes from Oracle to a cloud infrastructure

The T&S solution

T&S delivered an 'as-is' analysis and specification of dashboard evolutions, handled new business requests, created new dashboards, and migrated tables and cubes from Oracle to Google Cloud Platform. The team also managed Run activities: maintenance and bug resolution, ad-hoc and recurring data extractions, and post-production monitoring. Functional scope covered SEPA flows, instant payments, flow acquisition, remitter management, SWIFT and international flows, treasury management and T2/T2S.

Technologies & expertise

• SQL
• Oracle
• Google Cloud Platform (GCP)
• Azure
• Power BI
• JIRA
• Confluence

Results & business value

Modernised, cloud-based Data Factory with new dashboards and a broadened data scope, supporting the payment department's strategy across subsidiaries and clients, plus stable Run operations and post-production monitoring.

Conclusion

The engagement highlights T&S's combined data-engineering and cloud-migration expertise in a complex, high-volume payments environment.