Case Study – SynergyTop

Case Study

Pharmaceutical Industry

In this section, we will share with you a few real-world examples of the best-of-breed Pharmaceutical solutions
and capabilities that we provided to our global clients.


Our client is among the leading pharmaceutical company in the world. The company develops and produces medicines and vaccines for a wide range of medical disciplines, including immunology, oncology, cardiology, diabetes/endocrinology, and neurology.


The key challenge in this project was collecting the relevant data from disparate sources, such as Oracle and Legacy systems and loading them in Central Data Warehouse and building complex business logic for the pharma company.

The SynergyTop Solution

SynergyTop leveraged Informatica to extract the data from various incongruent database, such as Oracle, SQL Server and Flat Files and then stage it into a single database. Business Logic was applied and the data was then loaded in a centralized Data warehouse.

Highlights and Benefits

  • We used Informatica Power Center 9.5 for extraction, transformation and load (ETL) of data in the data warehouse.
  • SynergyTop extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy, XML Parser and Sequence generator and Stored Procedure for this project.
  • We collaborated with our client to formulate the most optimum ETL development strategy using Informatica for Stored Procedure orchestration.
  • We developed Informatica ETL objects to execute the Stored Procedures stored in Azure Database.
  • ETL mappings to extract data from the Oracle database/flat files and load it into the SQL Server database.
  • We implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
Request A Quote