Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Informatica Advanced ETL & Realtime Project Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting

Course ID: 28108

Course type: Online Instructor led Course

Platform: GoToMeeting

Raj picture
No Reviews Yet

Date and Time

Not decided yet.

Raj picture

Informatica & Oracle Certified Professional

About Raj

Expert in ETL, Data Integration, Data Quality & Metadata Management
No reviews currently

About the Course

The course teaches the Advanced concepts of Informatica ETL and Realtime Project Training, through classroom/online training with numerous real time scenarios and a couple of projects.

Session Timings:
* Weekday Batches: (Mon - Sat)
Any one hour in the below mentioned timings as per the slot availability
Morning Hours: 05:00 AM - 10:00 AM IST
Evening Hours: 10:30 PM - 11:30 PM IST

* Weekend Batches: (Sat & Sun)
Two sessions (each 2 hours) per day both on Sat & Sun

Topics Covered

Module_01 ::Advanced ETL

* Different Load Types
* Slowly Changing Dimensions (Type - 1/2/3)
* Indirect Method for Loading
* Parameters and Variables (Mapping and Workflow)
* Different Types of Tasks:
Event Wait
Event Raise
* Working with Links
* Mapplets & Worklets
* Scheduler
* Parallel and Serial Batching
* User Defined Functions
* Incremental Aggregation
* Constraint Based Loading
* Target Load Plan
* Performance Tuning
* Pushdown Optimization
* Wizards
* Partitioning
* Version Control
* Debugger

Module_02: Project Training
** Total 2 projects are provided.
1. Basic Level (Demo)
2. Complex Level (Realtime)

* Participants are expected to apply required ETL Concepts and Data Warehousing concepts to build these projects
* Complete assistance and guidance in building the projects from scratch
* Explanation of different phases we have in a realtime project lifecycle
* Giving exposure about the deliverables that are expected from a Developer in a Realtime Project
* Assistance in Interview preparation (both in technical & process oriented aspects) and resume building

** Unix Shell Scripting for Batch Processing:
* Building a unix framework to batch process Informatica workflows
* Shell scripts to trigger the Informatica Workflows
* Triggering the batch from Unix environment
* Integrating the Unix batch framework with 3rd party scheduling tools

Who should attend

Participants having fundamental knowledge on Informatica PowerCenter, DWH & Unix.

Note: If you are looking for Informatica ETL Training from basic level, please check out my other courses under my profile or contact me for more details.


Informatica ETL fundamentals,
SQL fundamentals,
Data Warehouse fundamentals,
Unix fundamentals

What you need to bring


Key Takeaways

* Ability to design and develop complex mappings
* Configuring Workflows as in real time environment
* Troubleshooting errors/failures
* A realtime hands-on experience of building all together a new Data Warehouse application using Informatica PowerCenter from the scratch.
* Complete exposure to the realtime process oriented things involved in a typical project lifecycle


No reviews currently


Post your requirement and let us connect you with best possible matches for Informatica Training Post your requirement now