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:

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 1 Session:

27th December @ 7:30 AM – 8:30 AM (IST) (Indian Timings)

26th December @ 9 PM – 10 PM (EST) (U.S Timings)

27th December @ 2 AM – 3 AM (BST) (UK Timings)

Class Schedule:

For Participants in India: Monday to Friday 7:30 AM – 8:30 AM(IST)

For Participants in the US: Sunday to Thursday 9 PM – 10 PM (EST)

For Participants in the UK: Monday to Friday 2 AM – 3 AM (GMT)

What student’s have to say about RAM:

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

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