Towards the end of Edureka Informatica Certification Training, you will be working on a live project using Informatica
Project #1: Build Decision Support System for A Bank
Problem statement: A Bank's management committee wants to understand their business needs, customer’s requirement in detail and more accurate manner. They want to build up one Decision support system in which they want some banking report on daily, weekly, monthly basis. The vendor needs to use their database to give an automatic reporting application for present and future requirements. Using Informatica PowerCenter you have to fulfill all the requirements.
Project #2: Create an ETL Process to Load Data for Target Mega Mart
Problem statement: Target Mega Mart is planning to build a data warehouse of sales, to enhance their decision support. The business requires a centralized data access for generating various reports to forecast and value their product sales across the branches. Your company has won the proposal for the creating ETL Processes to load data into their data warehouse on a daily, monthly, yearly and on-demand basis.
Project #3: Create an ETL Process for Bank's Analytics System
Problem statement: A bank wants to market the new set of credit cards and related products. The customers of the bank, seeking one of these products would be able to submit their application through a website. If the applicant fulfills the eligibility criteria, he/she will be offered the product. You have been given the job to create a set of consolidated files from the source data. Using Informatica PowerCenter, create a set of ETL processes as per the rules.
Final Project: Retrieve and Synchronize Data From FTP
Problem statement: Gander Mountain operates the largest retail network of electronic products and accessory stores across the world. Multiple brand acquisitions in the long term have led to information challenges (functional silos, data redundancy, multiple data marts, multiple reporting tools, no common “enterprise” data model, integration and delivery issues, data quality issues, and coordination issues with multiple teams). A study was carried out with input from various stakeholders and the key outcome of this study was to consolidate all the data marts into one single Integrated Data Warehouse (IDW). You must use the Informatica PowerCenter for the implementation of the ETL processes in the project.