Back

ETL Testing- Beginners to Advance Level: Comprehensive Training with Informatica, SQL, Data Warehouse Concepts, Metadata Validation, Duplicate Data Detection, Full Load Testing, and Real-World Projects Day 2

ETL Testing- Beginners to Advance Level (Informatica, SQL, Data Warehouse Concepts, Metadata Validation, Duplicate Data Detection, Real-World Projects)   Join us for an immersive ETL Testing Course curated by seasoned industry professionals. With a focus on practical examples and real-world …

Event Information

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

ETL Testing- Beginners to Advance Level

(Informatica, SQL, Data Warehouse Concepts, Metadata Validation, Duplicate Data Detection, Real-World Projects)

 

Join us for an immersive ETL Testing Course curated by seasoned industry professionals. With a focus on practical examples and real-world scenarios, our training equips you with the skills needed to excel in the dynamic job market. Learn ETL concepts and testing methodologies from experts with extensive hands-on experience, tailored to meet industry demands.

 

About the Instructor:

Shiv is an Experienced ETL Tester with a knack for identifying data models and testing schemas. Proficient in Informatica Power Center with strong skills in Python and SQL. Skilled in data management tools like SQL Server Management Studio and DBeaver, and adept at using JIRA and HP-ALM for test management. Detail-oriented Electronics Engineering graduate.

 

Sample Videos:

ETL Testing-Demo video

ETL Testing-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

OR

WhatsApp

 

What will I learn by the end of this course?

  1. Understand ETL architecture and basics.
  2. Learn ETL testing techniques like metadata and data validation.
  3. Explore key data warehouse concepts such as dimensional modeling and slowly changing dimensions.
  4. Develop proficiency in SQL for data manipulation and analysis.

 

Free Day 2 Session:

5th June @ 9 PM – 10 PM (IST) (Indian Timings)

5th June @ 11:30 AM – 12:30 PM (EST) (U.S Timings)

5th June @ 4:30 PM – 5: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 11:30 AM – 12:30 PM (EST)

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

 

What student’s have to say about Shiv:

This course provided me with a solid understanding of ETL testing concepts. The practical examples helped me grasp the material easily. – Shravan

I highly recommend this course to anyone looking to enter the field of data warehousing. The instructors are knowledgeable, and the hands-on experience with ETL tools was invaluable. – Nikhila

The content was well-structured, and I appreciated the focus on real-world applications. I feel confident in my ability to perform ETL testing after completing this course. – Aman

I was impressed with how the course covered both theoretical concepts and practical skills. The SQL training was particularly useful for me, and I feel prepared to tackle ETL projects in my job. – Divya

 

Salient Features:

  • 30 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?

  • Aspiring data professionals seeking to enter the field of ETL testing.
  • Software testers looking to expand their skill set to include ETL testing methodologies.
  • Data analysts interested in understanding the intricacies of data warehouse testing.
  • IT professionals aiming to enhance their proficiency in ETL tools like Informatica
  • Anyone with a keen interest in data management and analytics, regardless of their current job role.

 

Course syllabus:

ETL Concepts:

  • ETL architecture
  • ETL Basics
  • How DWH ETL Testing is different from the Application Testing
  • SDLC/STLC in the ETL Projects

 

ETL Testing:

  • Meta data validation
  • Duplicate data validation
  • Null validation
  • Data validation
  • Count validation
  • File validation
  • Full load/Initial load Testing
  • Test case preparation/ Test Execution/ Data preparation

 

ETL tools:

  • Informatica

 

Informatica

  • Power centre components
  • Repository Manager
  • Designer
  • Workflow Manager
  • Workflow Monitor
  • Workflows

 

Informatica Active & Passive Transformations

  • Expression
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Rank
  • Router
  • Aggregator
  • Union

 

Data Warehouse concepts:

  • What is Data Warehouse?
  • Need of Data Warehouse
  • Characteristics of the Data Warehouse
  • Understanding of OLTP/OLAP
  • Difference between OLTP and OLAP
  • Data Marts

 

ODS [Operational Data Store]:

  • Dimensional Modeling
  • Difference between relational and dimensional modeling
  • Different schemas (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 DeNormalization
  • Types of facts

 

Manual Testing Concepts:

  • SDLC
  • STLC
  • JIRA
  • Agile concepts

 

SQL concepts:

  • DDL Statements
  • DML Statements
  • Logical operations
  • Arithmetic operations
  • Group by and Having clause
  • Aggregate functions
  • Set Operators
  • Case statements
  • Union
  • JOINS
    • Inner Join
    • Outer join
    • Cross Join
    • Self-Join

 

SQL Functions

  • Rank
  • ⁠Dense Rank
  • Row Number
  • String functions
  • ⁠Date functions
  • ⁠Advance functions
    • Isnull
    • Coalesce
    • Isnumeric