User online now: 1   Recent user location: Ashburn Virginia, United States


Enrolled candidates:58

Course Description

Informatica is a leading Enterprise Cloud Data Management and Data Integration platform in the world. Informatica is a software development company that mainly focuses on data integration that includes ETL, information lifecycle management, data masking, data exchange, ultra messaging, data replication, complex event processing, data quality, master data management, cloud computing integration, data virtualization. 

Informatica empowers next-generation intelligent enterprises with digital transformation. It provides intelligent data platform using its microservices architecture, CLAIRE engine, machine learning, and AI technology. Informatica PowerCenter ETL tool analyzes the information from different data sources to establish and maintain data warehouse applications. 

Hachion Informatica online training well structured by industry experts. Through our Informatica PowerCenter ETL tutorial, beginners can deep dive into Informatica basic and core concepts like Informatica architecture, ETL, data warehouse, etc. Future scope of Informatica is huge because of its wide cloud-based services in data migration, web services integration, real-time integration, B2B integration, application integration, data warehousing, and middleware applications. 

Course Schedule

Upcoming course schedule will be updated soon

Would you like to make your own schedule? Reschedule

Course Content

  • Data Warehouse 
  • Data Mart 
  • OLAP vs OLTP
  • Data Warehouse Architecture (Basic) 
  • Data Warehouse Architecture (with a Staging Area) 
  • Dimensional Modeling 
  • Star Schema 
  • Snowflake Schema 
  • Dimension 
  • Fact 
  • Slowly Changing Dimension 
  • Hierarchy 
  • Confirmed Dimension 
  • Fact less Fact 
  • Summary/ Aggregations table 
  • Change Data capture

Informatica 8.X and 9.X Versions differences

  • Designer 
  • Repository Manager 
  • Workflow Manager 
  • Workflow Monitor
  • Informatica Architecture
  • Source Qualifier
  • Target definition
  • Transformations 
  • Mappings 
  • Mapplets 
  • Sessions 
  • Tasks
  • Working with relational Sources 
  • Working with Flat Files 
  • Working with Relational Targets 
  • Working with Flat file Targets
  • Expression 
  • Lookup 
  • Sequence Generator 
  • Filter 
  • Joiner 
  • Sorter 
  • Procedural 
  • Router 
  • Aggregator 
  • Active and Passive Transformations 
  • Update Strategy 
  • Data Concatenation 
  • Debugging Mappings
  • Mapping Variables & Parameters 
  • Creating Cubes & Dimensions 
  • Working with Mapping Wizards
  • Server Architecture 
  • Workflows, Worklets & Sessions 
  • Tasks, Assignments, Events, Command
  • Informatica Tuning (Source, target, mapping & Session) 
  • Oracle Tuning (Indexes, MV, Explain plan, Tkprof & SQL Hints)

Scheduling tool:  Informatica Scheduler

Informatica Training FAQs

Download pdf

The following professionals can go for this Informatica Training:

1. Software Developers

2. Analytics Professionals

3. BI/ ETL/ DW Professionals

4. Mainframe developers and Architects

5. Individual Contributors in the field of Enterprise Business Intelligence

Basic knowledge of SQL is required to take this Informatica online course.

After finishing this Informatica training, numerous job opportunities will be available over the world. Some of the designations you will be recruited for are listed below:

  • Informatica Developer
  • ETL Engineer 
  • Informatica - Data Integration Architect
  • Informatica Specialist
  • Informatica Infrastructure Engineer 

The average annual pay for an ETL Informatica Developer in the US is $121,633 per year - ZipRecruiter

We provide 100% job assistance to the Hachion students, once they complete the course. We also provide resume writing, mock interviews, and resume marketing services as part of our job assistance program. 

Hachion online training program offers three modes of training: Self Placed, Mentorship, and Instructor-Led

Informatica Sample Resume


After completion of the Informatica online training program, candidates will get a course completion certificate

 Share This Link
facebook   instagram   linkedin   twitter
 Live Online Training  
  • Live interactive online training(Instructor based)
  • Daily recorded videos
  • Exercises & project Work
  • Resume preparation assistance
  • Interview assistance
  • Resume marketing after completion of the training
  • Certification assistance
  • Course completion certificate
 Mentoring mode training N/A  
  • Trainer support will be provided in your flexible timings
  • Access for all the recorded videos before the training
  • No Time limit to complete the training
  • Exercises & project Work
  • Resume preparation assistance
  • Interview assistance
  • Resume marketing after completion of the training
  • Certification assistance
 Self-paced training N/A  
  • Access for all the recorded videos before the training
  • No Time limit to complete the training
  • Exerciese & Project Work
  • Certification Assistance
  • Resume Preparation Assistance
  • Resume Marketing After completion of the training
 Tech Support/Live Project
 Informatica jobs info
  • Click here to know available jobs with Hachion partner companies