Facebook Recommendations

Training Details

Course Duration: 50-55 hours Training + Assignments + Actual Project Based Case Studies

Training Materials: All attendees will receive,

  • Assignment after each module, Video recording of every session
  • Notes and study material for examples covered.
  • Access to the Training Blog & Repository of Materials


  • College Degree from any University.
  • SQL Knowledge preferred but not Mandatory.

Training Format:

This course is delivered as a highly interactive session, with extensive live examples. This course is Live Instructor led Online training delivered using Cisco Webex Meeting center Web and Audio Conferencing tool.

Timing: Weekdays and Weekends after work hours.

Training Highlights

  • Focus on Hands on training
  • 30-35 hours of Assignments, Live Case Studies
  • Video Recordings of sessions provided
  • Demonstration of Concepts using different tools
  • One Problem Statement discussed across the Whole training program
  • Informatica Certification Guidance
  • Resume prep, Interview Questions provided
  • Introduction to Data Warehousing, Infomatica Designer
  • Understand the Transformation, Mapping and Qualifier
  • Informatica Advanced Features

Data Science Training Roadmap

How are we Different from other Training Institutes?

Role-Specific Training – Traditional training focuses on an overall business process, without regard for the individual’s role. By contrast, Zaran Tech’s series of role-based courses delivers in-depth training on a specific role within the business process.

Hands-on Mentoring – Our expert trainer’s work side-by-side with each trainee and teach proven discipline and techniques for successful delivery. Mentoring is “hands-on” as part of actual projects to gain real-time experience.

Real-time Project Experience – Comprehension of practical skills is both reinforced and demonstrated in our training programs by completing Case studies of actual projects.

Certification Exams –Our trainers are all certified and provide expert industry level guidance to certification exams with tips and tricks to guarantee consistency of skills and practices for a successful completion of certification.

Ongoing Education – Zaran Tech continues to offer new courses so you can keep up-to-date on latest technologies and best practices.

After reviewing your goals, and assessing your current IT skills capability, ZaranTech will tailor an after-the-training program and placement plan that will meet your needs in successful placement. This includes Resume preparation assistance, Mock interviews (technical and project based), Soft Skills and On-the-job support.

Modules Covered in this Training

In this training, attendees learn:

Module 1. Introduction to Informatica
Module 2. Introduction to Data Warehousing
Module 3. Configuration
Module 4. Introduction to Informatica Designer
Module 5. Transformation
Module 6. Mapping
Module 7. Qualifier
Module 8. Workflow Manager
Module 9. Informatica Advanced Features

Attendees also learn:

  • Resume Preparation Guidelines and Tips
  • Mock Interviews and Interview Preparation Tips

Topics Covered

Informatica Introduction

  • Overview
  • Basic Definitions
  • Informatica products
  • Informatica Architecture
  • Folders-Sub folders
  • ETL Tools and their roles
  • ETL information power center / Power mart

Introduction to Data Warehousing

  • Dataware housing (what is Dataware housing /Why Datawarehousing/How Datawarehousing)
  • Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  • Metadata
  • Normalization
  • Dimentinal Table
  • Types Of Dim Tables
  • Fact Table
  • Types of Fact Tables
  • OLTP (OnLine Transaction Processing)
  • OLAP (Online Analysis And Processing)
  • Advantages of OLAP
  • Characteristics of OLTP
  • Architecture of Data Warehouse
  • Characteristics of Data Warehouse
  • Different Methodologies of DWH


  • Informatica configuration
  • Instigation Services
  • ETL Folder
  • ETL Job Filz

Introduction to Informatica Designer

  • Introduction to Designer
  • Logon to Designer
  • Designer interfaces
  • Designer Tools
  • Defining Sources
  • Database as a source
  • Flat File sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects


  • Aggregate Transformation
  • Shorter Transformation
  • Active and Passive Transformations
  • How Sequencer work and Uses of Sequencer Transformation
  • Filter Transformation
  • Lookup transformation
  • Connected lookup
  • Unconnected lookup
  • Joiner Transformation
  • Filter Transformation
  • Ranking Transformation
  • Router Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Stored Procedure Transformation(Connected and Unconnected)
  • Union Transformation
  • XML Transformation


  • Mapping Introduction
  • Ports
  • Mapping – Table to Table
  • Mapping Flat File to Table
  • Mapping Wizards
  • Implementing Type-I,Type-II,Type-III Mappings


  • Source Qualifier Transformation
  • SQL override in source qualifier transformation
  • Source qualifier transformation joins concept
  • Source qualifier transformation on Relational Databases
  • Source qualifier transformation on File systems
  • Source qualifier transformation filter concepts
  • Difference Between SQL Override, Other Options
  • Source Qualifier to join Data
  • Source Qualifier Transformation Performance Tunning
  • Pre SQL and Post in Source Qualifier Transformation

Workflow Manager

  • Workflow Introduction
  • Tasks
  • Workflow tools
  • Connections
  • Defining tasks
  • Command Tasks
  • Email Task
  • Session Task
  • Link Conditions
  • Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow

Informatica Advanced Features

  • Incremental Aggregation
  • Mapplet Implementation
  • Target Load Plan
  • Constraint Based Loading
  • Mapping Variable
  • Session Parameters
  • Link Conditions
  • Reusable Transformation
  • Task and Types of Tasks
  • Work let and Types of work lets
  • Scheduling Workflow
  • Control flow using Command task and event wait task
  • Incremental Loading

About Trainer Vijay:

  • Have the experience of more than 10+ Years of consulting experience in Oracle Database, Oracle Forms, Oracle Financials, Informatica.
  • Experience of Working in USA and India.
  • Have the experience of working in several projects in Multi National Companies.
  • Involved in the Implementation of Enterprise Data Warehouse and Data Mart Projects.
  • Have experience of 10+ Years in training in both Class Room and Online Training on DW Concepts, Informatica.
  • Strong background in Training. Has trained 5000 + students.

CASE STUDY # 1 – “Healthcare System”

Healthcare System Application:

As the Product Manager for Inner Expressions you are asked to provide one of your largest clients with additional features in the EMR ( Electronic Medical Records Management) System. The client has requested an integrated Referral Management System that tracks patients from Primary care into the Specialist departments. Appointments are created by either the Primary Care Physicians themselves or other clinical staff like Nurse Practitioners or Clinical Assistants. Each appointment must go through the appropriate checks including checking if the patient has an active insurance with the client, whether the insurance program covers the condition of the patient, patient’s preference for location and timings and availability of the Specialist doctor.

Some appointments may have to be reviewed by the Specialists themselves before they can be approved, the administrator of the facility (hospital) must have the ability to choose by appointment type to either make it directly bookable by the Primary Care Staff or as a type that requires review by the specialist. The system should also allow the Primary Care Staff and specialists departments to exchange notes and comments about a particular appointment. If the specialist department requests tests or reports as mandatory for the appointment, the system must ensure that the patient has these available on the date of the appointment.

The system shall also allow users to track the status of patients’ appts & must store the entire clinical history of each patient. This will be used by the hospital for two main purposes; the specialist and the primary care providers will have access to the patients complete medical history before the patient walks in for the appt and hence allowing for better patient care, the Hospital also stores this data in a general data warehouse ( without Protected Health Information) to do analytics on it and come up with local disease management programs for the area. This is aligned with the Hospitals mission of providing top quality preventive medical care.

The Hospital sets about 300 appointments per day and must support about 50 users at the same time. The existing EMR system is based on Java and an Oracle database system.


  • Identify Actors, Use Cases, Relationships,
  • Draw Use Case Diagrams
  • Identify Ideal, Alternate and Exception Flows
  • Write a Business Requirements Document

CASE STUDY # 2 – “Asset Management System”

Asset Management Application:

An e Examination system is also known as (e-Pariksha/ Online Examination Scheduler), an Intelligent Web Application which automates the process of pre examination scheduling of Any Academic Institutions, Universities, Colleges and School. This automations primary scope is to save nature by saving tons of paper involved in conducting the examination. All examination communications are done via email management between student and Academia. Usually any examination would start with Exam Registrations, which is connected to Subject Creation, Exam Room Management , Room Allotment, Examination Hall Dairy, and Absentees Information (Variety of Reports) – Required by UniversityThis WebApp edges two sides of Client side and Server side Application. Client side enables student community to fill up their examination registration form online via internet and also they have privileges to check out their examination details like (Day of Start, Complete Time Table, Day-wise Exam Details and Day seating details of the candidate- like room name, seating number subject, date and time. The Server side involves the processing of each candidate exam registration form into workflow like, Subject Loader, Room Management, Seating Manager, Room Allotment, Room Dairies, Absentee Marking, and Rich Crystal Reports to meet various needs of Data set.The WebApp Admin records new chattel into database, deletes archaic ones, and revises any information related to examination. “User”. All users are known to the system by their USN, ID and their The asset management system keeps track of a number of assets that can be borrowed, their ownership, their availability, their current location, the current borrower and the asset history. Assets include books, software, computers, and peripherals. Assets are entered in the database when acquired, deleted from the database when disposed. The availability is updated whenever it is borrowed or returned. When a borrower fails to return an asset on time, the asset management system sends a reminder to the borrower and informs the asset owner.

The administrator enters new assets in the database, deletes obsolete ones, and updates any information related to assets. The borrower search for assets in the database to determine their availability and borrows and returns assets. The asset owner loans assets to borrowers. Each system has exactly one administrator, one or more asset owners, and one or more borrowers. When referring to any of the above actor, we use the term “user”. All users are known to the system by their name and their email address. The system may keep track of other attributes such as the owner’s telephone number, title, address, and position in the organization.

The system should support at least 200 borrowers and 2000 assets. The system should be extensible to other types of assets. The system should checkpoint the state of the database every day such that it can be recovered in case of data loss. Owners and the administrator are authenticated using a user/password combination. Actors interact with the system via a web browser capable of rendering HTML and HTTP without support for JavaScript and Java.

The persistent storage is realized using an SQL database. The business logic is realized using the WebObjects runtime system. The system includes:


  • Identify Actors, Use Cases, Relationships,
  • Draw Use Case Diagrams
  • Identify Ideal, Alternate and Exception Flows
  • Write a Business Requirements Document


Social Networking, Cruise Management System, Collegiate Sporting system

How do I get started with Informatica Certification?

– Logon to
– Download the materials for certification preparation.
– Create your account at
– Then as per your availability Schedule your exam.

What is the price of the exams?

– The exam for Specialist and the Velocity Expert exam have three training units. These units are of $80 each and total of $240 USD.

How many questions are there for the exam?

– All Informatica Certified Specialist exams have 70 multiple choice with 90 minutes duration and passing score is 70 percent.
– All Velocity Best Practices and Implementation Methodology exams have 40 multiple choice with 60 minutes duration and passing score is 70 percent.

Technical Requirements to take an Online training with ZaranTech

Technical Requirements for ZaranTech Online Classes:

  • Operating System: Windows XP or newer
  • Browser: Internet Explorer 6.x or newer
  • CPU: P350 MHz, recommended P500+ MHz
  • Memory: 128 MB, recommended 256+ MB RAM
  • Free Disk Space: 40 MB, recommended 200+ MB for content and recordings
  • Internet Connection: 28.8 Kbps, recommended 128+ Kbps
  • Monitor: 16 bit colors (high color)
  • Other: Sound card, microphone, and speakers OR headset with microphone

What is the Difference between Live training and Video training?

These Videos here will help you understand the difference,
VIDEO – What is Instructor led LIVE Training –
VIDEO – What is Instructor led VIDEO Training –

Benefits of online training as compared to classroom training

Online Training Benefits
A constantly shifting and changing IT market requires IT professionals to do more with less, making use of new tools and solutions to move forward. Investment in learning and development enables growth in our changing information technology marketplace, giving you the knowledge and skills to act, behave, and perform your job differently. Instructor-led Online training can provide the learning solutions you need in a format that is cost-effective and convenient bringing the interactivity, expertise, and diverse curriculum of our traditional courses to your home or office utilizing state-of-the-art technology. This method of learning allows for live interaction with the trainer and fellow students, without the cost of travel or lodging expenses. To accommodate the demanding schedules of professionals that is trying to do more with less.

Some of the major benefits are :

  1. Full Interactivity –
    Two-way voice over internet and web-conferencing using Cisco WebEx Meeting Center tool. This tool enables participants to ask questions and collaborate with each other in an online virtual space and enables the online trainer to answer questions, take simulations, and receive answers instantaneously. Every trainee can view the trainers desktop and vice versa.
  2. Cost Savings and Convenience –
    Courses can be completed from home, the office, or wherever the Internet is accessible. There is no need to travel to a specific location to attend a training program. Less overhead cost for the company and the savings is passed on to the trainees. Shorter course schedules mean that projects don’t have to be put on hold while participants train (for corporations).
  3. Never Miss a Session –
    With online training, you can receive archived video recorded sessions to all enrollees and the streaming video recording links are posted on the Training blog after each session. Participants may view these sessions to review sessions post-class or make up a missed class as needed. Accesses to Video Recordings are available after the training end thus making it easy for you to review after training ends.
  4. Location Independent –
    You may join for an online instructor-led course from any part of the world without having to travel. Trainees can attend from USA, Canada, New Zealand, UK, Australia, India and many other countries around the world.
  5. Affordable –
    Classroom sessions are expensive. You pay for Hotel, Food, Travel plus Course Fees. All those overhead costs quickly add up to more than 5,000 dollars. Online training programs costs less and is a fraction of that cost of classroom training.
  6. Career Focused –
    The online IT training courses match the tasks, assignments or projects you perform for employers on the job guaranteeing that the new skills you gain after training are immediately relevant to your career or employer.
  7. Shorter Sessions –
    By providing shorter session duration and then providing assignments, gives the trainees time to understand the concepts and practice from the assignments and be prepared for the next session. Online training sessions are each 2-3 hrs long and only cover 10hrs per week. Classes are scheduled 2-3 days apart giving you time to practice.
  8. Computer-Aided Simulation Learning –

    A growing number of Online Training courses are utilizing computer-aided simulation. This feature allows you to learn by making critical decisions in a realistic and safe “virtual” business setting. The consequences of your actions can be comprehended immediately. It is a highly-effective method for realizing the potential short- and long-term benefits (or dangers) of specific actions and decisions. The lessons learned using simulation are entrenched in your mind and can be applied to your role immediately.

  9. Minimum Technical Requirements:
    • Operating System: Windows XP or newer
    • Browser: Internet Explorer 6.x or newer
    • CPU: P350 MHz, recommended P500+ MHz
    • Memory: 128 MB, recommended 256+ MB RAM
    • Free Disk Space: 40 MB, recommended 200+ MB for content and recordings
    • Internet Connection: 28.8 Kbps, recommended 128+ Kbps
    • Monitor: 16 bit colors (high color)
    • Others: Sound card, microphone, and speakers OR headset with microphone

How soon after I Enroll would I get access to the Training Program and Content?

Right after you have Enrolled, we will send you an Email to your Gmail id with a Video on How To login to the training blog and get access to the training program and content.

What are the pre-requisites of taking this training?

– The participants should have at least basic knowledge of Java.
– Any experience of Linux environment will be very helpful.

Who are the instructors and what are their qualifications?

All our instructors are Senior Consultants themselves with a minimum of 10 years of real-time experience in their respective fields. Each trainer has also trained more than 100 students in the individual and/or corporate training programs.

How will be the practicals/assignments done?

Practicals/assignments will be done using the training blog. Instructions will be sent after you enroll.

When are the classes held and How many hours effort would I need to put in every day/week?

Online Live sessions are held weekdays evening CST (Central Standard Time GMT-6) or on Weekends. The schedule is posted for each batch on the website. You have to put in a effort of 8-10 hrs per week going thru the videos once again and completing your assignments.

What if I miss a class?

We Video record every Live session and after the session is complete, we will post the Video recording of that session in the blog. You will have access to these Video recordings for 6 months from the date you start your training. Material access will be provided using Google Drive Cloud for lifetime.

How can I request for a support session?

You can do that by posting a question on the training blog.

What If I have queries after I complete this course?

You can post those questions on the training blog.

Will I get 24*7 Support ?

You will get 24*7 accesss to the blog to post your questions. Trainers will answer your questions within 24 hrs of time. Normally they answer very frequently, like about 1-2 hrs. You can also approach your training coordinator for the same.

Can I get the recorded sessions of a class from some other batches before attending a live class?

Yes, you can. Or you can see our Youtube page for previous batch session recordings.

How will I get the recorded sessions?

It will be provided to you through the trainng blog.

How can I download the class videos?

You wont be able to download any videos. They are available for you to View using the training blog 24*7.

Is the course material accessible to the students even after the course training finishes?


Do you provide Placements as well

We are infact, a Consulting company which provides training so we are mainly looking for trainees who are looking for Placement after training.
After the Training Process explained (Video):
Our 6-step training to placement process (Video):

How can I complete the course in a shorter Duration?

Enroll to our Self paced video training.
Video Explanation – What is Instructor led VIDEO Training –

Do you provide any Certification? If yes, what is the Certification process?

We provide Certification guidance at the end of each course. You will also receive a “Certificate of Completion” from ZaranTech at the end of the course.

Are these classes conducted via LIVE video streaming?

We have both the options available

What internet speed is required to attend the LIVE classes?

1Mbps of internet speed is recommended to attend the LIVE classes. However, we have seen people attending the classes from a much slower internet.

What are the payment options?

We accept Credit Cards, Paypal, Bank payments from anywhere in USA, Money orders, International Wire transfer, ACH transfers, Chase Quickpay, Bank of America transfers, Wellsfargo Surepay. All the payments details are mentioned on the Enrollment page.

What if I have more queries?

Call the number listed on the Course Details page of our website.