BlazeClan helped the customer with creating ETL steps for Redshift and testing the performance.

Business Description

The company is a leading mobile marketing platform augmenting each mobile internet user’s profile; creating user persona’s and identifying intent signals. With this data, they help in delivering relevant offerings to every mobile internet user; enabling marketers, app developers, telecom operators and data providers to derive sharper results.

Business Requirements & Key Challenges

This company was using HP Vertica Data Warehouse solutions for their requirements. They were facing performance issues in analyzing the data.

The Customer wanted BlazeClan to:

  • Identify the Data from the current environment to be loaded
  • Load large production data set to Redshift
  • Optimize the query performance
  • Test Redshift Performance with HP Vertica Performance

Business Solution

The Data Warehouse Solution will be shifted to Amazon Redshift. With this-

  • The performance of redshift was checked using reporting tools like Jaspersoft/Tableau.
  • Optimizing the performance of any three reports including RIMS and CAD and dynamic report. Ad-hoc reporting and historical reporting.
  • Historical Data Population

Benefits

BlazeClan helped the corporation with the following features:

  • Design for Warehouse and Development
  • Design for Application and Development
  • ETL process Design and Development
  • Data Validation and Testing

BlazeClan’s solution offered high-performance processing of data to derive intelligence from the interactions and transform it into actionable smart data.

Technology Overview

  • Amazon Redshift
  • ETL
  • JasperSoft
  • Tableau