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 99 USD Or USD9900 INR 6900 Rupees
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.
Weekend Batch
Free Demo Session:
16th December @ 7:30 PM – 8:30 PM (IST) (Indian Timings)
16th December @ 9 AM – 10 AM (EST) (U.S Timings)
16th December @ 2 PM – 3 PM (BST) (UK Timings)
Class Schedule:
| Days | Learners in India | Learners in US | Learners in UK |
| Demo | 16th December @ 7:30 PM – 8:30 PM (IST) | 16th December @ 9 AM – 10 AM (EST) | 16th December @ 2 PM – 3 PM (GMT) |
| Day 1 | 17th December @ 7:30 PM – 8:30 PM (IST) | 17th December @ 9 AM – 10 AM (EST) | 17th December @ 2 PM – 3 PM (GMT) |
| Day 2 | 23rd December @ 7:30 PM – 9:30 PM (IST) | 23rd December @ 9 AM – 11 AM (EST) | 23rd December @ 2 PM – 4 PM (GMT) |
| Day 3 | 24th December @ 7:30 PM – 9:30 PM (IST) | 24th December @ 9 AM – 11 AM (EST) | 24th December @ 2 PM – 4 PM (GMT) |
| Day 4 | 30th December @ 7:30 PM – 9:30 PM (IST) | 30th December @ 9 AM – 11 AM (EST) | 30rd December @ 2 PM – 4 PM (GMT) |
| Day 5 | 31st December @ 7:30 PM – 9:30 PM (IST) | 31st December @ 9 AM – 11 AM (EST) | 31st December @ 2 PM – 4 PM (GMT) |
| Every Weekend 4 hours the sessions will go on | Every Weekend 4 hours the sessions will go on | Every Weekend 4 hours the sessions will go on |
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 along with recorded videos
- 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
- Types of tables
- Bonus Topics:
- SDLC
- STLC
- Defect Life Cycle
- JIRA
- Agile
- Interview Questions
