ETL Testing- Beginners to Advance Level
(Informatica, Ab Initio, 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 and Ab Initio, 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 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.
- Gain practical experience with Informatica and Ab Initio tools.
- Explore key data warehouse concepts such as dimensional modeling and slowly changing dimensions.
- 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 and Ab Initio.
- 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
- Ab initio
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
Ab initio
- What is GDE?
- What is Ab initio graphs?
- What is Express it?
- What is Control centre?
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