ETL Tools Training

Offered byIntellipaat

ETL Tools Training
at
Intellipaat
Overview

Duration	146 hours
Total fee	₹62,643
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

ETL Tools Training
at
Intellipaat
Highlights

Earn a certificate after completion of the course
Job assistance facility available
Mock interview preparation
1 on 1 career mentoring sessions
Exclusive access to intellipaat job portal
Resume & linkedIn profile building

ETL Tools Training
at
Intellipaat
Course details

What are the course deliverables?

Introduction to ETL and its importance in data warehousing

Setting up and installation of various ETL tools

Optimizing ETL tools for best results based on specific job requirements

OLAP, ETL and OLTP systems

Data modeling and dimensional modeling

Working with star and snowflake schemas

Dimensions, measures and fact tables in data warehousing

Data types and performance tuning in ETL

SCD types and various methods of handling SCD data

Various types of data transformation techniques

Source qualifier transformation and mappings

More about this course

In this program students will gain proficiency in top ETL tools like Informatica, SSIS, OBIEE, Talend, DataStage and Pentaho

They will work on real-world projects in data warehousing, data integration, Hadoop connectivity, data modelling, SCD and data schema

This Intellipaat training is your one stop for mastering some of the best ETL tools available in the market today

ETL Tools Training
at
Intellipaat
Curriculum

Informatica

Data Warehousing and Cleansing Concepts
Informatica Installation and Configuration
Working with Active and Passive Transformation
Working with Expression Transformation

SSIS

What is BI?
ETL Overview
Working with Connection Managers
Data Transformations
Advance Data Transformation

OBIEE

Data Modeling Concepts
Business Intelligence Concepts
Understanding OLAP
Oracle Business Intelligence Suite
Oracle BI Repository

Talend For Hadoop

Getting started with Talend
Jobs
Overview of Schema and Aggregation
Connectivity with Data Source
Getting started with Routines/Functions

DataStage

Information Server
InfoSphere DataStage
DataStage Features
DataStage Job
Parallelism, Partitioning and Collecting
Job Stages of InfoSphere DataStage
Stage Editor

Pentaho

Introduction to Pentaho Tool
Data Architecture
Clustering in Pentaho
Data Transformation
Pentaho Flow
Deploying SCD
Type of Repository in Pentaho
Pentaho Repository & Report Designing