GUIDE ME

Become an Informatica expert. Join now to learn under an Informatica expert.

4.9 out of 5 based on 54789 votes
google4.2/5
Sulekha4.8/5
Urbonpro4.6/5
Just Dial4.3/5
Fb4.5/5

Course Duration

40 Hrs.

Live Project

2 Project

Certification Pass

Guaranteed

Training Format

Live Online /Self-Paced/Classroom

Watch Live Classes

Data Warehousing

Speciality

prof trained

300+

Professionals Trained
batch image

4+

Batches every month
country image

20+

Countries & Counting
corporate

100+

Corporate Served

CURRICULUM & PROJECTS

Informatica Certification Training

    Informatica training helps you to master in Power Centre ETL tool, data integration, and Data Warehousing. This course helps you clear the Informatica PowerCenter Developer Certification exam.

    • SQL – PL/SQL –Oracle
    • Unix – Basics of Shell Scripting
    • Interview Preparation
    • Dataware Housing Fundamentals
    • Introduction to Informatica
    • Informatica Designer -Introduction
    • Informatica Designer
    • Transformation
    • Informatica - Workflow Manager
    • Informatica Advanced Features
Get full course syllabus in your inbox

    SQL – PL/SQL –Oracle

    • DDL, DML, DCL (Select, Insert, Update, Delete, Rollback, Commit, Savepoint)
    • Primary Key, Foreign Key relationship,
    • Oracle commands and Functions used in Informatica.
    • Joins (Inner and Outer)
    • Self join
    • Subquery,
    • Corelated subquery,
    • Group by, Having, aggregate functions,
    • Delete duplicate records,
    • Create and drop indexes,
    • Constraints, Indexes
    • Views
    • SUBSTR and INSTR()
    • Merge
    • PL/SQL Basics -ORACLE
    • Stored Procedures,
    • Triggers
    • Functions
Get full course syllabus in your inbox

    Unix – Basics of Shell Scripting

    • What is UNIX
    • Looking into files,
    • Ownerships and Permissions
    • Creating, Moving, Renaming, and Deleting Files and Directories
    • Wildcards and Regular Expressions
    • Move to Another Location with cd
    • Change the Owner of a File or Directory
    • Creating New Directories Using mkdir
    • Moving, renaming files
    • Head & Tail
    • More and Cat
    • Counting Words and Lines Using wc
    • Filters and Pipings
    • Vi Editor
    • Shell Programming
    • Stream Editor – SED
    • Grep
    • Find
    • Connecting DB through Unix
    • Use of Unix in Informatica
    • Informatica Workflow scheduling through Unix
Get full course syllabus in your inbox

    Interview Preparation

    • Scenario based questions discussion - Everyday
    • FAQs
    • Telephonic/ Face to Face interview preparation
    • Live Project description / Architecture
    • Doubt Sessions
    • More than 500+ interview questions will be discussed during training sessions
Get full course syllabus in your inbox

    Dataware Housing Fundamentals

    • What is Database
    • What is Data Warehousing
    • Need of Data Warehouse
    • Data Warehouse Architecture
    • Introduction to OLTP, ETL and OLAP Systems
    • Difference between OLTP Database and DWH

    ETL Fundamentals

    • Data Extraction
    • Data Transformation
    • Data Loading
    • Data Mart
    • Metadata
    • Star Schema
    • Snow Flake Schema
    • Galaxy Schema
    • Facts
    • Types of Facts
    • Additive, Non-Additive, Semi-Additive Facts
    • Dimensions
    • Types of dimensions
    • Conformed, degenerate, Junk Dimensions
    • OLAP and Types of OLAPs
Get full course syllabus in your inbox

    Introduction to Informatica

    • Basic Definitions
    • Informatica Products
    • Informatica Architecture
    • Tools and their roles
    • Folders -sub Folders
    • Power Center I Power Malt
    • Introduction to Mapping designer
    • Introduction to Workflow Manager
    • Introduction to Workflow Monitor
    • Introduction to Repository Manager
Get full course syllabus in your inbox

    Informatica Designer -Introduction

    • Designer interfaces
    • Designer tools
    • Defining Sources
    • Database as a source
    • Flat Flies sources
    • Defining Targets
    • Importing from database
    • Creating a new target
    • Creating target database objects
    • Mapping Introduction
Get full course syllabus in your inbox

    Informatica Designer

    • Source Qualifier
    • Ports
    • Mapping -Table to Table
    • Mapping flat File to Table
    • Connected/Unconnected Transformations
    • Active and Passive Transformation
    • Source Qualifier Transformation
    • SQL Override-Source Qualifier Transformation
    • Mapping Source Qualifier as Filter
    • Source qualifier to join Data
Get full course syllabus in your inbox

    Active Transformations

    • Filter Transformation
    • Router Transformation
    • Aggregator Transformation
    • Joiner Transformation
    • Union Transformation
    • Sorter Transformation
    • Rank Transformation
    • Transaction Control Transformation
    • Update Strategy Transformation
    • Normalizer Transformation
    • Source Qualifier Transformation
    • SQL Transformation

    Passive Transformations

    • Expression Transformation
    • Sequence Generator Transformation
    • Stored Procedure Transformation
    • Look Up Transformation
    • Xml Source Qualifier Transformation

    Mapping Wizards

    Implementing Type-I, Type-II, Type-III

    Mappings

    Workflow Introduction

Get full course syllabus in your inbox

    Informatica - Workflow Manager

    • Workflow tools
    • Connections
    • Defining tasks
    • Command Task
    • Email Task
    • Session Task
    • Link Conditions
    • Event Wait & Event Raise
    • Setting Properties of Session Task
    • Creating Workflow
    • Starting Workflow
    • Monitoring Workflow
    • Incremental Aggregation
Get full course syllabus in your inbox

    Informatica Advanced Features

    • 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
    • Perisistance lookup Cache
    • Shared LookUp Cache
Get full course syllabus in your inbox

+ More Lessons

Course Design By

naswipro

Nasscom & Wipro

Course Offered By

croma-orange

Croma Campus

Real

star

Stories

success

inspiration

person

Abhishek

career upgrad

person

Upasana Singh

career upgrad

person

Shashank

career upgrad

person

Abhishek Rawat

career upgrad

hourglassCourse Duration

40 Hrs.
Know More...
Weekday1 Hr/Day
Weekend2 Hr/Day
Training ModeClassroom/Online
Flexible Batches For You
  • flexible-focus-icon

    05-Jul-2025*

  • Weekend
  • SAT - SUN
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    07-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    09-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-focus-icon

    05-Jul-2025*

  • Weekend
  • SAT - SUN
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    07-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
  • flexible-white-icon

    09-Jul-2025*

  • Weekday
  • MON - FRI
  • Mor | Aft | Eve - Slot
Course Price :
For Indian
30,000 27,000 10 % OFF, Save 3000
trainerExpires in: 00D:00H:00M:00S
Program fees are indicative only* Know more

SELF ASSESSMENT

Learn, Grow & Test your skill with Online Assessment Exam to
achieve your Certification Goals

right-selfassimage
Get exclusive
access to career resources
upon completion
Mock Session

You will get certificate after
completion of program

LMS Learning

You will get certificate after
completion of program

Career Support

You will get certificate after
completion of program

Showcase your Course Completion Certificate to Recruiters

  • checkgreenTraining Certificate is Govern By 12 Global Associations.
  • checkgreenTraining Certificate is Powered by “Wipro DICE ID”
  • checkgreenTraining Certificate is Powered by "Verifiable Skill Credentials"

in Collaboration with

dot-line
Certificate-new-file

Not Just Studying

We’re Doing Much More!

Empowering Learning Through Real Experiences and Innovation

Mock Interviews

Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team.Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.
How Croma Campus Mock Interview Works?

Not just learning –

we train you to get hired.

bag-box-form
Request A Call Back

Phone (For Voice Call):

‪+91-971 152 6942‬

WhatsApp (For Call & Chat):

+91-971 152 6942
          

Download Curriculum

Get a peek through the entire curriculum designed that ensures Placement Guidance

Course Design By

Course Offered By

Request Your Batch Now

Ready to streamline Your Process? Submit Your batch request today!

Students Placements & Reviews

speaker
Kapil Sharma
Kapil Sharma
speaker
Saurav Kumar
Saurav Kumar
speaker
Prayojakta
Prayojakta
speaker
Harikesh Panday
Harikesh Panday
speaker
Mohit-Tyagi
Mohit-Tyagi
speaker
Poonam-Sharma
Poonam-Sharma
View More arrowicon

FAQ's

You are not required to be from IT background or any prior experience as well.

Yes, all the training modules are updated as per the international standards and requirements.

The demand is increasing day by day and many companies are adopting this technique.

  • If you are not from an IT background and want to upgrade the skills.
  • If you are a graduate or a professional looking for high-income in leading companies.

You must have the basic knowledge of operating computers.

Career Assistancecareer assistance
  • - Build an Impressive Resume
  • - Get Tips from Trainer to Clear Interviews
  • - Attend Mock-Up Interviews with Experts
  • - Get Interviews & Get Hired

FOR VOICE SUPPORT

FOR WHATSAPP SUPPORT

sallerytrendicon

Get Latest Salary Trends

×

For Voice Call

+91-971 152 6942

For Whatsapp Call & Chat

+91-9711526942
1

Ask For
DEMO