Informatica Training

7254 Learners

Informatica, a powerful ETL (Extraction, Transformation & Load) tool, is widely used for enterprise data warehousing. Data Warehousing is a relational database, used for analysis purpose rather than transactional work. It contains data collected from multiple sources that is further transformed to fit the organizational needs. Informatica training helps the participants to get well versed in data warehousing concepts, ETL process, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.

Upon the completion of the Informatica course, the candidates will be able to do the following:

  • Understand Data warehouse concepts and its architecture
  • Describe OLAP and OLTP database
  • Familiarize with the concepts of Data mart, dimensional modeling, and data design model (star schema/snowflake schema)
  • Learn the features and usage of Primary key /surrogate key/unique key
  • Describe slowly changing dimension and its different types
  • Elucidate the concepts of Staging area and warehouse load
  • Work on normalization and denormalization
Target audience
  • Database Administrators
  • Java Developers
  • Support Engineers
  • Technical Administrators
  • Technical Consultants
  • Data Analysts
  • Experienced Business Users who have been working extensively in Data Warehousing
  • Professionals with familiarity in Informatica or other DWH tools and wish to further renew the skills
Prerequisites

Candidates with basic knowledge of programming, RDBMS concepts, and sound analytical skills can undergo this training.

Informatica, a powerful ETL (Extraction, Transformation & Load) tool, is widely used for enterprise data warehousing. Data Warehousing is a relational database, used for analysis purpose rather than transactional work. It contains data collected from multiple sources that is further transformed to fit the organizational needs. Informatica training helps the participants to get well versed in data warehousing concepts, ETL process, an online analytical processing (OLAP) engine, client analysis tools, and other applications that manage the process of gathering data and delivering it to business users.

Upon the completion of the Informatica course, the candidates will be able to do the following:

  • Understand Data warehouse concepts and its architecture
  • Describe OLAP and OLTP database
  • Familiarize with the concepts of Data mart, dimensional modeling, and data design model (star schema/snowflake schema)
  • Learn the features and usage of Primary key /surrogate key/unique key
  • Describe slowly changing dimension and its different types
  • Elucidate the concepts of Staging area and warehouse load
  • Work on normalization and denormalization
Target audience
  • Database Administrators
  • Java Developers
  • Support Engineers
  • Technical Administrators
  • Technical Consultants
  • Data Analysts
  • Experienced Business Users who have been working extensively in Data Warehousing
  • Professionals with familiarity in Informatica or other DWH tools and wish to further renew the skills
Prerequisites

Candidates with basic knowledge of programming, RDBMS concepts, and sound analytical skills can undergo this training.

1. ETL Tool: Informatica 9.x.x/8.x.x/7.x.x 

  • Introduction to ETL process
  • Understanding of Power center
  • Informatica Architecture
  • Basic terms and concepts
  • Informatica Tools
  • Informatica Repository manager
  • Creating user and privileges
  • Defining Relational connection
  • Homogenous and Heterogeneous source concepts
  • Introduction to ETL process
  • Defining Sources
  • Creating Target definition
  • Mapping Designer
  • Mapplet Designer
  • Working with Mapping
  • UDF (User Defined Function)
  • Mapping parameter
  • Mapping Variables
  • Parameter File
  • Session
  • Tasks
  • Worklet
  • Link
  • Function and References
  • Workflow
  • Defining Connection

2. ETL Tool: Informatica 9.x.x/8.x.x/7.x.x  Transformation

  • Source Qualifier
  • Expression
  • Filter
  • Router
  • Joiner
  • Sequence Generator
  • Aggregator
  • Rank
  • SQL
  • Union
  • Update Strategy
  • Transaction Control
  • Connected Lookup
  • Unconnected Lookup
  • Stored procedure

3. ETL Tool: Informatica 9.x.x/8.x.x/7.x.x  Oracle (SQL/PL SQL) Conceps

  • Introduction to Oracle (SQL/ SQL&PL/SQL)
  • Joining Concepts
  • Sub queries and Correlated Queries
  • Interview Tips

4. ETL Tool: Informatica 9.x.x/8.x.x/7.x.x  UNIX Concepts

  • Introduction to UNIX
  • Basic command
  • Unix Interview question
  • Scenario Based question on Informatica/Unix/oracle

Drop Us a Query

+91 95550 06479

Available 24x7 for your queries

Informatica Corporate Training & Certification Program

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.

Learn from the experts

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements of your workforce. You can even choose a trainer from our team of certified industry experts.

Learn from the experts

Expert Mentors

Get trained from our team of highly skilled and certified trainers, who are officially accredited professionals with relevant industry experience and adept in providing the knowledge and skills required to be successful.

Learn from the experts

360º Learning Solution

Engage your employees with our all-inclusive learning platform. Avail benefits of 24/7 access to the learning management system, industry-certified mentors, assessments & mock tests, real-time learning and more.

Learn from the experts

Learning Assessment

Check test score and performance with our skills analysis tools. Our detail scoreboard displays scores, areas of strength, detailed answer of questions and more for each employee.

Download Corporate Brochure

+91 9555006479

Available 24x7