Reviews 4.9 (4.6k+)
Rated 4.7 out of 5
Informatica Certification Online Training
One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.
About Course
🌐 Informatica Online Training – Course Overview
The Informatica Online Training program is designed to help learners gain expertise in data integration, ETL (Extract, Transform, Load) processes, and data management using PowerCenter. This course covers everything from basic transformations to complex data workflows, ensuring participants can efficiently manage enterprise data across multiple systems.
Learners will gain hands-on experience in data mapping, workflow design, repository management, and performance optimization. The training also includes best practices for real-time data integration, data quality, and migration.
This course is ideal for ETL Developers, Data Engineers, Business Intelligence Professionals, and Database Administrators who want to build a strong career in data integration and analytics using Informatica.
💡 Key Skills You’ll Learn
- Master ETL concepts and architecture
- Build mappings, sessions, and workflows in PowerCenter
- Work with transformations and data cleansing techniques
- Manage repository, connections, and reusable components
- Optimize performance and troubleshoot issues
- Learn about real-time and cloud integration
🎓 Certification Tracks
- PowerCenter Developer Certification
- Data Integration Certification
- Cloud Specialist Certification
- Certified Professional (Viswa Online Trainings)
Informatica Training Course Syllabus
Introduction to Data Warehousing and Business Intelligence
- What is Data Warehousing and BI?
- Why we need Data Warehouse and BI?
- Who needs DWH and BI?
- What is OLTP and OLAP? And what is difference between them?
- Advantages of DWH
- Types of DWH
- DWH Implementation approaches
- DWH Architecture
Introduction to ETL
- what is ETL?
- ETL Architecture
- Different ETL Tools
- Different BI Tools
- Gartner Magic quadrant for ETL and BI
Dimensional Modelling
- what is dimenional table?
- what is fact table?
- Types of fact?
- Types of Dimensions?
- Different types of Dimensional Modelling
- Star Schema
- Snow flake schema
Introduction to Informatica
- Server anc Client Download & Installation
- Informatica versions.
- Latest Version and difference between latest and earlier versions.
- Informatica Admin console basics
Architecture of Informatica
.
Informatica Client tools
- Informatica power center Repository
- Informatica power center Designer
- Informatica power center WORKFLOW DESIGNER
- Informatica power center WORKFLOW MONITOR
ODBC Connections of Informatica
.
Power center Designer Tools
- Source Analyzer
- Target Designer
- Transformation Developer
- Mapping Designer
- Mapplet Designer
Types of Transformations
- Source Qualifier Transformation
- Filter Transformation
- Joiner Transformation
- Expression Transformation
- Sorter Transformation
- Aggregator Transformation
- Rank Transformation
- Union Transformation
- Router Transformation
- Sequence Generator
- Lookup Transformation
- Update strategy Transformation
- Normalizer Transformation
- Advanced Transformations
Implementation of Slowly Changing Dimensions (SCD)
- Implementing SCD TYPE-1
- Implementing SCD Type-2
- Implementing SCD Type-3
Informatica Workflow Manager
- Tasks
- Workflow
- Worklet
- Workflow Task
- Scheduling Workflows
- Batch Processing
- Informatica Advanced Topics
- Implementing Mapplet
- User-Defined Functions
- Debugging
- Mapping Parameters
- Mapping Variables
- Cache
- Target Load Plan
- Implementing Worklet
- Session Properties
- Test Cases
- Link-Conditions
Real time scenarios
.
Value adds if any
.
Interview Preparation
.
Informatica Course Key Features
- Live Instructor based training with software
- Certification Oriented content
- Hands-on complete Realtime training
- Flexible schedule demo's & classes
- Live recorded videos access
- Study material provided
- JOB Assistance
Course completion certificate
Informatica Training - Upcoming Batches
Coming Soon
AM IST
Coming Soon
AM IST
Coming Soon
PM IST
Coming Soon
PM IST
Don't find suitable time ?
Request More Information
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
- Schedule your sessions at your comfortable with timings
- Instructor-Led training real time projects
- Certification Guidance
PREFERRED
Self-Paced Learning
- Complete set of live-online training session recorded videos.
- Learn technology at your own pace.
- Get access for lifetime.
Corporate Training
- Learn as a full day schedule with discussions, exercises.
- Practical use cases.
- Design your own syllabus based
FOR BUSINESS
Informatica Online Training FAQ'S
What is Informatica PowerCenter?
Informatica PowerCenter is an ETL tool used to extract data from multiple sources, transform it into a desired format, and load it into target systems.
What are different types of transformations in Informatica?
- Some common transformations are Expression, Aggregator, Filter, Joiner, Lookup, and Router transformations.
What is a repository in Informatica?
The repository is a centralized database that stores metadata such as mappings, sessions, workflows, and connection information.
How do you handle performance tuning in Informatica?
- By optimizing sources, using partitioning, caching lookups, avoiding unnecessary transformations, and monitoring sessions.
What is the difference between connected and unconnected lookups?
A connected lookup is part of the mapping data flow, while an unconnected lookup is called as a function when required, improving performance.
Reviews
More Courses You Might Like
No posts found!