Informatica Training & Certification

Introduce your company to lean data integration and better warehousing practices

Enroll Now View Curriculum

Key Highlights

  • 42 Hours of Live Instructor-led Classes
  • 12 sessions of 3.5 hours each on Weekends
  • 21 sessions of 2 hours each on Weekdays
  • Live Project on Real-life Case Studies
  • Practical Assignments
  • Lifetime Access to Learning Management System
  • 24x7 Expert Support
  • Course Completion Certificate
  • Online Forum for Discussions

Course Price Range

$389.00 - $389.00 $800.00 - $800.00

Contact Us

1866-216-7898

(Toll Free)

Available Courses Delivery

This course is available in the following formats:

Virtual Live

Access live online training from anywhere taught by expert instructors
Search and study from listed class recordings and materials
View Batches

 

Upcoming Batches


Nov 29th
Filling Fast
Delivery: Online
Access: Lifetime
Fri - Sat (6 Weeks)
Timings - 08:30 PM to 10:30 PM (EST)

Weekend Batch (Evening)
$800  $389
Enroll Now
filling status

Course Overview

Informatica Training and Certification introduces learners to lean data integration and data warehousing using the Informatica PowerCenter 10. In this course, the different development units are discussed and how they are used to create simple mappings. Trainees will learn about the advanced transformation techniques, best practices for ETL processes, and the PowerCenter 10 command line.

Course Objectives

  • Clear the fundamentals of Informatica PowerCenter and understand its architecture
  • Learn to use Informatica Administrator Suite
  • the Designer and Workflow Manager
  • Repository Manager
  • Use Advanced Transformation and learn to differentiate network errors for reparations
  • Get practical knowledge on Informatica PowerCenter command line tools
  • Explore real life industry projects to comprehend better

Career Benefits

  • Enter the demanding ETL and Data Integration market
  • Raise your career prospects and growth opportunities
  • Better remuneration
  • People from non-coding background can also learn Informatica PowerCenter 10
  • Ease your job using a neutral platform that can be communicated with any database

Prerequisites

  • Basic knowledge of SQL will help

Who should take up?

  • Aspiring Informatica Developers
  • Data Integration developers
  • BI/ETL/DW Professionals
  • Informatica PowerCenter Administrators
  • Business Intelligence Individual Contributors
  • Database developers
  • Informatica Administrators

Course Content

  • Informatica & Informatica Product Suite
  • Informatica PowerCenter as ETL Tool
  • Informatica PowerCenter Architecture
  • Component-based development techniques
  • Data Integration Concepts
  • Data Profile and Data Quality Management
  • ETL and ETL architecture
  • Brief on Data Warehousing
  • Visualize PowerCenter client tools
  • Data Flow
  • Create & execute mapping
  • Transformations & their usage
  • PowerCenter Workflow Manager
  • Flow within a Workflow
  • Reusability & Scheduling in Workflow Manager
  • Components of Workflow Monitor
  • Workflow Task and job handling
  • Advanced transformations (Java, SQL, Normalizer)
  • XML File Processing & Transaction Processing
  • Error handling features
  • Cleaning the data (Advanced Functions, Regular Expressions)
  • Reusability features
  • Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
  • Advanced techniques - Flat File, XML File
  • Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
  • 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
  • Performance Tuning Methodology
  • Mapping design tips & tricks
  • Caching & Memory Optimization
  • Partition & Pushdown Optimization
  • Design Principles & Best Practices
  • Repository Manager tool (functionalities, create and delete, migrate components)
  • PowerCenter Repository Maintenance
  • 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
  • Infacmd, infasetup, pmcmd, pmrep
  • Automate tasks via command-line programs
  • Informatica 10 Architecture
  • Application services
  • Buffer memory
  • Connectivity among the tolls
  • Connection Pooling

SEARCHING FOR THE RIGHT COURSE?

Upskill counselors can help you pick the suitable program

CALL US NOW 1866-216-7898

Schedule a call.


IN DEMAND & POPULAR TRAINING COURSES

Popular Courses