Client Overview
Our client is a global infrastructure and design business that provides government and private customers with solutions for water, electricity, transportation, and utilities programs.
Challenge
Objective of this program is to develop a single source of truth, reusable repository of data elements, metrics, KPIs by building a modern data warehouse system. Data Governance is more challenging and the business is currently unable to achieve a portfolio view of data across multiple systems The expectation is to collect data from diverse sources, which includes Oracle EBS R12 (Core ERP), Ecosys (PM System), Salesforce, Mosaic, Primavera P6 and Concur, and combine it in an centralized enterprise data warehouse.
Solution
After reviewing the requirements, performing a discovery phase, AAITCS partnering with the client implemented a cloud enterprise data warehouse (DWH), Oracle Antiunity for replication, utilizing Talend for Data Integration, AWS Redshift for database, Qlik View for BI analytical reporting.
DWH Facts
- 6 Data Marts
- Total Number of source systems – 4
- Total Number of ETLs – 80
- Schedule Frequency – Hourly, Daily, Weekly
- Total tables – 620, Views 54
- Total BI Analytics Reports – 35
- Power Users – 21, External users 4000+
Business Highlights
AAITCS Pvt Ltd has done the end-to-end implementation of this data warehouse project. Starting from consolidating various source systems, analysis of numerous data elements in the systems, setting up the replication from source systems, integrating with the 3rd party api to extract the data, coming up with data quality rules and profiling the data, integrating data into the data warehouse using Talend Tool with best industry coding standards, developing robust batch and real-time processes to ensure dependencies and timely refresh of data in the warehouse.
We performed quality assurance of the ETL process pipelines, data warehouse (Dimensions and Facts) at row level using ETL mapping documents, functional level and regression testing by building extensive SQL queries. We also did regression and functional testing of Qlik BI reports by comparing the data with source systems, DWH and Stage.
AAITCS Pvt. Ltd delivered the project on schedule within budget as we had an excellent project team comprising of scrum master, data architects, Talend developers, Quality Assurance experts.
About Us
AAITCS Private Limited is an innovative information technology services firm offering world class software solutions. We are client-centric and relationship-based company with a focus to provide a cost-effective software development and support solutions. We focus on quality and delivering business value.
Incorporated in the year 2018, AAITCS Pvt Ltd, has been actively helping global cooperation to innovate and transform their businesses utilizing IT. Our global delivery and engagement models help us to office affordable long-term software solutions that meet out clients IT challenges and add business value. We combine our capabilities to invent, develop, and deliver innovations for clients to transform legacy models to take their business to the next level and create the future.
AAITCS has a team of expert Data architects and engineers to help you build a robust, secure and scalable architecture for your data warehouse. We are highly experienced in constructing unique architecture and conceptual data model for a variety of domains and segments. We work with cutting edge technology into Data Warehouse Migration, Data Modernization and Data Analytics also application development and empower businesses through automation to help clients attain excellence.