Bridging the Gap between Technology and Business

ETL Testing

  • What is Datawarehouse?
  • Difference between OLTP and Data Warehousing

  • Data Extraction
  • Data Transformation
  • Data Loading

  • Dependent Data Mart
  • Independent Data Mart

  • Star Schema
  • Snow Flake Schema
  • Fact constellation Schema

  • Type-1 SCD
  • Type-2 SCD
  • Type-3 SCD

  • Overview of ETL Tool Architecture
  • White Box and Black BOX Testing Functionality on Different Transformation Rules

  • Unit Testing, Integration Testing, System Testing, Regression Testing, Acceptance Testing, Performance Testing

  • What is extraction?
  • How to do extraction from different sources
  • How to transform the data according to business rules
  • How to load the data in Target Database

  • How to Prepare ETL Test Plan
  • Preparation of Test Plan format
  • ETL Testing plan

  • ETL Test Case Format and Test case Execution

  • Define Requirements
  • Create Physical Design
  • Design Test Plan
  • Create ETL Process
  • Walkthrough ETL Process
  • Coordinate Move to QA
  • Test Process
  • User Validates Data

  • ETL Bug Reporting and Tracking
  • Bug Format and Test Results

  • Database Testing
  • Batch Job Testing Inbound and Outbound Testing
  • Data Migration Testing
  • Report Testing



  • Validation of the report data with DB & UI Testing
  • Preparation of Test Data



Be Our Channel Partner for IT Training Division

Do you want to be a part of our mission in providing Quality Training and help in “Bridging the Gap Between technology and Business”?

  • Amoeba Technologies Sales Executive will contact you and shortlist you for being our channel partner based out on our discussion and shortlisting process
  • We only promote limited partnership depending upon the credibility, location and Business demand
  • No compromise on Trainer Technical Expertise. Amoeba Technologies will provide their own Technical Consultants and Trainers

Please drop your interest and profile at Sales@amoebatechno.com

Testimonials

We sincerely perceive, consider and positively act on our customer’s feedback

Our Clients

Our focus is only you and your benefit