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- Beginners to Advance Level-Demo Video:
ETL Testing-Day 1 video
Live Sessions Price:
For LIVE sessions – Offer price after discount is 159 USD 129 99 USD Or USD9900 INR 6900 Rupees.
OR
What will I learn by the end of this course?
- Understand ETL architecture and basics.
- Learn ETL testing techniques like metadata and data validation.
- Explore key data warehouse concepts such as dimensional modeling and slowly changing dimensions.
- Develop proficiency in SQL for data manipulation and analysis.
Free Demo Session:
6th November @ 9 PM – 10 PM (IST) (Indian Timings)
6th November @ 10:30 AM – 11:30 AM (EST) (U.S Timings)
6th November @ 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 Shiv:
| This course provided me with a solid understanding of ETL testing concepts. The practical examples helped me grasp the material easily. – Shravan
I really appreciate and enjoy ETL classes taught by @Shiva Mahajan ETL Trainer. He always focused on real time examples scenarios which help to clear all my doubts. Teaching style was super. Thank you @Shiva Mahajan ETL Trainer and Isha Training for providing platform to learn something new. – Jyothi ETL testing course by instructor Shiv was good and informative. He clarified all doubts and helped us to understand the concepts easily by giving relevant examples. Thank you Shiv and Isha training solutions. – Kani Mani 1. Over-all to Feedback about Shiv Sir: Cleverly good and connecting to the what is ETL tool and behaviour of ETL testing 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
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