Informatica Level 1 Developer Course – (Basic)

Informatica is the most widely used ETL tool in the industry today. ETL is the short form of Extract, Transform and Load. Informatica combines three processes which are:

• Extraction of data from the source file;
• Transformation of the required file type from the original type to the required type so that it can be accessed from the target source and;
• Loading the files into the target Database or Data Warehouse.

What does this course offer me?

• Data Warehousing Architecture
• ETL Process
• Dimensional Modeling
• Introduction to Informatica Power Center
• Informatica Power Center Architecture
• Powercenter Configuration And Client Tools Overview
• PowerCenter Designer Interface
• Create Relational and File Source and Target Objects
• Preview Source and Target Data using Informatica Objects
• Create Informatica Mapping
• Create Relational Connection
• Configure Session Properties
• Create a Session Task in Workflow Designer Tool
• Source Qualifier Transformation
• Informatica Joiner Transformation
• Informatica Filter Transformation
• Aggregator Transformation
• Sequence Generator Transformation
• Router Transformation
• Rank Transformation
• Sorter Transformation
• Union Transformation
• Expression Transformation
• Normalizer Transformation
• Workflow and Session
• Update Strategy Transformation
• Mapping Parameters & Variables
• Mapletts in Informatica
• User-Defined Functions
• Workflow Scheduler Options

Why does Informatica lead the ETL Market?

• Informatica enables Lean Integration Model, hence saving a lot of technology resources and cost;
• High “GO Live” success rate .Informatica claims the highest ration of successful deployment which it says is near 100%;
• Product rate of renewal and customer loyalty (94% and 92% ) is significantly higher than the industry average;
• Easy training and tool availability compared to other tools;
• Reduced training costs;
• Informatica is moderately expensive tool as compared to its competitors such as Ab Initio;
• Ease of use, Re-usability , Debugging, and Connectivity;
• Informatica comes with an Internal Scheduler unlike many other ETL tools where one needs to use a third party Scheduler;
• Informatica follows mainstream marketing strategy where it leverages paper work, press release, web forums and network community. This provides it leading edge and presence in the ETL space. Other ETL players pursue mostly direct client marketing.

Course Requirements

• You are self-driven and motivated to learn.
• Participation in this course requires consistently spend least 10 hours per week to your exercises.
• You can communicate in written and spoken English.
• You have access to a computer with a broadband connection, on which you’ll install a professional code/text editor.

Who is the target audience?

• Fresh Graduates.
• Students.
• Database Developers looking for exposure to an ETL Tool.
• ETL Developers looking to hone their skills in Informatica or wanting to apply for a Certification.
• Anyone from the IT or non-IT field who is looking for a career in the QA field.

Future Job Profiles

• Informatica Developer.
• Informatica Administrator.
• Enterprise Business Intelligence Developer.