Course content

Informatica is one of the widely used ETL Tool for extracting the source data and loading it into the target after applying the required transformation. It provides a single enterprise data integration platform to help organization access, transform, and integrate data from a large variety of systems and deliver information to other transactional systems. Informatica is riding the wave of Data Integration currently in vogue to present its Certifications in Data Integration tools, with PowerCenter leading the pack. Special applications in ERP, manufacturing and HR alike have led to generation of data streams which need consolidation. This rising need in Data Integration and Data Warehousing is addressed by Informatica PowerCenter. PowerCenter offers continuous data processing with a zero-latency engine enabling business users to make timely decisions. It supports customer’s plans like data warehousing project, integrating or migrating applications, or evolving to a hybrid architecture and keeps their business agile.

Did you know?

  1. Informatica has released Informatica cloud in 2016, to assist businesses in harnessing the exploding volume of data in their cloud applications and unifying data across traditional and hybrid data sources. Informatica cloud is mainly focused on delivering end-to-end cloud data integration and data management
  2. Informatica being a 23-year-old company provides cloud based data management tools to their customers like General Electric GE and Amazon. It has a 22 percent share of the market for “integrated platform-as-a-service,” a cloud computing model that assists customers in developing applications and managing data over the internet
  3. The key features of Informatica PowerCenter deals with partitioned data, caching techniques, parallel processing and quality bulk extraction or loading without any data loss. These key features has led Informatica PowerCentre as a market leader in data integration
  4. Informatica follows mainstream marketing strategy where it leverages paperwork, press release, web forums and network community. This provides Informatica the leading edge in ETL space

Why learn and get Certified in Informatica PowerCenter (Developer)?

  1. Based on 2015 market share revenue, gartner’s report announced Informatica as the #1 global Integration Platform as a Service (iPaaS) solution vendor for the 11th consecutive year. Its wide market share has raised ample of job opportunities for skilled professionals
  2. In 2015, Informatica has generated over $1 billion in revenue. Now, it has plans to invest in startups, beef up its hiring capacity, and invest further in research and development to boost growth
  3. It reports record of Quarterly Revenues of $303.7 Million and Annual Revenues of $1.05 Billion. Thus these revenue outcomes indicates the huge demand of Informatica Power Centre in the IT market
  4. As per the latest job trends, the market of Informatica PowerCenter is highly profitable. It is an enduring technology and will be continuing progress with an exponential rate in the future as well

Course Objective

After the completion of this course, Trainee will:

  1. Knowledge on Usage of PowerCenter 10 Designer to develop mappings that extract data from a source to a target, transforming it as per requirement
  2. Ability to deploy PowerCenter transformations to format, cleanse, join, segregate and route data to appropriate targets
  3. Potentiality to perform error handling or trapping by implementing PowerCenter mappings
  4. Capability to develop and execute workflows which execute sessions paired with a mapping and to control data transformation processes by implementing PowerCenter, 10 workflow manager
  5. Ability to plan and build basic mappings and workflows based on essential business needs
  6. Complete knowledge on basic troubleshooting with help of PowerCenter debugger and logs

Informatica Supports the activity Process of the Business Integration Competency Center (ICC) and other integration experts by Serving as the foundation for data warehousing, data consolidation, migration, “single-view,” metadata management and synchronization. The Course we provide will give you Advance skills and Advance development knowledge to developers. In addition students shall be exposed to “Performance Oriented tuning techniques”, and some special features of the Tool.

Pre-requisites

  1. Basic knowledge of PL/SQL and basic Unix development.
  2. Students must be familiar with Concepts in Oracle database and its functionality.
  3. Good knowledge of ETL, and Data Warehousing Concepts.

Who should attend this Training?

This comprehensive course is ideal and best suited for the following professionals, who are interested in mastering skills and upgrading their knowledge:

  1. Individual Contributors in the field of Enterprise Business Intelligence
  2. Analytics Professionals
  3. DW/BI/ETL/ Professionals
  4. Software Developers
  5. Mainframe Architects and developers
INTRODUCTION TO DATAWAREHOUSING
  • Data Warehousing Concepts
  • Dataware housing (what/Why/How)
  • Data Modelling(Schemas, FACTS and DIMENSIONS)
  • Slowly Changing Dimensions
  • Metadata
PowerCenter Components and User Interface
  • PowerCenter Architecture
  • PowerCenter Client Tools
  • Lab – Using the Designer and Workflow Manager
Introduction to Informatica Power Center Designer
  • Source Analyzer
  • Target Designer
  • Mapping Designer
Informatica Power Center Workflow Designer
  • Workflow Designer
  • Task developer
  • Work let Designer
Informatica Power Center Workflow Monitor
  • Job status
  • Job session logs
Loading Strategy
  • Flat file to flat file load
  • Flat file to database load
  • Database to database load
  • Database to flat file load
  • Xml file to database load
  • Xml file to flat file load
Different Transformations
  • Source Qualifier
  • Source Qualifier Join
  • Source Qualifier Filter
  • Expression
  • Connected Stored Procedure
  • Unconnected Stored Procedure
  • Sequence Generator
  • Aggregator
  • Filter
  • Lookup
  • Joiner
  • Router
  • Rank
  • Sorter
  • Union Transformation
  • Xml Source Qualifier
  • Using Flat Files as Sources
  • Using Flat Files as Source and Target
  • Using XML Files as Source
  • Reading Data From Multiple Data Bases
  • Target Load Plan
Informatica Administration
  • Installation of Informatica
  • Installation of Oracle Database
  • Installation of SQL Server
  • Creation Repository
  • Creation of Users
  • Assigning Privileges to users
  • Creation of Groups
  • Adding the Repository to Informatica Repository Manager
  • Creating Data source Connections
  • Configuration of Sql server and Oracle Database with Informatica
  • Scheduling the Workflow
Source Qualifier
  • Source Qualifier Transformation
  • Source Pipelines
  • Source Qualifier  Filter and Real time issues
  • Source Qualifier SQL over query
Expression, Filter, File Lists and Workflow Scheduler
  • Expression Editor
  • Filter Transformation
  • File Lists
  • Workflow Scheduler
  • Lab – Load the Customer Staging Table and Real time issues
Joins, Features and Techniques
  • Joiner Transformation
  • Shortcuts
  • Lab – Features and Techniques I and Real time issues
Lookups and Reusable Transformations
  • Lookup Transformation
  • Reusable Transformations
  • Lab A – Load Employee Staging Table
  • Lab B – Load Date Staging Table and Real time issues
Debugger
  • Debugging Mappings
  • Lab – Using the Debugger
Sequence Generator
  • Sequence Generator Transformation
  • Lab – Load Date Dimension Table and Real time issues
Router, update Strategy and Overrides
  • Router Transformation
  • Update Strategy Transformation
  • Expression Def ault Values
  • Source Qualifier Override
  • Target Override
  • Session Task Mapping Overrides
  • Lab – Load Employee Dimension Table and Real time issues
Dynamic Lookup and Error Logging
  • Dynamic Lookup
  • Error Logging
  • Lab – Load Customer Dimension Table
Unconnected Lookup, Parameters and Variables
  • Unconnected Lookup Transformation
  • System Variables
  • Mapping Parameters and Variables
  • Lab – Load Sales Fact Table
Sorter, Aggregator and Self-Join
  • Sorter Transformation
  • Aggregator Transformation
  • Active and Passive Transformations
  • Data Concatenation
  • Self -Join
  • Lab – Reload the Employee Staging Table and Real time issues
SCD type1 SCD type2 SCD type3   Mapplets
  • Mapplets
  • Review and more Activities and Real time issues
  Workflow Variables and Tasks
  • Link Conditions
  • Workflow Variables
  • Assignment Task
  • Decision Task
  • Email Task
More Tasks and Reusability
  • Event Raise Task
  • Event Wait Task
  • Command Task
  • Reusable Tasks
  • Reusable Session Task
  • Reusable Session Configuration
Worklets and More Tasks
  • Worklets
  • Timer Task
  • Control Task
  • Lab – Load Inventory Fact Table
key service
  • FAQS
  • Covering DBA concepts
  • Concentration on performance tuning
  • Real time scenarios
  • Certification guidance
  • Resume preparation
  • Sample resumes
  • Interview & certification FAQS
  • How to face the interview
  • Class notes which is useful for who is trying for job

Mode of Training

Online

Total duration of the course

5 to 7 weeks

Training duration per day

50 mins - 90 mins

Communication Mode

Go to meeting, WEB-EX

Software access:

Software will be installed/Server access will be provided, whichever is possible

Material

Soft copy of the material will be provided during the training.

Training

Both weekdays and weekends

Training Fee

 $400