ETL Testing Training in Pune

• ETL Testing Training with 100% placement assistance
• 767 testers placed in 400 companies in last 5 years
• Real time expert trainers
• Industry oriented training with corporate case studies
• Free Aptitude classes & Mock interviews

Extract, transform, Load (ETL) is a process of integration that merges data from different data source platforms into a single unit of data store that can later be loaded in data warehouses. ETL basically refers to, “Extraction of data from different applications” developed & supported by different vendors, managed & operated by different persons hosted on different technologies. Iconic offers the best ETL Testing course in Pune with approachable teaching methods. Our ETL trainers are qualified and have been consistent in achieving quality results throughout the training process. Our extensive training is inclusive of the core conceptual of ETL like Joining and Deduplication 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-Loading the data into the destination system, usually the data warehouse, which could further be used for business intelligence & reporting purposes. The ETL course we offer is set to benefit beginners as well as advanced professionals to help promote their skills and efficiency. The ETL Testing Training in Pune offered by Iconic provides the best training along with a certification and placement assistance.

ETL Testing Training Curriculum
Data Warehousing Concepts

Data ware house architecture
Datamart
DW Schema – Star Schema – Snow Flake Schema
Objects in DWH – Dimension table – Fact table
SCD(SLOWLY CHANGING DIMENSIONS) – SCD TYPE 1 – SCD TYPE 2 – SCD TYPE 3
Differences between OLTP and OLAP SDLC And STLC

Agile Methodologies
Waterfall Model
SQL (Structured Query Language)

– DDL (Data definition language)

– DML (Data manipulation language)

– DQL (Data query language)

Data Ware Housing Life Cycle w.t.r ETL ETL TESTING TYPES

Data migration testing
Sample testing and Scenario Testing
BATCH JOB Testing
– Inbound Testing

– OutBound Testing

ETL TESTING TASKS

Spec analysis
Designing Testcases
ETL Test scripts preparation
Environment Preparation
Test Execution
Peer Reviews of QA deliverables
ETL Testing validations

Structure validation
Count validation
TRANSFORMATION Logic Check
Data validation
MINUS Query
Duplicate Check
Error logic Check
RI Validation( Referential integrity constraint check)
Scenario testing
Derived checks
Default values check
Data Integrity check
Basic checks at ETL Phases

Extraction phase testing
Transformation phase testing
Loading phase testing
Testing for SCD

SCD Type1 Testing
SCD Type2
Testing Overview of ETL Tool (Data stage) CODE PROMOTION PROCESS

Dev to QA
QA to UAT
UAT to Production
CONTROL M ( Scheduling tool slides) UNIX

Following are the required skills for ETL testing
• PL/SQL Skills
• Manual Testing Skills
• ETL/Data Warehousing Knowledge

The ETL Testing course would be ideal for the following candidates –
• ETL testers
• BI/ETL developers
• Mainframe professionals
• IT professionals
• SQL developer
• Database professionals

• Thorough understanding of ETL and its concepts.
• Training in DDL,DML,DQL language.
• Hand on experience with ETL testing types.
• Preparing and executing test scripts.
• Implement workflows.
Career opportunities after taking the course
• ETL Automation test engineer
• ETL Testing quality engineer
• Data quality analyst
• ETL Tester
• ETL testing Application lead
• ETL Developer