Data Warehousing

Successful data warehouse solutions  using a Modular DWH Architecture, following a standard ETL Framework implemented by highly skilled people that apply a common way of working. Our intention is to build fit for purpose DWH solutions, nothing more, nothing less. We don’t believe in one size fits all!

Approach

i4Bi implements successful data warehouse solutions at customers, through:

  • The usage of a standard Information Management Reference Architecture to provide insight in the as-is and to-be data warehouse reference architecture through a modular approach.
  • The usage of a standard ETL Framework to guarantee a harmonized way of working for back-end developments (ETL).
  • Highly skilled people that apply a common way of working and know the concepts of data warehousing.
  • The application of a standard in-house developed project management methodology enabling faster delivery of DWH developments.
  • Project deliveries led by project managers with data warehouse affinity and knowledge

Technologies

ETL / Data Factory

On Platforms

Oracle
  • Oracle Data Integrator (ODI)
  • Oracle Warehouse Builder (OWB)
  • Oracle GoldenGate
  • ODI Big Data Option
  • Oracle Big Data SQL
Oracle
  • RDBMS
  • Oracle Exadata / Exalytics
  • Oracle Big Data Appliance
Informatica
  • Informatica PowerCenter
  • Informatica Metadata Manager
  • Informatica Big Data Edition
  • Informatica Cloud
Teradata
  • RDBMS
  • Data Warehouse Appliance
Big Data SQL
  • Hive
  • Sqoop
  • Impala
  • Spark SQL
Cloudera
Hadoop
  • HDFS
  • NoSQL DBMS

Profiles

The i4Bi data warehousing group delivers highly skilled people that have a no-nonsense but professional attitude that apply a common way of working and know the concepts of data warehousing. We have trained and certified people that have the following skills:

  • DWH & ETL designers
  • DWH & ETL developers
  • DWH Architects
  • Data Modelers (Data Vault, 3NF, Dimensional, …)
  • Functional & technical analysts
  • Project Managers with experience in BI/DWH environments

Offering

Modular DWH Architecture

The i4Bi DWH group builds fit for purpose DWH solutions, nothing more, nothing less. We don’t believe in one size fits all. Through a standardized intake process our DWH architects consult, and define together with you the best solution in your current context. There are different options which are extendable in a modular way:

Modular DWH Architecture

Our modular DWH architecture is based on the Oracle’s Information Management Reference Architecture

ETL Framework

All our DWH ETL designers and developers follow and apply a standard ETL Framework to deliver high quality ETL solutions. Predefined standards and guidelines that are technology agnostic are used to create technology dependent assets that facilitate and speed up your DWH build up:

ETL Framework

These assets are based on standard reusable solutions provided by the ETL technologies that we are focused on, such as Oracle Data Integrator Knowledge Modules and Informatica Powercenter Mapping Templates.

Big Data integrated into your DWH

We see a lot of customers struggling with one question: “How can we integrate a big data platform into our existing DWH architecture?”
The i4Bi DWH architects help you providing an answer by:

  • Using a standard Information Management reference architecture with an answer to Big Data in the DWH
  • Sharing their deep DWH knowledge
  • Leveraging the knowledge existing within the Cronos Group around Big Data platforms (often not having these deep DWH skills)

This results in Big Data solutions that are perfectly integrated into your today’s DWH architecture!

Moreover we provide DWH ETL designers and developers that have:

  • Knowledge on Big Data technologies from a data integration perspective
  • Knowledge on Hadoop, Cloudera, …
  • Knowledge with ODI / Informatica PowerCenter on Big Data Platforms (connectors)
  • Knowledge on BI/DWH concepts

Big Data Architecture