Can't find what you need?

Collaborative Development of a Data Warehouse

Collaborative Development of a Data Warehouse

Industry
Financial Services
Technologies
PostgreSQL, Java, Angular.js

Customer

The Customer is an international payment provider headquartered in the UK.

Challenge

The Customer was looking for a tech partner to implement a data warehouse for their core product, a global payment platform for businesses and individuals to streamline foreign bank-to-bank transfers. They needed a vendor with skilled software engineers to work together with their in-house data analyst in a Scrum-driven development environment. One of the major requirements for the vendor was the flexibility to scale up and down as the project demands.

Solution

The Customer chose to collaborate with ScienceSoft thanks to our 32-year experience in software development and data analytics. Based on the Customer’s requirements, we pre-selected several candidates for each of the 2 required positions – ETL/DWH developer and Java developer.

The selected developers embarked on the project immediately after the one-week visit to the Customer’s site for a knowledge transfer. ScienceSoft’s specialists integrated into the Customer’s development processes and covered their area of responsibility in Scrum sprints:

  • Setting up and maintaining the ETL process to integrate data into the data warehouse.
  • Developing Java-based scripts for data transformations and other ETL functions.
  • Carrying out operational tasks, such as data backups and system troubleshooting in production.
  • Deploying the data warehouse and code changes to UAT and Production environments.
  • Profiling and transforming data from the source systems with SQL.

The project was managed on the Customer’s side to give them the required control over the project planning and delivery. ScienceSoft’s developers maintained daily collaboration with the Customer’s in-house project manager and a data analyst via Skype. During the 8-month cooperation, ScienceSoft provided quick ramp-up up to 4 engineers and ramp-down back to 2 engineers to adjust to the changing scope of work, achieving both timely and cost-efficient completion of Scrum sprints.

Results

The Customer leveraged technical expertise of ScienceSoft, eliminating recruitment expenses at the same time. As a result of cooperation with ScienceSoft’s developers, the Customer had the data warehouse delivered in time and maintained continuously.

Technologies and Tools

PostgreSQL, Java, REST API, JavaScript, Play Framework, AngularJS, jQuery.

Need help with a similar project?

Drop us a line, and our rep will contact you within 30 minutes to arrange an initial discussion.

More Case Studies