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


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

Our Clients

Our focus is only you and your benefit