Back

ETL Testing Day 2

ETL Testing – Live Training Isha presents an Extensive and highly interactive “ETL Testing” by our industry expert with 7+ years of hands-on experience. Learn all the ETL concepts hands-on practical examples. The course syllabus is designed by considering the current job market …

Event Information

  • Price Rs.6,900.00 per participant
  • Location Online
  • Start Time 9:00 pm January 26, 2024
  • Finish Time 10:00 pm January 26, 2024
  • Capacity Limited to 100 people

ETL Testing – Live Training

Isha presents an Extensive and highly interactive “ETL Testing” by our industry expert with 7+ years of hands-on experience. Learn all the ETL concepts hands-on practical examples. The course syllabus is designed by considering the current job market trends and industry requirements.

 

About the Instructor:

RAM has 7+ years of experience in IT, specifically in ETL Testing, Database Testing and Manual testing. He has rich experience in tools like Teradata, Informatica, JIRA… Worked in Insurance, Health, Retail domains. In his knowledge-sharing journey he has trained nearly 100+ students through different modes of training.

 

Sample Videos:

“ETL Testing”- Live Training- October 2023”- Demo video:

“ETL Testing”- Live Training- October 2023”- Day 1 video:

 

Live Sessions Price:

For LIVE sessions – Offer price after discount is 159 USD 129 USD 99 USD Or  9900 INR 6900 Rupees

Enroll For Free Demo

 

What will I learn by the end of this course?

  • By end of the course you will learn to different validations
  • How to Test scenarios, how to use Informatica, how to raise defect in JIRA and handle any ETL Testing project using Teradata SQL, Informatica and JIRA tools.

 

Free Day 2 Session:

26th January @ 9 PM – 10 PM (IST) (Indian Timings)

26th January @ 10:30 AM – 11:30 AM (EST) (U.S Timings)

26th January @ 3:30 PM – 4:30 PM (BST) (UK Timings)

 

Class Schedule:

For Participants in India: Monday to Friday 9 PM – 10 PM (IST)

For Participants in the US: Monday to Friday 10:30 AM – 11:30 AM (EST)

For Participants in the UK: Monday to Friday 3:30 PM – 4:30 PM (BST)

 

What student’s have to say about RAM:

Awesome course. After completion of this course course I was able to successfully switch my role and company. Thank you Ram for such a wonderful and complete course. – Latha

Ram is very knowledgeable. His explanation is very clear and easy to understand. He is there whenever you need his help, fast response! Thank you so much for all your help! – Shakil

Nice courseware. Gives indepth on Datawarehouse and Informatica. – Deepak

It was good explanation about ETL testing process – Sagarika

It was a good learning experience. All the concepts have been explained very well.. – Nayan

It was good. Easy to understand..Just gave simple overview – Mahesh

 

Salient Features:

  • 20 to 25 hours Hours of Live Training 
  • Every session gets recorded and lifetime access to these videos will be given. 
  • Lifetime access to the recorded videos
  • Course Completion Certificate

 

Who can enroll in this course?

  • Anyone who wants to make ETL testing as your career.
  • For any fresher or software professional.
  • Ideal for Manual testers, Automation Testers, Business Analyst, QA Lead or any software professional.
  • Completely new to software those people also learn ETL testing.

 

Course syllabus:

  • Data Ware Housing Concepts
    • What is Data Warehouse?
    • Need of Data Warehouse
    • Characteristics of the Data Warehousing
    • Introduction to OLTP, ETL and OLAP Systems
    • Difference between OLTP and OLAP
    • Data Warehouse Architecture
    • Data Marts
    • ODS [Operational Data Store]
    • Dimensional Modeling
    • Difference between relation and dimensional modeling
    •  Star Schema and Snowflake Schema
    • What is fact table
    • Fact Table Types
    • What is Dimension table
    • Dimension Table Types
    • Slowly Changing Dimensions.
      • SCD Type-1
      • SCD Type-2
      • SCD Type-3
    • Normalization and De-Normalization
    • Types of facts
  • 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
    • Challenges in DWH ETL Testing compare to other testing
  • Validations in ETL Testing
    • Meta data validation
    • Duplicate data validation
    • Null validation
    • Data validation
    • Count validation
    • How to report the bugs in the ETL testing
    • How to co-ordinate with developer team for resolving the defects

SQL Queries (Teradata) for ETL Testing

  • SQL Fundamentals
    • DDL Statements
    • DML Statements
      • Logical operations
      •  Arithmetic operations
      •  Group by and Having clause
      • String functions
    • Set Operators
    • Case
    • Coalesce
    • Null
    • JOINS
      • Inner Join
      • Outer join
      • Cross Join
      • Self-Join
      •  
    • OLAP Functions
      • Rank
      • Row Number
      • C sum
      • M sum
  • Initial Load / Full load testing
  • ETL Testing Activities
    • Preparation of Test Cases
    • Executing Test case
    • Preparing Sample data
  • Different ETL tools available in the market
    • Informatica
    • Talend
    • Ab Initio
    • IBM Data stage

 Informatica

  • Informatica Architecture
  • Power Center Components
    • Repository Manager
    • Designer
    • Workflow Manager
    • Workflow Monitor
    • Workflows
    • Worklets
    • Sessions
    • Tasks
  • Informatica Active & Passive Transformations
    • Expression
    • Sequence Generator
    • Filter
    • Joiner
    • Sorter
    • Rank
    • Router
    • Aggregator
    • Union
  • Teradata Objects
    •  Types of tables 
      • Set tables
      • Multi Set tables
  • Bonus Topics:
    • SDLC
    • STLC
    • Defect Life Cycle
    • JIRA
    • Agile
    • Interview Questions