Informatica Certification Training Course

Access Duration - 365 Days
4.3( 3 REVIEWS )
155 STUDENTS
£.00
 

What Will I Learn?

Gain in-depth knowledge of the Informatica PowerCenter, its Architecture, and Environment
Comprehensive knowledge of various tools like Informatica Administrator Suite, Repository Manager, Designer and Workflow Manager
Capability to load Dimension Tables, use Advanced Transformation, recognize and repair Connection & Network Errors, configure Workflows & Sessions, create Users and Group and design Error Handling strategies
Gain hands-on knowledge of Informatica PowerCenter command line tools
Learn industry standards and best practices

Overview

Informatica is one of the most widely used data integration platforms in the world. It combines advanced hybrid integration capabilities and centralized governance with self-service business access for a variety of analytic functions. Informatica PowerCenter is a metadata-driven integration tool that accelerates projects in order to deliver data to the business more quickly than manual hand-coding. It also allows developers and analysts to collaborate, prototype, analyse, and deploy projects.

This Informatica Certification course offers you an overview of the product and installation of Informatica PowerCenter, data integration principles and data warehousing. You will know how different PowerCenter creation units can be used to construct a basic mapping. The Informatica Certification Course introduces you to advanced transformation strategies and ETL scenarios. You will also learn the features provided by Informatica to debug, troubleshoot ,handle errors and learn the best practices for optimum performance of your ETL process and to manage the repository effectively.

Why You Should Consider Taking this Course at Global Edulink?

Global Edulink is a leading online provider for several accrediting bodies, and provides learners the opportunity to take this exclusive course awarded by CPD. At Global Edulink, we give our fullest attention to our learners’ needs and ensure they have the necessary information required to proceed with the Course.  Learners who register will be given excellent support, discounts for future purchases and be eligible for a TOTUM Discount card and Student ID card with amazing offers and access to retail stores, the library, cinemas, gym memberships and their favourite restaurants.

  • Access Duration
  • Who is this Course for?
  • Entry Requirement
  • Method of Assessment
  • Certification
  • Awarding Body
  • Career Path & Progression
The course will be delivered directly to you, and from the date you joined the course you have 12 months of access to the online learning platform. The course is self-paced, and you can complete it in stages at any time.
  • Data Integration developers
  • Informatica PowerCenter Administrators
  • BI/ETL/DW Professionals
  • Informatica Administrators with some considerable experience in using PowerCenter or maintaining Data Quality
  • Individual Contributors in the field of Enterprise Business Intelligence
  • Learners should be over the age of 16, and have a basic understanding of English, ICT and numeracy.
  • A sound educational background
In order to complete the course successfully, learners will take an online assessment. This online test is marked automatically, so you will receive an instant grade and know whether you have passed the course.
Upon the successful completion of the course, you will be awarded the ‘Informatica Certification Training Course’ by CPD.
CPD is an internationally recognised qualification that will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in an enterprise.
Once you successfully complete the course, you will gain an accredited qualification that will prove your skills and expertise in the subject matter. With this qualification you can further expand your knowledge by studying related courses on this subject, or you can go onto get a promotion or salary increment in your current job role. Below given are few of the jobs this certificate will help you in, along with the average UK salary per annum according to http://payscale.com/
  • Database developer – Up to £69k per annum
  • Administrator – Up to £68k per annum
  • Data Integration developer – Up to £79k per annum

Key Features

Gain an Accredited UK Qualification
Access to Excellent Quality Study Materials
Personalised Learning Experience
Support by Phone, Live Chat, and Email
Eligible for TOTUM Discount Card
UK Register of Learning Providers Reg No : 10053842

Course Curriculum

1: Informatica PowerCenter 10 - An Overview
Informatica & Informatica Product Suite
Informatica PowerCenter as ETL Tool
Informatica PowerCenter Architecture
Component-based development techniques
2: Data Integration and Data Warehousing Fundamentals
Data Integration Concepts
Data Profile and Data Quality Management
ETL and ETL architecture
Brief on Data Warehousing
3: Informatica PowerCenter Transformations
Visualize PowerCenter client tools
Data Flow
Create & execute mapping
Transformations & their usage
4: Informatica PowerCenter Tasks & Workflows
PowerCenter Workflow Manager
Flow within a Workflow
Reusability & Scheduling in Workflow Manager
Components of Workflow Monitor
Workflow Task and job handling
5: Advanced Transformations, Techniques & Reusability Features
Advanced transformations (Java, SQL, Normalizer)
XML File Processing & Transaction Processing
Error handling features
Cleaning the data (Advanced Functions, Regular Expressions)
Reusability features
6: ETL Scenarios using Informatica
Changed Data Capture, Incremental Aggregation, Constraint Based Loading etc.
Advanced techniques – Flat File, XML File
Loading Dimensional Tables (SCD-1, SCD-2, SCD-3)
7: Service & Support of Informatica PowerCenter Environment
Power Center 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
Power Center Environment
8: Performance Tuning, Design Principles & Caches
Performance Tuning Methodology
Mapping design tips & tricks
Caching & Memory Optimization
Partition & Pushdown Optimization
Design Principles & Best Practices
9: Informatica PowerCenter Repository Management
Repository Manager tool (functionalities, create and delete, migrate components)
PowerCenter Repository Maintenance
10: Informatica Administration & Security
Features of Power Center 10
Overview of the Power Center Administration Console
Integration and repository service properties
Services in the Administration Console (services, handle locks)
Users and groups
11: Command Line Utilities
Infacmd, infasetup, pmcmd, pmrep
Automate tasks via command-line programs
12: Informatica 10 - Technical Architecture
Informatica 10 Architecture
Application services
Buffer memory
Connectivity among the tolls
Connection Pooling

Students feedback

4.3

Average rating (3)
4.3
5 Star
4 Star
3 Star
2 Star
1 Star
    S H

    Skye Houghton

    January 12, 2021
    Professional course

    This was a very professional course and I learned a lot. Content is great and are easily understandable with the examples

    J T

    Jesse Turner

    December 28, 2020
    Deep knowledge

    This course is very good to start for anyone interested in Informatica. Good use of Example and best practices.

    H B

    Harley Barnes

    November 25, 2020
    Detail oriented

    The course gave me a good understanding of Informatica. Thank you! I would encourage to provide more videos like these.

£.00
WhatsApp chat