---------------- ---------------------

Informatica PowerCenter Online training and certification

Informatica online training certification helps you to excel in Power center ETL tool, data integration as well as learn data warehousing concepts. You will get to master concepts related to Informatica architecture, configuration and installation, performance tuning and migration as well as advance Informatica transformations. Post completion of the course you will become Informatica Certified Professionals (ICP).

Why should I do this Informatica MDM training?

Informatica is one of the most advanced and used ETL/data integration tool today.

  • 1

    Informatica professionals earn anywhere between $120k and $135k annually.

  • 2

    Innumerable Fortune 500 companies globally use Informatica. To name a few- GE, BNY Mellon, PayPal, Siemens, eBay, etc. amongst others.

  • 3

    According to IDG Research Report, nearly 71% enterprises are set to adopt cloud-only analytics and hybrid analytics by 2018

Instructor-led live online classes

6JAN Sat - Sun ( 5 Weeks ) 09:30 AM - 12:30 PM ( EST ) $400 $300 image
8 JAN Mon - Thu ( 4 Weeks ) 08:30 PM - 10:30 PM ( EST ) $400 $300 image
6JAN Sat - Sun ( 5 Weeks ) 08:30 PM - 11:30 PM ( IST ) 26144.00 rs 19608.00 rs image
9 JAN Tue - Fri ( 4 Weeks ) 07:00 AM - 09:00 AM ( IST ) 26144.00 rs 19608.00 rs image
Can't find convenient schedule? Let us know

Course Features

  • icon

    Sessions

    The module features live classes that are led by expert trainers and are divided into- Weekends- 3 hour sessions | Weekdays- 2 hour sessions

  • icon

    Projects

    Live project based on any of the chosen cases that involve implementation of various AWS services.

  • icon

    Coursework

    You must complete practical assignments, given at the end of every class, with submissions taking place in the next class. This will help you become a better developer.

  • icon

    Access for lifetime

    By enrolling in this class, you get lifetime access of all WebEx seminars and classes. Presentations and class recordings can be viewed online from WebEx without any trouble.

  • icon

    24*7 Support

    You will get round-the-clock expert support to help you with any technical queries that may arise during the course.

  • icon

    Certification

    You will work on a project at the end of the module in order to get the requisite specialized certification

Course Description

  • About Course

    Learn to administer the tool efficiently via Informatica PowerCenter online training program. You not only get to update your skills as a developer but also increase your market value and knowledge in the bargain. You can now upgrade your skills from a PowerCenter developer to a full-fledged Informatica professional through Informatica administrator training.

    The online training and certification course gives you an overview of the Informatica PowerCenter product as well as its installation along with data integration and warehousing. Learn to do simple mapping online and use varied development units of PowerCenter effectively. The Informatica developer training certification course is designed to introduce you to the comprehensive ecosystem of Informatica that deals with advanced transformation techniques, ETL scenarios utilizing Informatica 10. You also get to enjoy the benefits of debugging, handling errors and troubleshooting better. Manage the repository well by optimum utilization of ETL Processes.

  • Course Objectives

    • Learn about the Informatica Powercenter as well as Informatica architecture
    • Configuration and Installation of Informatica
    • Learn to monitor and manage Informatica workflow
    • Comprehend how Powercenter handles Tasks and Jobs efficiently
    • Learn about Informatica session parameters and workflow variables
    • Work with Informatica Admin Console
    • Learn Informatica performance tuning and well as managing Informatica Repository
    • ETL functionalities and scenarios
    • Informatica XML and SQL transformation
  • Why should one pursue Informatica online certification?

    Informatica offers the market's leading data integration / ETL platform.

    Operating with the widest range of systems and standards, Informatica has been tested on nearly 500,000 combinations of platforms and applications. This balanced and collectiveobservation makes Informatica a market leader in the data integration platform.

    Informatica PowerCenter is the finest data integration solution in today’s times.This is because-

    • It can communicate with any database due to its database being neutral
    • It is the most powerful data transformation tool
    • It helps to convert one application’s data to another’s format seamlessly.
  • Who should opt for the online Informatica course?

    • Mainframe and database professionals
    • Project Managers
    • SQL & ETL developers
    • Business Intelligence (BI) professionals
    • Informatica Administrators with experience in PowerCenter to an extent

    -are individuals who can easily opt and gain from this online certification training course.

  • What are the requirements to do this online certification training course?

    As such there are no particular pre-requisites, but if you have a sound working knowledge of SQL, it would prove to be helpful.

Projects

  • What are the system requirements for this course?

    Your system needs the following requirements for the training certification course-

    • Preferably RAM – 6GBor if you don’t have then 4GB will also suffice
    • Hard Disk Space – 15GB
    • OS – Windows Server Versions OR Windows Client versions like Windows 7, 8, 10 can also be used but you may face some issues during installation
    • Linux can also be used as installation of Informatica Server but the client software need to be installed in Windows only
    • Oracle Database – 10g/11g/12c
    • MS SQL Server.
  • How will I execute the Practicals?

    • Our experts will assist you to install the software in your system.

      The manual for installation in the Windows system will be provided with step by step execution along with screen shot.

    • You can set up your own Informatica environment in Google Cloud.
    • You will get a file to guide you with the step by step method for creating the compute engine as well as installation.
    • You can then access the machine from your desktop/laptop as and when required.

    Note: - Google offers trial version of cloud some specific days. Please read the conditions before using the services.

  • Best Informatica Online Training Case Studies

    Project 1- Bank of Baroda is currently having a series of banks throughout the country. They have the following

    pre-requisites:

    • Understand their business needs
    • Customer’s requirement in detail in an accurate manner.
    • Build up one Decision support system.
    • This should include some banking report on daily, weekly, monthly basis.

    The Bank already has managed their database in Oracle. The vendor needs to use their database to give an automatic reporting application for current and future needs.

    Some of the main limitations of the existing structure are:

    • Time consuming report development system
    • Creating a report requires manual effort
    • Outdated reporting systems as far as selection time is concerned
    • More chances of error
    • Multiple products for applications

    Project 2- Established in 2003, Target Mega Market is a leading retail and wholesale FMCG dealer. Currently they run profitable branches in Virginia, Texas and Pennsylvania. They plan to expand and foray into the exports and International Business for retail, exports and wholesale soon.

    Their major concern has been not having a well-organized computerized system to manage their daily operations. Tracking has become impossible as every state outlet has created their own system to manage their daily activities, leaving the company, on a whole disorganized. This has also led to mismanagement in accounts and evaluations. They need to a build a data system for tracking their sales and purchase every day.

    This is meant to enhance their decision making, streamline the current outlets, increase their sales and build a stable data warehouse for sales. The business requires a system that can forecast or predict their business sales.

    Your company has won the proposal for the creating ETL Processes to load data into their data warehouse in a daily, monthly, yearly and on-demand basis.

    Project 3- Bank of New York wants to advertise new set of credit cards and its related products. Any bank customer seeking any of these products will be able to submit their application through their website seamlessly. There are multiple levels of product approval for the application and if the applicant fulfills the eligibility criteria, he/she will be offered the product. On applicant acceptance of the product, the information will be sent so that the application can be fulfilled.

    Your task is to create a set of combined files from the source data the bank has for the utilization of Banks Analytics system.

    You must create a set of ETL processes as per the rules mentioned in the mapping document as handed over to you by your team lead.

    Project 4- Gander Mountain operates the largest network of electronic accessory and products, spread across 100 locations countrywide. With its headquarters in Texas, the client currently operates more than 1700 stores throughout the world as well. They have furthermore acquired quite a few brands in Canada and US to expand their business. This is, over a period of time, led to multiple data and information challenges. Right from coordination to multiple reporting tools to amalgamation of branches, etc. there has been a lot of challenge for the brand worldwide. Their costs of maintaining several data marts and training multiple teams were not manageable beyond a point.

    Their challenges increased as technically they were unable to keep up with the advancements and had to introduce multiple vendors to manage the system. ETL, Database and other reporting platforms were becoming more complex and difficult to handle.

    There was a close study carried out with input from various stakeholders and the key outcome from this study was to consolidate all the data marts into one single Integrated Data Warehouse (IDW).

    Outcome:

    • Information Accuracy
    • Analytics-Ready Data Warehouse Platform
    • Reduced batch time and early availability of information
    • Business continuity improvement
    • Cost savings with licensing cost elimination, Database Admin cost reduction as well as Reduced network resource usage
    • ETL and Warehouse operational costs
    • Faster integration of new brands
    • One team supporting and efficiently managing all brands and business units

    Informatica PowerCenter 10.X has been chosen as the ETL tool for the implementation of the ETL processes in the project

Curriculum

  • Data Warehousing Concepts

    • Data Warehouse
    • Data Mart
    • OLAP VS OLTP
    • Data Warehouse Architecture (Basic)
    • Data Warehouse Architecture (with a Staging Area)
    • Dimensional Modeling
    • Star Schema
    • Snowflake Schema
    • Dimension
    • Fact
    • Slowly Changing Dimension(Type 1,2 and3)
    • Hierarchy
    • Confirmed Dimension
    • Fact less Fact Table.
    • Summary / Aggregations table
    • Change Data capture
  • Power Center Components

    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
  • Informatica Concepts and Overview

    • Informatica Architecture.
    • Source Qualifier
    • Target Designer
    • Transformations
    • Mappings
    • Mapplets
    • Sessions
    • Tasks
  • Sources

    • Working with relational Sources
    • Working with Flat Files
  • Targets

    • Working with Relational Targets
    • Working with Flat file Targets
  • Transformations

    • Expression Transformation
    • Lookup Transformation
    • Sequence Generator Transformation
    • Filter Transformation
    • Joiner Transformation
    • Sorter Transformation
    • Procedural Transformation
    • Router Transformation
    • Aggregator Transformation
    • Update Strategy Transformation
    • Union Transformation
    • Rank Transformation
    • Transaction Control Transformation
    • Normalizer Transformation
    • Source Qualifier Transformation
    • Stored Procedure Transformation
    • XML Source Qualifier Transformation
    • Debugging Mappings
  • Power Center Transformation Language

    • Numeric functions
    • String Functions
    • Date Functions
    • Conversion Functions
    • Cleansing Functions
    • Aggregate Functions
    • User Defined Functions
  • ADVANCED INFORMATICA CONCEPTS

    • Unconnected lookup Transformation
    • Unconnected Stored Procedure to Create and Drop Index
    • Mapplet and Types of Mapplets
    • Defining Reusable Transformations.
    • User Defined Functions
    • Tasks And Types of Tasks
    • Worklet and Types of Worklets
    • Scheduling Work flow
    • Constraint Based Load Ordering
    • Target Load Plan
    • Types of Batch Processing
    • Link conditions
    • Mapping Parameters
    • Mapping Variables
    • Defining Session Parameters
    • Session Recovery
    • Difference Between Normal and Bulk Loading
    • Push Down Optimization
    • PMCMD Utility
    • PMREP Utility
    • Incremental Aggregation
  • TYPES Of LookUp Caches

    • Static LookUp Cache
    • Dynamic LookUp Cache
    • Persistence lookup Cache
    • Shared LookUp Cache
    • Sorter and Rank Cache
  • Task Types

    • Session
    • Command
    • EMAIL
    • Timer
    • Event Wait
    • Event Raise
    • Decision
    • Assignment
    • Control
    • Worklet
  • ETL Testing

    • UNIT Testing
    • System Integration testing
    • PERFORMANCE TESTING
    • ETL Performance Optimization techniques

FAQs

  • What If I miss a class?

    With great options to choose from, you now never have to miss a class. You can easily opt-

    • To view the recorded session of the class available
    • Attend the missed class in any other on-going live batch
  • Will I Get Placement Assistance?

    As part of our commitment, we guarantee you the best training course program under the guidance of some of the most distinguished instructors. We will be there to guide you through your projects and in your hunt for a good job by training you in interviews, however, please understand we are not into job placements and cannot assist you directly with your search in this department. We surely help you in building a great resume as well as share the important questions that may be asked during an interview, post training.

  • Can I attend a demo session before enrolling for the course?

    You have the option of going through a sample class recording to get an insight into the course as well as the quality of instructors. We have a limited number of seats to maintain the standard of quality of the class; hence, participating in a live class without enrolment is not possible.

  • What is the quality of the training instructors?

    All instructors are subject matter experts and have been practicing in the IT industry for nearly 10 to 12 years. They are additionally trained by us to ensure the quality of standard and give you a wholesome learning experience.

  • Where do I contact for further queries?

    You can call us at

Review

Kavitha

Hi, I am Kavitha. I have done my AWS course in AWA. The best institute for learning AWA and faculty is good. I feel it is very good online training for AWS course.

Sumanth

I have learned BigData and Hadoop course in AWA. Very well experienced trainer. Good online training institute. 24/7 support from institute.

Vinod

I have taken Python online training from AWA. Faculties are real time employees; they teach us in a professional way, they provide us the online material. We will have lab sessions also. If we miss the classes on a particular day we will get recording session of the missed classes.

Rahul

If you are looking for any IT training, this is the place for you. One of the best online training institutes. Trainers are very knowledgeable and professional. I have taken couple of courses here and am very much satisfied.

Sandeep

It was amazing experience to take INFORMATICA training with AWA. The trainer is very detailed from the beginning to the end and his ability of production grade concepts, presenting configuration in different scenarios makes you ready for the job with no doubt.

Get More info at +91 8919907969