ETL Testing Course in Pune

ETL Testing Course in Pune

Get Updates on Demo session,Syllabus and timings by filling up this form

Your Name (required)

Your Email (required)

Mobile number(Prefix "+91-")

Branch

Course

New Batches

Type Demo Session New Batch Location
Weekend 28-July-2018 2.00PM 29-July-2018 Pimple Saudagar
Weekend 28-July-2018 2.00PM 29-July-2018 Nal Stop
Weekend 28-July-2018 2.00PM 29-July-2018 Kharadi

About ETL Testing Course 

ETL means Extract, Transform and Load. In this process, Data is extracted from different course databases and collected in a Data warehouse. Here, this data is processed and transformed in the format of the datawarehouse schema after which it is loaded into a separate datawarehouse database. This database makes data available for generating business intelligence reports, drawing insightful data interpretations and making business decisions. ETL Testing Course will teach you the tools, tables used to test the entire ETL process with the help of test cases and rules to make sure that desired results have been achieved without any data loss. In this course you will also gain a deep understanding of ETL Tools, Technologies and various RDBMS & Data Warehouse concepts.

Pre-requisites

  •    Knowledge of Basic RDBMS & SQL Concepts

 Intended Audience

  • ETL& SQL Developers, Data Analysts
  • Testers who want to get a job in ETL Testing
  • Project Managers,  Mainframe Professionals
  • Data Analysts & Database Professionals 
  •  IT professionals interested in data driven work  

Our Courses

ETL Testing Course Syllabus

ETL and Datawarehousing:

• ETL Testing Introduction

• ETL Testing Lifecycle

• Understanding Data Warehousing

• Data Warehouse Architecture

• Database Concepts

• Difference betweenOLAP and OLTP

• ER Model & Dimensional Model

• Data Warehousing vs. Database Testing

• RDBMS concepts

• Integrity constraints

• Difference between database and datawarehouse testing

ETL Testing

• Data warehouse workflow

• Data Extraction, Transformation, Loading

• ETL testing scenarios

• ETL Tools

• Datawarehouse testing

• ETL Mapping

• Data Mismatch

• Data Loss Testing

• Table types

• Schema Types

• Slowly Changing Dimensions & Types

Data Validation

• Validate data for completeness, correctness and quality

• Testing scenarios

• Validation types

• Negative testing

• Transformation Rules

• Testing Techniques

• SQL Checks

• Database structure

• Using SQL for data checks

• Writing SQL scripts

Data Marts

• Use and Types of Data Marts

• Dependent DM

• Independent DM

Reports & Cube Testing

• Reporting

• Cube Testing

• Business Intelligence Testing

• Live project

ETL Testing Course Features

 

One Stop Solution!

   Ability to attend missed sessions

    Complete documentation

   Resume preparation

   Certification preparation.

   Interview preparation

   Placement assistance

Gallery

More  

"What our customers say"

Testimonials

Social Reviews- (122 Votes, Average:- 4.5 out of 5)

 Google-Reviews

Justdial-Pimple Sudagar

etlhive-sulekha-pimplesaudagar

etlhive-yet5-pimple saudagar

top
ETLHIVE is a Trademark of Itelligence Infotech Pvt Ltd.   *PMP®, PMBOK, PMI, PgMP, CAPM, PMI-RMP, and PMI-ACP are registered trademarks of the Project Management Institute, Inc. *ITIL®, IT Infrastructure Library, Swirl Logo, Prince2 are registered trademarks of AXELOS Limited.
21st July- Demo Session - P.Saudagar - Hadoop : 2.00 pm | Data science : 2 pm | Abinitio : 11 am | Informatica : 1.30 pm | Java : 9 am | Selenium : 9 am | Angular JS : 5 pm | Mean Stack : 5 pm| Nal Stop - Hadoop : 5.30 pm | Python : 11 am | Kharadi - Hadoop : 12 pm | Angular JS : 2.15 pm | Python : 11.30 am | Tableau 4.30 pm | Angular JS : 4.30 pm | Vashi(Mumbai) : Hadoop : 11 am | Data Science : 1 pm | Java : 4 pm | Blockchain : 4 pm