Informatica Training

Icronix  Informatica Training provides a strong foundation on all the core concepts of Informatica Powercenter to create, execute, administer, and schedule ETL processes and understand how these are used in data warehouse and data mining operations.

informatica online training

KEY FEATURES

60 Hrs Instructor Led Training

30 + Corporates Served

5000 + Professionals Trained

Pay in 2 Installments

Certification and Job Assistance

Flexible Schedule

INFORMATICA COURSE OVERVIEW

Icronix Informatica Training will help you to master all the core concepts such as ETL, Data Mining using Informatica power centre. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter. Throughout our Informatica Training Course, you will be working on real-life industry-based use cases. By the end of the training, you’ll equip all the skills required to clear the Informatica Certification Exam

Informatica is the market leader in the ETL segment. It can work on a wide variety of data sets, varying standards and multiple applications and systems. Thus, it is rapidly being adopted by organizations around the world providing huge job opportunities for professionals with the right skills. Icronix Informatica online classes will prepare you for clearing the Informatica certification exam

Business Intelligence, SQL and Database Professionals, Project Managers and graduates looking to make a career in BI

INFORMATICA COURSE CONTENT

  • Understanding the concepts of data warehousing
  • Ability to design and develop complex mappings
  • Configuring workflows as in real time environment
  • Troubleshooting errors/failures
  • Gain hands-on experience with multiple exercise and  various real time scenarios
  • Build confidence to excel your career as an efficient developer
  • Prerequisites : SQL basics and Unix
  • Duration: 60 days
  • Installation of required software will be provided
  • Online medium: WebEx got meeting
  • OLTP System
  • Data warehouse
  • Different Definitions of data warehouse
  • Difference between OPERATIONAL DS AND DWH
  • Data Extraction
  • Data Transformation
  • Data Loading
  • Data Merging
  • Data Aggregation
  • Data warehouse Approaches
  • Top down approach and Bottom up approach
  • DW-database design
  • Star schema and Snow flake schema
  • Dimensional modeling
  • Dimensions and Facts
  • Types of Dimensions
  • Types of fact table
  • Types of OLAP
  • History of Informatica
  • Opportunities of Informatica
  • Other ETL tools
  • Service oriented architecture
  • Integration service architecture
  • Repository service architecture
  • Repository manager
  • Designer
  • Workflow manager
  • Workflow monitor
  • Administrative tool
  • Power center repository
  • Repository services
  • Integration services
  • Power center domain
  • Application services
  • Concept of nodes and grid
  • Service manager
  • Creating Repository Users and Groups.
  • Connecting to the Repository.
  • Creating a Group
  • Assigning Privileges to a Group.
  • Creating a User
  • Creating a Folder
  • Folder Permissions
  • Creating Folders
  • Creating source definitions
  • Creating Source Tables.
  • Creating Target Definitions.
  • Creating Target Tables
  • Creating a Mapping
  • Connecting Transformations
  • Active and passive transformations 
  • Connected and un connected
  • Filter transformation
  • Router transformation
  • Expression transformation
  • Aggregator transformation
  • Sorter transformation
  • Rank transformation
  • Joiner transformation 
  • Union transformation   
  • Source qualifier transformation
  • Lookup transformation onnected and un connected  
  • Update strategy transformation  
  • Stored Procedure transformation  connected and un connected   
  • Sql transformation  
  • Sequence Generator transformation 
  • Normalizer transformation
  • Dynamic Lookup
  • Unconnected Lookup
  • Unconnected stored Procedure
  • Creating a Mapping with SCD Type 1,SCD Type 2 and Type 3
  • Creating Mapplet and Implementation
  • Creating Reusable Transformation and Implementation
  • Mapping Parameters.
  • Mapping Variables
  • Debug mappings
  • Constraint based Loading.
  • Target Load Plan
  • File Repository (Data Extraction from Indirect Files).
  • Creating Sessions and Workflows
  • Configuring Database Connections in the Workflow Manager
  • Creating a Reusable Session
  • Creating a Workflow 
  • Creating Worklets and Implementation 
  • Running and Monitoring Workflows
  • Session
  • Link task
  • Event raise task
  • Event wait task
  • Timer task
  • Control task
  • Decision task
  • Command task
  • Email task
  • Creation of Parameter file
  • Mapping and session parameter
  • Various optimization technique
  • Pushdown optimization

Frequently asked questions

The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.

In case you are not able to attend any lecture, you can view the recorded session of the class in Icronix . To make things better for you, we also provide the facility to attend the missed session in any other live batch. 

The trainer is a certified consultant and has significant amount of experience in working with the technology.

Yes, we accept payments in two installments.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.

USER REVIEWS ON POPULAR COURSES

I have recently passed my Informatica Certification exam. When I thought to go for Informatica certification course, my friend suggested me about this training. I was happy that Icronix training sessions helped me a lot to gain confidence to get certified.
Vamshi Reddy
I took Salesforce training from Icronix. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with Icronix.
Sanjana
Great experience! Thanks Icronix for providing an online learning platform where courses can be taken from anywhere and anytime as per convenience. I attended Salesforce training and Informatica training and both the courses were really good. I would definitely recommend Icronix.
Anil kumar
Icronix One-stop for all the courses you need to learn with easy and by the experts. Informatica Training helps me understand every concept in detail. I'm pretty impressed with the timings and sessions.
Kiran

We provide the best training on various tools and technologies in the following locations

India|US|UK|Canada|Australia|Germany|Philippines|New Zealand|Switzerland

Mumbai|Kolkata|Bangalore|Chennai|Kerala|Pune|Hyderabad|Lucknow|New Delhi