ETL Testing Training in Bangalore
tibacademy mobile number
ETL Testing Training in Bangalore Course Description

Hi, I want to do a course in ETL Testing. We are actually 2 students, me and my friend. So, please provide me the course information.

Hi, Welcome to TIB Academy. We are one of the best ETL testing institutes in Bangalore. We can certainly offer you high quality training with placement assistance.

May I know your current profile, so I can get to understand you a bit and assist you in the right way.

I work as a SQL developer. We both are having 3 years of experience in SQL and we have some basic idea on DWH. Now, we want to join this ETL testing course ASAP. because, we are into the project based on ETL testing in our company. Kindly tell me when the next batch is going to start?

That’s great.

ETL stands for Extract-Transform-Load. There are five sequential steps in data warehouse management. They are requirement and analysis, data acquisition, business logic implementation, data mart building and report building. ETL testing is to do verification and validation on each and every phase of the ETL lifecycle. Product validation testing, source-to-target count testing, data testing, data integration testing, data transformation testing, migration testing, duplicate data check testing, data quality testing, regression testing are some of the widely used ETL testing techniques.

We are happy to schedule a new batch according to your time convenience.

Oh that’s nice to know. Is there any prerequisite to learn ETL testing?

Basic knowledge on SQL and data warehousing terminologies would be enough for you to learn ETL testing.

As you are already familiar with the above mentioned concepts, this course will be quite easy for you to learn and grasp the concepts quickly. Otherwise, we are here to help you from the basics.

Great! What do you cover in the ETL testing course? When we can attend a demo?

Our ETL testing course syllabus is designed by highly experienced professionals. It comprises of some highlighting concepts of ETL process, data warehousing & BI concepts, OLAP and OLTP, data marts, dimensional modelling, tables and lot more. Please check below for a detailed syllabus.

We can arrange for a demo based on your preference whether weekend or weekdays.

What sort of trainers do you have? Are they full time trainers with you?

No, Absolutely not! All our trainers are industrial experts, working in MNCs and top Corporates. They are highly qualified and have years of experience in handling real-time issues in the IT environment. They will guide you, coach you and train you to become a seasoned software tester / ETL tester.

That’s really good, Can I expect any project and placement support from your end?

Our ETL testing training in Bangalore can surely help you from basics. The entire course will be equipped with regular hands-on and live project. Our trainers are dealing with real-time scenarios in their workplace. So you can gain the complete project guidance from our industrial experts as per your requirements.

Our project support and interview preparation sessions throughout the course and at the end of the session will boost your confidence and our connections to the job world will help you achieve the job you wish, provided you put your sincere efforts and grab the opportunities.

We are the best ETL training institute providing these kind special services to the students with affordable ETL testing course fees in Bangalore.

OK great! What are the class timings?

We can train to students’ convenience by taking both classroom and online ETL testing coaching in Bangalore. Our training schedule will be during early mornings, late evenings and weekends, as trainers are not available during working weekday hours.

We are operating from Marathahalli providing the best ETL testing course in Bangalore with placement support.

ETL Testing Training Duration

Regular Classes (Morning, Day time & Evening)

Duration: 40 – 45 hrs.

Weekend Training Classes (Saturday, Sunday & Holidays)

Duration: 5 weeks

Fast Track Training Program (5+ hours daily)

Duration: within 20 days.

ETL Testing Training in Bangalore Features

  • Backup ETL Testing Classes
  • Experienced ETL Testing Trainers
  • ETL Testing Online Training
  • ETL Testing Classroom Training
  • ETL Testing Corporate Training
  • Affordable ETL Testing Training Cost
  • ETL Testing Course Completion Certification
  • Personality Development Training
  • Hands-on Training
  • Resume Preparation
  • Career Counselling
  • Placement Assistance
  • Live Project Support
  • Free Wi-Fi
  • Free Parking Facility

Call to Training in Bangalore (TIB Academy)

+91 9513332301

+91 9513332302

+91 9513332303

Subscribe our Newsletter

classroom training in bangalore
online training in bangalore

ETL Testing Training in Bangalore Syllabus

DWH: Data Ware Housing Concepts

  • What is Data Warehouse?
  • Need of Data Warehouse
  • Introduction to OLTP, ETL and OLAP Systems
  • Difference between OLTP and OLAP
  • Data Warehouse Architecture
  • Data Marts
  • ODS [Operational Data Store]
  • Dimensional Modelling
  • Difference between relation and dimensional modelling
  • Star Schema and Snowflake Schema
  • What is fact table
  • What is Dimension table
  • Normalization and De-Normalization

ETL Testing

  • ETL architecture.
  • What is ETL and importance of ETL testing
  • How DWH ETL Testing is different from the Application Testing
  • SDLC/STLC in the ETL Projects (ex: V Model, Water fall model)
  • Challenges in DWH ETL Testing compare to other testing
    • Incompatible and duplicate data.
    • Loss of data during ETL process.
    • Testers have no privileges to execute ETL jobs by their own.
    • Volume and complexity of data is very huge.
    • Fault in business process and procedures.
    • Trouble acquiring and building test data.
  • ETL Testing Work flow activities involved
    • Analyze and interpret business requirements/ workflows to Create estimations
    • Approve requirements and prepare the Test plan for the system testing
    • Prepare the test cases with the help of design documents provided by the developer team
    • Execute system testing and integration testing.
    • Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
    • How to detect the bugs in the ETL testing
    • How to report the bugs in the ETL testing
    • How to co-ordinate with developer team for resolving the defects
  • Types of ETL Testing
    • Data completeness
    • Data transformation
    • Data quality
    • Performance and scalability
    • Integration testing
    • User-acceptance testing
  • SQL Queries for ETL Testing
  • Incremental load testing
  • Initial Load / Full load testing
  • Different ETL tools available in the market
    • Informatica
    • Ab Initio
    • IBM Data stage
  • Power Center Components
    • Designer
    • Repository Manager
    • Workflow Manager
    • Workflow Monitor
    • Power Center Admin Console
  • Informatica Concepts and Overview
    • Informatica Architecture.
  • Sources

Working with relational Sources

  • Working with Flat Files
  • Targets
    • Working with Relational Targets
    • Working with Flat file Targets
  • Transformations – Active and Passive Transformations
    • Expression
    • Lookup –Different types of lookup Caches
    • Sequence Generator
    • Filter
    • Joiner
    • Sorter
    • Rank
    • Router
    • Aggregator
    • Source Qualifer
    • Update Strategy
    • Normalizer
    • Union
    • Stored Procedure
    • Slowly Changing Dimension
      • SCD Type1
      • SCD Type2 — Date, Flag and Version
      • SCD Type3
  • Workflow Manger
  • Creating Reusable tasks
  • Workflows, Worklets & Sessions
  • Tasks
    • Session
    • Decision task
    • Control Task
    • Event wait task
    • Timer task
      • Monitoring workflows and debugging errors
    • Indirect Loading
    • Constraint based load ordering
    • Target Load plan
    • Worklet ,Mapplet ,Resuable transformation
    • Migration ?ML migration and Folder Copy
    • Scheduling Workflow
    • Parameter and variables
    • XML Source, Target and Transformations
    • Performance Tuning
      • Pipeline Partition
      • Dynamic Partition
      • Pushdown optimization
    • Preparation of Test Cases
    • Executing Test case
    • Preparing Sample data
    • Data validation in Source and target
    • Load and performance testing
    • Unit testing Procedures
    • Error handling procedures
Course Fees Enquiry Form
Course Enquiry Form

ETL Testing Training in Bangalore Reviews