ETL Testing Training
Course Duration
Offline / Online Training & Projects & Practical Sessions
Eligibility
Graduates or Diploma Holders
Course Fee
GST will be charged at checkout Flexible Payment Options Available
ETL — Extract/Transform/Load — is a process that extracts data from source systems, transforms the information into a consistent data type, then loads the data into a single depository. ETL testing refers to the process of validating, verifying, and qualifying data while preventing duplicate records and data loss.
Syllabus
- Data WareHousing Concepts
- What is a Data Warehouse?
- Need of Data Warehouse
- Introduction to OLTP, ETL and OLAP Systems and its differences.
- Data Warehouse Architecture
- Data Marts
- ODS [Operational Data Store]
- Dimensional Modelling ? Difference between relation and dimensional modelling
- Star Schema and Snowflake Schema
- What is a fact table ?What is Dimension table?
- Normalization and De-Normalization
- 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 (ex: V Model, Water fall model)
- Challenges in DWH ETL Testing compare to other testing
- Incompatible and duplicate data.
- Loss of data during ETL process.
- Testers have no privileges to execute ETL jobs by their own.
- Volume and complexity of data is very huge.
- Fault in business process and procedures.
- Trouble acquiring and building test data.
- ETL Testing Work flow activities involved
- Analyze and interpret business requirements/ workflows to Create estimations
- Approve requirements and prepare the Test plan for the system testing
- Prepare the test cases with the help of design documents provided by the developer team
- Execute system testing and integration testing.
- Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)
- How to detect/report the bugs in the ETL testing
- How to co-ordinate with developer team for resolving the defects
- Types of ETL Testing
- Data completeness./Data transformation./Data quality.
- Performance and scalability.
- SQL Queries for ETL Testing (Rogersoft)
- Incremental load testing and Initial Load / Full load testing
- Different ETL tools available in the market:- Informatica, Ab Initio, IBM Data stage
- Power Center Components
- Designer
- Repository Manager and Workflow Manager
- Workflow Monitor
- Power Center Admin Console
- Informatica Concepts and Informatica Architecture.
- Sources Working with relational Sources
- Working with Flat Files
- Targets
- Working with Relational Targets
- Working with Flat file Targets
- Transformations – Active and Passive Transformations
- Expression
- Lookup –Different types of lookup Caches
- Sequence Generator
- Filter/Joiner/Sorter/Rank/Router/Aggregator
- Source Qualifier
- Update Strategy
- Normalizer/ Union
- Stored Procedure
- Slowly Changing Dimension
- SCD Type1, SCD Type2 — Date, Flag and Version, SCD Type3
- Workflow Manager
- Creating Reusable tasks
- Workflows, Worklets & Sessions
- Tasks/ Session
- Decision task/ Control Task/ Event wait task/ Timer task
- Monitoring workflows and debugging errors
- Indirect Loading
- Constraint based load ordering
- Target Load plan
- Worklet ,Mapplet ,Reusable transformation
- Migration ?ML migration and Folder Copy.
- Scheduling Workflow
- Parameter and variables
- XML Source, Target and Transformations
- Performance Tuning
- Pipeline Partition/ Dynamic Partition/ Pushdown optimization
- Preparation of Test Cases
- Executing Test case
- Preparing Sample data
- Data validation in Source and target
- Load and performance testing
- Unit testing Procedures.
- Error handling procedures.
- Testing scenarios, creation of test cases and scripts
- Test case execution and defect tracking and reporting
- Preparation of Test data
- Practice ETL Testing with Real Time Scenarios and FAQ
- Difference between data warehouse and database
- Defect management
- Defect management tools
- Different stages of ETL testing process
- Entry and Exit criteria for these stages
- Agile projects
- Test data management
- Defect triage meeting
- Stakeholders in ETL testing
- Types of ETL validation
- Types of Report validation
- A case study with an ETL transformation
- Reduce the scope of Informatica and add Ansi SQL because most of the the ETL testing projects are black box testing
- Introduction to big data testing
- Mock Interview at Rogersoft
Athulkrishna Prakash
Software Developer [ MEARN ] | Tamchery Solutions
Mohammad Anees A A
Technical Specialist | Cyber Park
V S Sreedevi
Python Developer | Infotura Solutions
Dhaneesh v jayakumaran
Software Developer | Mdigitz Soft Solutions
ABDUL LATHEEF M M
Software Tester | Growtech Software Private Limited
Sreelakshmi S
Software Tester | KOKONET Technologies
Ardra Sasidharan
Junior Developer | Nav Technologies
Snehapriya ES
Software Testers | KOKONET Technologies
.png)
Explore Other Courses
Choose from our comprehensive list of industry-standard courses designed to get you hired.
React
Microsoft SQL Server Training
DevOps
Soap UI Training
Code UI Advanced
Microsoft Azure
What Students Say
Course : Software Testing With ISTQB Training I highly recommend our tutors Twinkle ma'am, Jayasudha ma'am and Vidhya ma'am at Rogersoft to anyone looking for software testing course as they are very patient and understanding making it easy to ask questions and clarify doubts. They've helped me refresh my knowledge even after a career gap with their proper guidance and support.
Course : Software Testing with AI- With ISTQB Training I pursued the Software Testing course with ISTQB training at Rogersoft Technologies. The course is well-structured and helped me build a strong foundation and confidence in software testing. Special thanks to the mentors Twinkle ma’am, Jayasudha ma’am, and Vidhya ma’am for their guidance and support throughout the training.
Course : JMeter, Playwright Automation Training I recently did JMeter training here with Sandeep sir and I thoroughly enjoyed the course as all the sessions were explained very clearly and professionally and his knowledge on this is highly commendable . Sir was very supportive and approachable throughout and hence I never hesitated to clarify my queries. Highly recommend Sandeep Sir.
I did a course on Playwright Javascript also here, with the tutor , Mr. Sreedarshan Sir and all the sessions were very informative and helpful. Sir has in depth knowledge on all the topics and also encouraged the students to ask as many queries as we need. I would highly recommend Rogersoft Technologies and Sreedarshan Sir.
Course : DevOps The DevOps training program was conducted effectively. The instructor explained concepts clearly and ensured proper understanding through practical demonstrations. The sessions were interactive, and support was provided whenever clarification was needed. It was a valuable learning experience.
Course : DevOps The instructor demonstrated strong subject knowledge and delivered the DevOps sessions in a systematic manner. Real-time examples and hands-on practice helped in understanding industry-relevant tools. Overall, the training met expectations.
Course : ISTQB I have successfully completed the ISTQB certification after attending the course at Rogersoft. The trainers were very supportive, and the sessions were easy to understand. Daily questions and discussions helped reinforce the concepts, making the learning process more effective. Overall, it was a good learning experience.
Course : Asp.Net Web API Training I had done .NET course at Rogersoft.. it was really nice experience since the training was practical oriented and the trainer was really helpful… thank you Rogersoft and the team
Course : Data Analytics I recently completed the Data Analytics course from Rogersoft Technologies and overall I had a positive learning experience. The excellent teaching by the instructor made it a highly valuable learning experience.
Course : Full Stack - .Net, React, SQL The classes were really good. I had no experience on React and was able to learn it easily with Rogersoft Technologies. Manoj sir was really good and he explained every single thing in a very understandable way and going to the deep level as well. He also explain every topics n number of times until you understand it clearly. He taught us based on the latest version and tools. Overall the classes were too good. Happy with the entire team and classmates too!!! Thank you!!!
Course : Software Testing (Combo) - 3 months I recently joined Rogersoft Technologies and I am thoroughly impressed with the experience so far. The mentors here are exceptional in their teaching methods, ensuring that every concept is well understood. Additionally, the entire staff is incredibly welcoming and professional, making the learning environment very supportive and enjoyable. I highly recommend Rogersoft to anyone looking to further their education or skills. It truly stands out in terms of quality and commitment.
.jpeg)