- Introduction to data warehousing
- Learn what is Informatica PowerCenter ETL
- What is ETL and overview of data cleansing, data scrubbing, data aggregation
- Home
- Intellipaat
- Courses
- Informatica Certification Training
Informatica Certification Training
Open the doors of knowledge and success by joining this informatica certification training course by Intellipaat.
Online
₹ 18,012 20,007
Quick facts
particular | details | ||
---|---|---|---|
Medium of instructions
English
|
Mode of learning
Self study, Virtual Classroom
|
Mode of Delivery
Video and Text Based
|
Frequency of Classes
Weekends
|
Course overview
The Informatica Certification course by Intellipaat is a specially designed course to impart PowerCenter ETL tool knowledge and train them about data interpretation and data warehouse concepts. The Informatica certification training course will also help them to get their hands on the tools and software and become a master for various advanced concepts such as installation and configuration, Informatica architecture and its transformations and performance tuning along with configuration installation of the PowerCenter.
In this fast-growing and evolving world, it has become important for businesses to stand in the competition for which they search for employees that stand out from the group and have mastered their skills in data learning. By doing this course the candidates will gain both practical as well as technical skills brushed up. They will gain more insights and knowledge about how the commercial world works and make a bright and promising future.
The highlights
- 42 hours of instructor-led training
- 60 hours of project work
- Flexible schedule
- 24/7 lifetime support and access
- Access to self-paced videos
- 7 guided projects to practice
- Certification by Intellipath
Program offerings
- Project work
- Assignments
- Exercises
- Online class
Course and certificate fees
Fees information
- The self-paced training fee is Rs 12,027
- The online classroom fees are Rs. 18,012 (limited time offer)
- Both the prices are excluding taxes
- 18% GST is applicable
Here is the tabular form of the fees structure for the course:
Course type | Fees in INR |
Self-Paced Training | Rs. 12,027 |
Online Classroom | Rs. 20,007 |
certificate availability
certificate providing authority
Eligibility criteria
Education:
Candidates applying for Informatica Certification Training programme courses need not require any specific educational criteria but knowledge of SQL can be a beneficial thing.
Certification qualifying details:
The candidate will be certified for the course only after they successfully score at least 60% marks in the quiz and the review of the project work by the expert review.
What you will learn
- The candidate masters the technique of how to configure the Informatica tool along with the installation of Informatica operational administration activities and integration services
- They will learn how to Install PowerCenter effectively
- They will use connected passive transformation to calculate the value on a single row effectively
Who it is for
The Informatica Certification Training programme is applicable for:
- SQL Professionals
- Project Managers
- Database Professionals
- ETL Professionals
- Business Intelligence Professionals
Admission details
Filling the form
Step1: Visit the URL for Informatica certification training
Step 2: Look for the Enroll Now Button and click on it. You will land on the fees section
There are 2 options under Fees namely, Self Paced Training and Online Classroom. Candidates can select the desired option and make the payment by checking out. You need to sign up as well via Google and Facebook.
Click Cart and make the payment via different methods such as debit or credit card, net banking, etc.
The syllabus
Data Warehousing and Cleansing Concepts
Informatica Installation and Configuration
- Overview of Informatica configuration
- Installation of Informatica
- Operational administration activities
- Integration Services
Working with the active and passive transformation
- Learn what is active and passive transformation and the differences between the two.
Working with expression transformation
- Connected passive transformation to calculate the value on a single row
- Learning about expression transformation
Working with Sorter, Sequence Generator, Filter transformation
- Sequence Generator and Filter
- The characteristics of each and where they are used
- The different types of transformations like Sorter
Working with Joiner Transformation
- Joiner transformation to bring data from heterogeneous data sources
Working with Ranking and Union Transformation
- The characteristics and deployment
- Understanding the Ranking and Union transformation
The syntax for Rank and Dense_rank
- Learn about the rank and dense_rank functions and the syntax for them
Router Transformation
- Understanding how router transformation works and its key features
Source Qualifier Transformation and Mappings
- Lookup transformation
- Overview and different types of lookup transformation: Unconnected, Connected, Dynamic and Static
Slowly Changing Dimension in Informatica
- What is SCD?
- Learn how to handle flat file, list and define various transformations repeat Implementing ‘for loop’ in the power center
- Processing in XML
- What is incremental aggregation?
- Concepts of pushdown optimization and partitioning
- What is constraint-based loading?
Mapplet and loading to multiple designers
- Different types of the designer: Worklet, Mapplet, loading to multiple targets, target load plan, and linking property.
Performance Tuning in Informatica
- Objectives of performance tuning
- Defining performance tuning
- Learning the sequence for tuning
Projects
- Admin console
- Deploying Informatica ETL for business intelligence
- Deploying the ETL Transactions on healthcare Data
- Deploying Informatica ETL for Business Intelligence
- Deploying the ETL transactions on healthcare
- Case study1- Banking Products Augmentation
- Case study2- employee Data integration
How it helps
By doing this course the candidate will be capable of clearing the Power Center Developer Certification course and helps you to get the best jobs in the MNCs. The course is well planned which contains real-time projects and assignments which easily connect to the scenarios of the industry. The certificate of the course is well recognised by more than top 80 MNCs like TCS, Hexaware, Sony, Mu Sigma, Cisco, etc
The course has the option of customized learning along with a lifetime free upgrade of the programme, one on one doubt resolution sessions. The candidate also has the opportunity to attend as many batches for the life he wants to. They will also get job assistance which will help them become capable of getting a higher positioned job, they can start a new career and even receive a better salary hike and promotion.
FAQs
If there is any need for official documents the student will be informed after they enroll for the programme.
The course in total is 42 hours and is totally flexible for the candidate so that they can do it at their own pace.
No, there is no age barrier for the programme. We believe there is no age limit for education and learning new skills.
The candidates will get access to the digital certificate which can be then printed and used.
To receive any details about sponsorship and its eligibility we would ask the candidate to connect with the helpdesk through the phone number available on our website.