Menu
  • 8096526187

ETL Testing Training

ETL Refers to “Extraction of Data from different Applications” developed and supported by different Vendors, Managed and operated by different persons hosted on different Technologies “into Staging Tables –Transform data from Staging Tables by applying a series of rules or Functions which may include Joining and Duplication of Data, Filter and Sort the Data using specific Attributes, Transposing Data, Make Business Calculations etc. To derive the data for loading into the Destination System, Usually the Data ware House is used for Business Intelligence & Reporting Issues. ETL basically standsfor (EXTRACT TRANSFORM LOAD) which simply implies the process where you extract data from Source Tables and Transform them in to the desired Format based on certain Rules and finally load them onto Target Tables. So ETL Testing implies, Testing this entire Process using a Tool or at Table Level with the help of Test Cases and Rules Mapping Document. With the help of SQL Queries’ we need to validate Data from Source to Target.

829 Voted
4.4/5

Attend Demo

Introduction

  • The Data in Data ware house system is loaded with an ETL (Extract,Transform,and Load)Tool. As the Name suggests it performs the following 3 operations:
  • Extracts the Data from your Transactional System which can be an Oracle,Microsoft or any other Relational Database.
  • Transforms the Data by performing the Data cleansing operations
  • Loads the Data into the OLAP Data warehouse.
  • You can also extract Data from Flat Files like Spread Sheets and CSV Files using an ETL Tool and Load it into OLAP Data warehouse for Data Analysis and Reporting

What are Career Opportunities?

ETL Testing / Data Warehouse Testing though is a niche area with in the Software Quality Industry it has gained much prominence in recent years.Currently 15,000 ETL Testing Job Positions are open for this exciting career PAN India.

 

Who are eligible to take ETl Testing Training?

  • Testers who want to get Job on ETL Testing, to get more Salary and also who want to get Job Quickly.
  • Any Bachelor Degree(B.Tech, Any Degree, M.Tech, MBA)

ETL Process

E- Extract the Data

It involves the extracting the Data from different heterogeneous data Sources.Data extraction from a Transcationl System varies as per the requirement and the ETL Tool in use.It is normally done by Running Scheduled Jobs in Off-Business hours like running jobs at night or over the weekend.

T-Transforming the Data

It involves Transforming the Data into a suitable Format that can be easily loaded into a DW System.Data Transformation involves applying Calculations,Joins and defining Primary and Foreign Keys on the Data. For example – if you want % of Total Revenue which is not in Database,you will apply % Formula in Transformation and Load the Data.Data Transformation also involves the Data correction and cleansing of Data, Removing incorrect Data,Incomplete Data Formation and Fixing Data errors.It also includes Data Integrity and Formatting Incompatible Data before Loading it into a DW System.

L-Loading the Data into a DW System

It involves loading the Data into a DW System for Analytical Reporting and Information.The Target System can be a simple Delimited Flat File or a Data warehouse.

Course Content

  • SQL Overview
  • About Database
  • Database
  • Operation
  • Table
  • Normalization
  • DBMS, RDBMS,
  • ORDBMS
  • Introduction to
  • SQL
  • About SQL
  • Connect using
  • Tools
  • Data Types
  • SQL Commands
  • SELECT Statement
  • Restricting and
  • Sorting
  • Data/Records
  • Wildcard Uses
  • Different Types of
  • Operators
  • Keywords
  • Dual Table
  • Pseduo Column
  • Release Format
  • Common Table
  • Expression
  • SQL Clauses
  • Operators
  • 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
  • Default Constraint
  • Check Constraint
  • Sub Query
  • Sub/Inner Query
  • Correlated Sub
  • Query
  • Nested Sub Query
  • Object
  • Index
  • Synonym
  • View
  • Tablespace
  • Set Operator
  • Union
  • Union All
  • Intersection
  • Minus
  • Built-in Functions
  • Aggregate
  • Functions
  • Character Function
  • String Functions
  • Case Manipulation
  • Functions
  • Date Functions
  • Analytical
  • Functions
  • Datawarehouse Fundamental
  • Datawarehouse Overview
  • DWH Characteristics and benifits
  • Data Mart
  • Database vs Data Warehouse
  • DWH Architecture
  • Datawarehouse Terminologies
  • Data Cleansing
  • Partitioning
  • Staging area
  • Metadata
  • OLTP, OLAP, ROLAP, MOLAP
  • Surrogate Key
  • Snapshot, View and Materialized View
  • Data Mining
  • Data Cube
  • Dimension Modeling
  • Facts and Dimensions
  • Hierarchies and Levels
  • Measures
  • DWH Schema
  • Star, Snow-flake and Galaxy Schema
  • ETL Overview
  • Process Flow of ETL
  • Types of Sources and Target
  • ETL Data Load types
  • Active vs Passive Transformation
  • Extraction Methods in ETL
  • Introduction to ETL Tool
  • 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
  • How to create ETL Test Case
  • Types of ETL Bugs/Defects
  • Database Testing vs ETL Testing
  • Responsibilies of ETL Tester
  • Compare Source and Trarget Data
  • OBIEE/BI/Report
  • Introduction to OBIEE
  • Business Intelligence Basics
  • Dashboard vs Report
  • Slice and Dice
  • Roll-up and Drill-down
  • Pivot
  • Report Terminologies
  • Report UI Usecase
  • ETL/Report Testing Documents
  • Business Requirement
  • Mapping Document
  • Calculation Logic Sheet
  • Dashboard/Report UI Design
  • Test Scenarios and Test Cases
  • Database/Backend Testing
  • What is Database/Backend Testing ?
  • How to do Backend Testing ?
  • Areas to cover in Database Testing
  • Database Testing
  • Database Testing Test Scenarios
  • Front-end vs Back-end Testing
  • Migration Testing
  • Overview of Data Migration
  • What is Migration Testing?
  • Types of Migration
  • Migration Testing Phases
  • Challenges in Data Migration Testing
  • Data Migration Testing Strategy
  • Application and Data Centric Testing
  • Types of Testing
  • Reasons caused for Data Centric
  • Testing on Store Procedure
  • What is Store Procedure?
  • Steps for testing Store Procedure
  • Benefits of Store Procedure
  • Disadvantages of Store Procedure
  • Store Procedure vs Function
  • Execute Procedure with Parameter
  • NoSQL Concept
  • What is NoSQL?
  • When to use SQL and NoSQL ?
  • SQL vs NoSQL
  • Differences between SQL and NoSQL
  • Informatica Power Center Tool Overview
  • Introduction to Informatica
  • How developers work on Power Center
  • Different components and uses
  • Tasks/Session
  • Mapping, Worklet, Workflow, Mapplet
  • Naming Conventions
  • Designer Component
  • Working with Sources and Targets
  • Working with Flat Files
  • Source and Target
  • Uses of Mapping Wizards
  • Workflow Manager Component
  • Uses of Workflow Wizard
  • Worklet Designer
  • Creating and Configuring Task
  • Link Workflow and Session
  • Validating Tasks and Workflows
  • Scheduling and Running Workflows
  • Workflow Monitor Component
  • Uses of Workflow Monitor
  • Working with Tasks and Workflows
  • Workflow and Task Status
  • Using Gantt Chart and Task Views
  • Session and Workflow Logs
  • Transformation
  • Source Qualifier
  • Transformation
  • Aggregator Transformation
  • Expression Transformation
  • Filter Transformation
  • Sorter Transformation
  • Sequence Generator Transformation
  • Normalizer Transformation
  • Router Transformation
  • Union Transformation
  • Rank Transformation
  • Joiner Transformation
  • Project Guidance
  • Real time Project Overview
  • Import and Export DB Data
  • Real Environment Used
  • Handling Challenging Tasks
  • Testing Entry/Exit Criteria
  • Interview Preparation
  • Resume Formats and Design
  • Technical FAQ discussion
  • Non-Technical Q&A
  • Roles and Responsibilities

we love them

what our students have to say

How real people said about Digital IT Training Hub Institute…

I have joined Digital IT Training Hub for ETL Testing course few months back.The trainer Mr Prakash is excellent in teaching the subject. I received all practical experience after attending the class. He shares his experience in real time based and fully practical way.I faced 3 interview and cleared in 2 Company in one attempt. I got offer letter from Accenture and Infosys. A good platform for job seekers, before joining this I was unable to clear the first round of an interview, and now I can.Irecommend to take a course under his guidance which will definitely help you in future.
Disha- Accenture, Mumbai
Disha
Excellent teaching in ETL Testing and Unix Shell Script. I am very much happy with the materials as well. No comparison with others.I think other will also agree with my opinion. No one will regret after joining Digital ITTraining Hub and after getting training from Prakash sir. He is so good in ETL concept, Test Scenario, Test Cases, SQL, Shell scripting and UNIX. All the materials also too good. It is superb and very fascinating. Training from him helps me to changed my self and now I can crack interview for any company and all credit goes to MrPrakash. This is the best institute for ETL Testing. The trainer Mr Prakash is very polite and has excellent subject knowledge. He teaches in very good manner with special way. He`s very flexible with the timings. He will be with you throughout the course and he is very good at heart too. A good quality coaching.
Rashmi-Infosys, Pune
Rashmi
Digital IT Training Hub is a wonderful institute and Mr Prakash is the trainer for ETL/Hadoop/DatabaseTesting, Python&UNIX Shell Script. I searched many institutes in Hyderabad and lost my time and money. One of my friend suggested Digital ITTraining Hub. Prakash sir teaches all real time scenarios with good explanation. Course fee is also reasonable. Also, all the materials provided also very good in quality. After attend 2-3 classes only people will be very happy. This place is excellent for learning ETL Testing and Unix Shell Script. Trainer Mr Prakash is very polite and is having very in-depth subject knowledge. Mr. Prakash is the best instructor. I thank him for such a wonderful training and support.
Ipsy- Sears Holding, Pune
Ipsy
It was one of the best learning experiences I had from Digital IT Training Hub. I am satisfied with the training given by Mr Prakash on Database Testing and ETL Testing concepts. The trainer was able to clear my all doubts regarding database and ETL process followed in the industry and provide real life examples. Overall experience is very good. Guidelines given by trainer were excellent. If you want to optimize your testing related skills, it’s my personal suggestion to join Digital IT Training Hub from trainer Mr Prakash. I placed in Infosys as a Test Analyst with good package.
Rasheed- Infosys
Rasheed
The training which provides here by Mr Prakash Sir is very qualitative, innovative and performance oriented. The training helps you to get in a very high professional growth. There are many things in him which we should learn and use. If I had a chance to rate him out of 10 I would rate him 20.Prakash Sir`s training really helped me a lot to enhance my skills. I even used to get the backup classes when I missed and he is having very good patience. If we are unable to catch the sentence used to play it and explained us even topics and lot more. Prakash was the best instructor I've ever I have taken training. His knowledge, professionalism and presentation skills are simply world class. He provide extremely helpful and informative course. Training materials are well organized and provided good case studies.I enjoyed a lot in learning and enjoying in job also.
Manoj- Syntel, Pune
Manoj
First, I would like to thank ETL Testing Trainer Mr Prakash of Digital IT Training Hub for his wonderful teaching. I have been working in USA for last 1 year in Manual Testing. I came to India for my vacation and I Joined the institute for ETL Testing under Mr Prakash. Now joined another Company in USA as ETL Tester and working without facing any issues. Also, Mr Prakash’s teaching style is excellent and his prepared materials are awesome. He is having very deep knowledge on Test scenarios, Test cases, Unix Shell Script, ETL Concepts and Advance SQL. I strongly recommend this institute. Trainer’s real time examples helped me a lot.Mr. Prakash even inform us about corporate world information, His simple teaching makes the concept clear, even videos help you a lot. As, he explain all the topic in depth so it helps me to crack many interviews. Also, after joining in my new company also, help me a lot in my project work.
Ajinkya- TIAA, Pune
Ajinkya
It was very fascinating training. It helped me to overcomeall my fear in ETL Testing.It enhanced my skills and strengthen withpractical knowledge and made me capable to face interviews.His training helps me to build my career. Prakash Sir teaches in a very depth in ETL and DatabaseTesting which is appreciable. For the First time I attend online class and I was in a doubt that whether it would be understandable or not, and how I will receive the material. But, after taking the training from Prakash Sir I am confident to say that it is very good as he was very cooperative in providing training. Also, he sent me all the materials by courier, which no one will do. Thank you again to the institute and Prakash Sir. It is a very good training institute for ETL testing and they are providing good materials, at reasonable prices and they are giving time to practice in institute. I am very much satisfied with his training and am sure that you will feel the same.
Yosef- Diyotta, Hyderabad
Yosef
I Joined Digital IT Training Hub for learning a Project knowledge and for a presentation in my company. Mr Prakash explained the project in such a good way that it helps me to give a presentation, and I received award for the same. Mr. Prakash is so good in ETL concept and in Practical knowledge as well. He cleared all the doubts that I had. I implemented the same in my project which helps me to finish my task easily and quickly. I gained lot of confidence. I have never seen such a trainer like Mr. Prakash. I can say of course he is Excellent. No one will regret after joining digital it training hub and after getting from Prakash sir.It helped me to understand the concepts.
SaraYasmeen- Diyotta, Hyderabad
SaraYasmeen
The training was clear and detailed. I like Mr Prakash style of teaching as the recurrent training. Every opportunity for the student to ask questions was provided. An extremely helpful and informative course. Training materials were well organized and provided good case studies. Instructor was extremely professional and pleasant to learn fromMr Prakash conduct the class in very professional manner. Mr Prakash set up by explaining what he was going to teach us, summarized, and proceeded to teach, providing relevant real life examples. Very good training institute for ETL testing courses. It helped me to understand the concepts.I have taken ETL testing training the way of explanation was awesome each and every concept explained with real time scenarios. The best place for ETL Testing.
Ankita- TCS, Pune
Ankita
I joined Digital IT Training Hub for ETL Testing and now after completing the course I am feeling very much comfortable to work. He has superior knowledge, experience and ability to deliver the material in a concise, clean manner and answer any confusion and questions with clarity and satisfaction to students.Trainer Prakash is a wonderful instructor and made the experience in learning ETL Testing. He always asked if there were any questions and made sure everyone understood the topics. He was very pleasant and easy to listen to. I learned a lot in this course. This Course help me to crack many interview and many challenges.
Subhashree- Altius Data Solution, Pune
Subhashree
Prakash sir having 15+ years of real time experience. He worked in abroad for more than 7+ years with multiple domain. He is fully talented by giving Tricky interview questions and he is also one of the interview panel board member in his Company. For ETL Testing and UNIX shell scripting very good faculty. No one will regret after joining the institute and getting training from Prakash Sir. I highly suggest to take a training from him who want to grow in their career. I've never completed a course like this before (remote instruction) and I cannot express how great the instructor was and the overall content of the material. I would definitely recommend this to join this institute. This course was very informative and interesting. The instructor Prakash, is very easy to communicate with and very interesting with real life examples of the course materials. I enjoy learning about this material to help me do my job.
Neha- IBM, Pune
Neha
I am very much satisfied with the training given by Prakash Sir. Also, I am sure that other will feel the same. He has very deep knowledge on test scenarios and test cases, and SQL. I think five stars won`t be enough for you sir. He`s very flexible with the timings. He will be with you throughout the course and he is very good at heart too.Very good training institute for ETL testing courses, teaching by Prakash Sir is too good, concepts are nicely explained. Trainer will teach with all the practical examples. It helped me to understand the concepts.I have taken ETL testing training the way of explanation was awesome each and every concept explained with real time scenarios. The best place for ETL testing in Hyderabad. SQL part explanation is very nice and easily understandable. If you are looking for a career in s/w testing then taking a training under Mr. Prakash Sir will be your destination
Vinod- TCS,Chennai
Vinod
Prakash sir having 15+ years in IT and worked in multiple domain. His training is excellent with full subject knowledge. For ETL Testing and UNIX shell scripting its no doubt that he is one of the excellent faculty in Hyderabad. No one will complain after joining the institute and getting training from Prakash Sir. I highly recommend to take training from him who want to learn in depth. This course was very informative and full interesting. The trainerPrakash is very easy to communicate with and very interesting with live examples. The course materials are awesome.
Shruti- 3K Technologies, Bangalore
Shruti

“What we learn with pleasure we never forget.”

- Alfred Mercier

Follow Us

© 2019 All Rights Reserved