ETL Testing Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews
5/5

Duration :  30 Days

About Course

Dell Boomi understands the need for a quality training curriculum along with real-time implementation exposure as it forms the very essence of your future career in Boomi Certification. Our well-structured online training course in Dell Boomi Training extensively covers all the core aspects of classes with an emphasis on live scenarios. Access to expert trainers and instructor-led training sessions ensures that you can easily clear your doubts and get the exact guidance that is expected from Dell Boomi Online Training sessions.

Upcoming Live Online Classes

 
10-SEP-2022 TO 05-DEC-2022

 08:00 AM

 
10-SEP-2022 TO 05-DEC-2022

 08:00 AM

Can't Find Your Convenient Batch?

ETL Testing Training Course Syllabus

  • Why Data Warehouse
  • What is Data Warehouse?
  • OLTP VS OLAP
  • Data Warehouse Architecture
    • Importance of Staging
  • Dimension Modeling
    • Type of dimensions
    • FACTS
    • Schemas
      • Star
      • Snowflake
      • Galaxy
  • Surrogate Keys
  • DDL
  • DML
  • Joins
  • WHERE, Group By, Having
  • Operators
  • Except, UNION, UNION ALL
  • Rank, Row_Number functions
  • String functions
  • Date functions
  • Practices queries on SQL SERVER 2008 R2
  • QA roles and responsibilities in ETL Testing
  • What is mapping document (Transformation, cleansing, etc…)
  • Data flow from source to staging to target
  • Test Scenarios
  • Test Cases writing
    • Source to stage
    • Stage to target
  • Test Execution
  • Initial and Incremental load testing
  • Level of Testing
    • Functional Testing
    • ETL jobs/scheduled testing
  • Defects in ETL
  • Practice on UNIX commands using CYGWIN tool
  • Import flat file to database table in Oracle/Teradata/SQL Server
  • Instruction document on running and monitor workflows/jobs in SSIS/Informatica
  • Samples in SSIS tool

Course Details

  • Live Instructor Based Training
  • Real-Time Oracle Certified Trainer
  • 1 Yr. Membership to Multiple Batches
  • Live Recorded Videos Access
  • Latest Instance Access for 5 Months
  • Study Material Provided
  • Sample Resumes & Preparation
  • Interview Questions with Ans

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
Popular

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.
Popular

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Popular

Happy Students Reviews

Dami
Dami@dami
Read More
The trainer who taught me was very good. The total journey went great. He used to teach me from the beginner level to the advanced…
Surekha
Surekha@Surekha
Read More
The training experience and throughout the duration of course was excellent.I took SAP ABAP couse here which has covered all the topics from beginner to…
Vikram Kumar
Vikram Kumar@Vikram_Kumar
Read More
Best training in Java Script and Angular JS. Recording classes are very good. Focused on every concept with practical approach. This institute gives best training…
Yaswanth
Yaswanth@Yaswanth
Read More
Trainer was good in understanding the requirements and trained the topics with relevant examples for a better understanding. The training was interactive and content was…
Abey
Abey@Abey
Read More
Nice institute with very good facilities for trainer and trainee. Highly recommend it for SAP S4 Hana Basis training. Rajendra Prasad is very helpful and…
Abdhul Mohammad
Abdhul Mohammad@Abdhul_Mohammad
Read More
I had a good experience with VISWA Technologies My trainer was Pradeep sir, he is a good trainer. I completed python course successfully with deep…
Previous
Next

More Courses You Might Like

Dell Boomi

AWS Course

Oracle

Linux

Quick Links