Informatica Training

Both Online and Offline

100% Guarantee in placement

Course Details

Course Features

Instructor led Sessions
The most traditional way to learn with increased visibility, monitoring, and control over learners with ease to learn at any time from internet-connected devices.
Real-life Case Studies
Case studies based on top industry frameworks help you to relate your learning with real-time based industry solutions.
Adding the scope of improvement and fostering the analytical abilities and skills through the perfect piece of academic work.
Each certification associated with the program is affiliated with the top universities providing edge to gain epitome in the course.
Instructor led Sessions
With no limits to learning and in-depth vision from all-time available support to resolve all your queries related to the course.

Informatica Training

Oranium Tech introducing some amazing content on Informatica. Oranium Tech is curated by top industry experts and designed to meet industry benchmarks. Our Informatica training course is fully immersive and will help you clear the Informatica PowerCenter Developer. This instructor-led & helps you master key Informatica concepts such as Data Integration, ETL, and Data Mining using Informatica PowerCenter with hands-on demonstrations. Enroll now in this online Informatica course & become a certified Informatica developer with Oranium Tech.

Course Syllabus

In this module of Informatica Training, we will talk about the different Informatica Products available along with understanding the overview of Informatica PowerCenter Products, Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows, and Workflow Monitor. We will also discuss the installation of Informatica in this module.
• Informatica & Informatica Product Suite
• Informatica PowerCenter as ETL Tool
• Informatica PowerCenter Architecture
• Component-based development techniques
• Installation of the Product in Windows and using Oracle as a Database
• Creation of the services and connecting the client to the server

In this module of Informatica Certification Training, we will discuss different Data Integration Concepts. You will be introduced to the concepts – Data Profiling, Data Quality Management, ETL and ETL architecture, and Data Warehousing.
• Data Integration Concepts
• Data Profile and Data Quality Management
• ETL and ETL architecture
• Brief on Data Warehousing
• Look through the properties of the services required
• Shutdown and start-up of the services from the Administration Console
• Creation and execution of a simple pass-through mapping.

In this module of Informatica Certification Training, you will learn about different development units of PowerCenter and how they can be used to create a simple mapping and transformations.
• Visualize PowerCenter client tools
• Data Flow
• Create & execute mapping
• Transformations & their usage
• Use multiple transformations inside the mapping to resolve different use cases
• Look at the properties of the transformations to customize them

In this module of Informatica Certification Training, you will learn about the development units of Informatica PowerCenter (workflow manager & monitor) and how are they are used to create different tasks and
• PowerCenter Workflow Manager
• Flow within a Workflow
• Reusability & Scheduling in Workflow Manager
• Components of Workflow Monitor
• Workflow Task and job handling
• Create tasks, workflow
• Configure workflow properties
• Schedule a workflow

Through this module of Informatica Certification Training, you will learn about Advanced Transformation techniques which will equip you to deal with advanced concepts of PowerCenter transformations like Java, XML etc. We will also discuss various Error Handling, Transaction Processing & Reusability features available in Informatica.
• Advanced transformations (Java, SQL, Normalizer)
• XML File Processing & Transaction Processing
• Error handling features
• Cleaning the data (Advanced Functions, Regular Expressions)
• Reusability features
• Use of advanced transformations like XML Processing, Union etc.
• Use of inbuilt and custom functions to fulfill the data transformation needs.
• Reusable transformations, Sessions, Mapplets, etc.

In this module of Informatica Training, we will discuss advanced ETL scenarios using Informatica. You will be introduced to the concepts – Error Handling, Partitioning, PushDown Optimization, Incremental Aggregation, Constraint-Based Loading, Target Load Order Group, CDC (Change Data Capture), etc. We will also discuss creating Data Warehouse related processes like SCD, Fact and Dimension Loading.
• Changed Data Capture, Incremental Aggregation, Constraint-Based Loading, etc.
• Advanced techniques – Flat File, XML File
• Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
• Changed Data Capture, Incremental Aggregation, Constraint-Based Loading, etc.
• Advanced techniques – Flat File, XML File
• Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)

In this module of Informatica Training, you will understand the features provided by Informatica to debug, troubleshoot & handle errors to understand the inner workings and responsibilities of the operational role. Various PowerCenter recovery options for tasks and workflows will be discussed along with the recommended best practices for the operations process.
• PowerCenter Error
• Basic troubleshooting methodology
• Debugger
• Workflow and Session logs to diagnose errors
• Connection Errors & Network errors
• Recovery scenarios & mechanisms
• Configure workflow & sessions for recovery
• High Availability
• PowerCenter Environment
• Perform troubleshooting of Informatica errors
• Use of Debugger to debus a mapping
• Perform workflow and session recovery and related configuration needed for that

This module of Informatica Certification Training highlights the performance aspects of Informatica PowerCenter components and their efficient use of them. We will also discuss about the best practices suggested by Informatica for the optimum performance of your ETL process.
• Performance Tuning Methodology
• Mapping design tips & tricks
• Caching & Memory Optimization
• Partition & Pushdown Optimization
• Design Principles & Best Practices
• Identify the bottlenecks
• Different configurations needed to resolve the bottlenecks
• Learn tips and tricks to code efficient mappings
• Cache and DTM buffer memory configuration

This module of Informatica Training will introduce you to the usage and components of PowerCenter repository manager. You will also learn to migrate and manage the repository effectively.
• Repository Manager tool (functionalities, create and delete, migrate components)
• PowerCenter Repository Maintenance
• Get acquainted with the repository manager tool and its functionalities
• Creation and editing of a Folder
• Copy Informatica objects
• Historical view of session and workflow statistics

This module of Informatica Certification Training, will give you an overview of the PowerCenter administration console, and recognize and explain integration and repository service properties. We will also discuss the command line utilities and use them to manage the domain and repository, start and control workflows.
• Features of PowerCenter 10
• Overview of the PowerCenter Administration Console
• Integration and repository service properties
• Services in the Administration Console (services, handle locks)
• Users and groups
• Learn details of different components of Informatica Administration tool
• Create user, group, assign privileges to the users and groups
• Create Roles
• Looking at the service logs, taking export of the service logs
• Service maintenance from Administration console

This module of the Informatica Certification Course deals with the command line part of Informatica PowerCenter. You will learn to automate the tasks from the command line as well.
• Infacmd, infasetup, pmcmd, pmrep
• Automate tasks via command-line programs
• Hands-On/Demo:
• Use Infacmd, infasetup, PMC MD, and prep to automate tasks via command-line programs

This module of Informatica Certification Training will give you detailed coverage of the architectural aspects of Informatica as a whole and PowerCenter in particular.
• Informatica 10 Architecture
• Application services
• Buffer memory
• Connectivity among the tolls
• Connection Pooling

Related Courses

Tableau Training

MSBI Training

Advanced Excel Training

Ab initio Training