Introduction to data warehousing, what is ETL, and overview of data cleansing, data scrubbing, data aggregation, learn what is Informatica PowerCenter ETL.
Overview of Informatica configuration, Integration Services, Installation of Informatica, operational administration activities.
Hands-on Exercise – Install PowerCenter
Learn what is active and passive transformation and the differences between the two.
Learning about expression transformation, connected passive transformation to calculate value on a single row.
Hands-on Exercise – Calculate value on a single row using connected passive transformation
The different types of transformations like Sorter, Sequence Generator and Filter, the characteristics of each and where they are used.
Hands-on Exercise – Transform data using Filter technique, Use a sequence generator, Use a Sorter
Joiner transformation to bring data from heterogeneous data sources.
Hands-on Exercise – Use Joiner transformation to bring data from heterogeneous data sources
Understanding the Ranking and Union transformation, the characteristics and deployment.
Hands-on Exercise – Perform Ranking and Union transformation
Learn about the rank and dense rank functions and the syntax for them.
Hands-on Exercise – Perform rank and dense rank functions
Understanding how router transformation works and its key features.
Hands-on Exercise – Perform router transformation
Lookup transformation Overview and different types of lookup transformation:Connected, unconnected, Dynamic and Static
Hands-on Exercise – Perform Lookup transformation: Connected, unconnected, Dynamic and Static
What is SCD?,processing in xml, learn how to handle flat file, list and define various transformations, implementing ‘for loop’ in power center, concepts of pushdown optimization and partitioning, what is constraint based loading?, what is incremental aggregation?
Hands-on Exercise – Load data from a flat file,Implement ‘for loop’ in power center, Use pushdown optimization and partitioning, Do constraint based data loading, Use incremental aggregation technique to aggregate data
Different types of designer: Mapplet, Worklet, target load plan, loading to multiple targets, linking property
Hands-on Exercise – Create a mapplet and a worklet, Plan a target load, Load multiple targets
Objectives of performance tuning, defining performance tuning, learning the sequence for tuning
Hands-on Exercise – Do performance tuning by following different techniques
Managing repository, repository manager – client tool, functionalities of previous versions, important tasks in repository manager
Hands-on Exercise – Manage tasks in repository manager
Understanding and adopting best practices for managing repository.
Common tasks in workflow manager, creating dependencies, scope of workflow monitor
Hands-on Exercise – Create workflow with dependencies of nodes
Define variable and parameter in Informatica, parameter files and their scope, parameter of mapping, worklet and session parameter, workflow and service variable, basic development errors
Hands-on Exercise – Define variables and parameter in functions, Use parameter of mapping, Use worklet and session parameter, Use workflow and service variable
session and workflow log, using debuggers, error handling framework in informatica, failover and high availability
Hands-on Exercise – Debug development errors, Read Workflow logs, Use Error handling framework
configurations and mechanisms in recovery, checking health of powercenter environment
Hands-on Exercise – Configure recovery options, Check health of Powercenter environment
infacmd, pmrep, infasetup, processing of flat file
Hands-on Exercise – Use commands infacmd, pmrep, infasetup
Fixed length and delimited, expression transformations- sequence numbers, dynamic targeting using transaction control.
Hands-on Exercise – Perform expression transformations- sequence numbers, dynamic targeting using transaction control.
Dynamic target with use of transaction control, indirect loading.
Hands-on Exercise – Use of transaction control with dynamic target, indirect loading.
Importance of Java transformations to extend Power Center capabilities, transforming data, active and passive mode.
Hands-on Exercise – Use Java transformations to extend Power Center capabilities
Understanding unconnected stored procedure in Informatica, the different scenarios of unconnected stored procedure usage.
Hands-on Exercise – Use unconnected stored procedure in Informatica in different scenarios
Use of SQL transformation (active and passive)
Hands-on Exercise – Use of SQL transformation (active and passive)
Understanding Incremental Loading and aggregation and comparison between them .
Hands-on Exercise – Do Incremental Loading and aggregation
Working with database constraints using PowerCenter, understanding constraint based loading and target load order.
Hands-on Exercise – Perform constraint based loading in a given order
The various types of XML transformation in Informatica, configuring a lookup as active.
Hands-on Exercise – Perform XML transformation, Configure a lookup as active
Understanding what is data profiling in Informatica, its significance in validating content, ensuring quality and structure of data as per business requirements.
Hands-on Exercise – Create data profiling in Informatica and validate the content
Understanding workflow as a group of instruction/command for integration services, learning how to create and delete workflow in Informatica.
Hands-on Exercise – Create and delete workflow in Informatica
Understanding the Database Connection, creating a new database connection in Informatica, the various steps involved.
Hands-on Exercise – Create a new database connection in Informatica
Working with relational database tables in Informatica, mapping for loading data from flat files to relational database files.
Hands-on Exercise – Create mapping for loading data from flat files to relational database files
Understanding how to deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter.
Hands-on Exercise – Deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter.
Connecting Informatica PowerCenter with various data sources like Social media channels like Facebook, Twitter, etc.
Hands-on Exercise – Connect Informatica PowerCenter with various data sources like Social media channels like Facebook, Twitter, etc.
Push down optimization for load-balancing on the server for better performance, the various types of partitioning for optimizing performance.
Hands-on Exercise – Optimize using Push down technique for load-balancing on the server for better performance, Create various types of partitioning for optimizing performance
Understanding session cache, importance of cache creation with, implementing session cache, calculating cache requirement
Hands-on Exercise – Implement cache creation with, Work with session cache
Project 1 : General Manager Insight – Dash Board
Client : Cisco
Technology : Teradata, Informatica, SQL
Cisco is the worldwide leader in networking that transforms how people connect, communicate and collaborate. Current portfolio of products and services is focused upon three market segments—Enterprise and Service Provider, Small Business and the Home. The solutions for each market are segmented into Architectures, which form the basis for how Cisco approaches each market
Description : GMI dashboard is graphical representation performance of various Cisco Business segments. Dashboard provides pictorial representation of Summery and detailed data about various Subjects Areas in different dimensions such as Entity level, Product level and Region level. Dashboard covers various measures of the business such as Bookings, Revenue and Gross Margin; Product forecast which are used by managers at different hierarchies of the Cisco management.
Project 2 : Customer & Relationship Application
Client : Bank of America
Environment : Informatica
About client (Bank of America) : Bank of America is a leading Bank in the United States of America, with its world headquarters located at Charlotte, North Carolina, USA. Bank of America provides financial products, services, ideas and solutions to customers across the United Stated and many countries around the globe. Now Bank is positioned as 2nd largest bank in the world and is a front runner with its acquisitions of LaSalle, Countrywide and Merrill lynch.
Description : Customer and relationship application is warehouse for Bank of America customer application systems. Data in C & RA will be used for business analysis and proposing new business to the customer and also to households the customers.
Current project “Mass Affluent” is a new initiative by Bank Of America to identify high net worth customers, the information which is used by the downstream applications and marketing channels in order to cater new products and business to the customers to improve the business.
Project 3 : CRDW
Client : WellPoint
Environment : Informatica
Description : CRDW (Central Region Data Warehouse) have two types of sources of data. These are either the legacy data warehouses such as FAMIS, ACDB and CMIS or the operational source systems such as MPRO, PHI Drug, FACETS and NASCO. The CRDW is sub-divided into different subject areas. These subject areas are primarily business aligned and each subject area is in turn populated from multiple sources. Data from these subject areas inside the CRDW is then loaded into multiple data marts and data extracts that is in turn accessed by the end users in the form of reports and queries. There are a wide variety of front-end tools that end-users use to access the data and these are based on Oracle, MS Access, Stars (a propriety system), Business Objects, SQL, SAS and Query man.
Project 4 : Creating a sales data mart
Problem Statement : An FMCG company wants to have a consolidated data mart for its sales data which can be readily accessible
Industry : FMCG
Description : This project involves working with the FMCG sales data warehouse accumulated over multiple years and created a data mart that is easily accessible to various teams. You will learn the process of data cleansing, scrubbing, aggregation, transformation, etc. You will deploy repository manager for managing various users and groups.
Project 5 : Customer social media data integration
Industry : General
Problem Statement : An enterprise wants to know what its customers are saying about its product by monitoring the social media channels.
Description : In this project you will learn to deploy the powerful data integration tool Informatica PowerCenter for social media posts. You will learn how to do data synchronization through cloud, track social media accounts based on keywords, subject, author and other parameters.
Intellipaat is the pioneer of online training in Business Intelligence in India. Informatica is clearly a market leader in the fields of data integration and data quality services. The Informatica PowerCenter is a powerful tool to integrate, manage and migrate enterprise data.
This training course is completely in line with clearing the PowerCenter Developer Certification, and PowerCenter Administrator Certification. We provide a hands-on, fast-paced training with real world projects and assignments that are designed keeping in mind the industry needs.
Upon completion of the Informatica training course you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 Support, and course material upgrading to latest version at no extra fees. Hence it is clearly a one-time investment.
This training course is designed for clearing the following Exams.
The entire training course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in the top MNCs.
As part of this training you will be working on real time projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.
At the end of this training program there will be a quiz that perfectly reflects the type of questions asked in the certification exams and helps you score better marks in certification exam.
Intellipaat Course Completion Certificate will be awarded on the completion of Project work (on expert review) and upon scoring of at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
This course is designed for clearing “Informatica Professional Certification Exam” conducted by Informatica. At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.Intellipaat enjoys strong relationships with multiple staffing companies in US, UK and have +80 clients across the globe. If you are looking out for exploring job opportunities, you can pass your resumes once you complete the course and we will help you with job assistance. We don’t charge any extra fees for passing the resume to our partners and clients.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org