Details
We provide ETL Testing Training in Pune & Informatica training in Pune. ETL stands for Extract, Transform and Load. An ETL tool extracts the data from different RDBMS source systems, transforms the data like applying calculations, concatenate, etc. and then
load the data to Data Warehouse system. The data is loaded in the Data Warehouse system in the form of dimension and fact tables. Our ETL Testing Course gives you insights about the tools and tables used to test the whole ETL process.
Our ETL Testing Trainers are industry professionals and certified ETL experts working in the industry from past 5+ years. Our trainers provide hands on real time ETL Testing Projects thereby imparting a thorough knowledge to the students and help them to achieve
their career goals. Our main focus is to provide individual training and corporate training in Data Warehouse using ETL Tool Informatica. Join us Build your career in Data Warehousing (DWH) as a real time professional.
- Trainers from Industry Experts
- Hands on Experience on One Live Project.
- 100 % Placement Assistance
- Resume Preparation
- Interview Preparation
- Missed Sessions Covered
- Multiple Flexible Batches
- Practice Course Material
- Knowledge of Manual Testing and DBMS/SQL is advantageous.
DURATION : 36 Hours
- Data Analysts
- Testers who want to get a job in ETL Testing
- Project Managers,Database Professionals
- IT professionals interested in data driven work
Outline
- Database/SQL
- RDBMS Concepts
- Data Models
- Entity Relationship Model
- Normalization
- DBMS, RDBMS, ORDBMS
- SQL Overview
- Introduction to SQL
- Data types
- SELECT Statement
- Operators
- Pseudo Column
- SQL Statements
- Data Definition Language (DDL)
- Data Manipulation Language (DML)
- Transaction Control Language (TCL)
- Data Control language (DCL)
- Join
- Inner/Equi Join
- Non-Equi/Cross Join
- Self Join
- Outer Join
- Constraints
- Primary Key Constraint
- Foreign Key Constraint
- Unique Key Constraint
- Not Null Constraint
- Check Constraint
- Set Operator
- Union
- Union All
- Intersection
- Minus
- Sub Query
- Sub/Inner Query
- Correlated Sub Query
- Object
- Index
- Synonym
- View
- Built-in Functions
- Aggregate Functions
- Character Function
- String Functions
- Case Manipulation Functions
- Date Functions
- Analytical Functions
- Datawarehousing/ETL
- Datawarehousing Fundamental
- Datawarehousing Overview
- DWH Characteristics
- Types of Datawarehousing
- Data Mart
- Database vs Data Warehouse
- Data Mart vs Data Warehouse
- Data Warehouse benefits
- DWH Architecture
- Datawarehousing Terminologies
- Data Cleansing, Partitioning
- Staging area, Metadata
- OLTP, OLAP, ROLAP, MOLAP
- Surrogate Key
- Snapshot, View and Materialized View
- Meta Data, Data Mining& Data Cube
- Dimension Modeling
- Facts and Dimensions
- Hierarchies and Levels
- Measures & DWH Schema Schema
- Additive, Semi Additive, Non Additive Fact/Measure
- ETL Overview
- Process Flow of ETL
- Types of Sources and Target
- ETL Data Load types
- Active vs Passive transformation
- Extraction Methods in ETL
- Tracing Level
- Types of Data used for ETL Process
- Slowly Changing Dimension
- What is Slowly Changing Dimension?
- SCD Types : Type-1, Type-2, Type-3
- ETL Testing Process
- Categories of ETL Testing
- ETL Test Scenarios and Test Cases
- Types of ETL Bugs/Defects
- Responsibly of ETL Tester
- OBIEE/BI Overview
- Introduction to OBIEE
- Business Intelligence Basics
- Overview of Reports
- Slice and Dice
- Roll-up and Drill-down& Pivot
- Informatica Power Center Tool
- Informatica Tool Overview
- Introduction to Informatica
- How developers work on Power Center
- Different components of Power Center and uses
- Tasks performed in different Components
- Mapping, Session, Worklet, Workflow, Mapplet
- Naming Conventions
- Designer Component
- Working with Sources
- Working with Flat Files
- Working with Targets
- Data Transformation Source and Target
- Mapping Parameters and Variables
- Uses of Mapping
- Workflow Manager Component
- Workflow Manager Overview
- Workflow Designer
- Task Developer
- Worklet Designer
- Creating a Task
- Configuring Task
- Workflow links
- Validating Tasks,Workflows
- Scheduling and Running Workflows
- Workflow Monitor Component
- Workflow Monitor Overview
- Using Workflow Monitor
- Working with Tasks and Workflows
- Workflow and Task Status
- Using Gantt Chart and Task Views
- Session and Workflow Logs
- Transformation
- How to use Transformations
- Aggregator Transformation
- Expression Transformation
- Filter Transformation
- Router Transformation
- Union Transformation
- Rank Transformation
- Sorter Transformation
- Joiner Transformation
- UNIX/LINUX
- Overview of UNIX Operating System
- Basics of Unix/Linux
- Useful Commands
- Command Manuals
- Regular Expressions
- Filter
- File Attributes
- Job Scheduling
- Archive/Compress File
- Editor : vi, sed
- Processes
- File copy/transfer in UNIX Server
3RI Technologies is an ISO 9001:2015 certified training center in Pune, providing software courses to students and IT professionals. Established in 2010, our focus has always been to deliver the industry level trainings to students and get them placed in the industry.
Our highly experienced trainers are professionals working in the IT industry and are committed to help students and professionals to develop their skills. Being a renowned leader in the training industry, 3RI technologies has been delivering best classroom trainings on various skillsets like Selenium, Hadoop , SAP, AWS, DevOps,Java and other programming languages as well. We also deliver corporate trainings as per your customized requirements. Having 2 training institutes in Pune, Pimple Saudagar and Deccan, our classrooms are well equipped providing high end infrastructure to students.
Related Courses
