DW/BI/ETL Testing Training Course is designed for both entry-level and advanced Programmers. The course includes topics related to the foundation of Data Warehouse with the concepts, Dimensional Modeling and important aspects of Dimensions, Facts and Slowly Changing Dimensions along with the DW/BI/ETL set up, Database Testing Vs Data Warehouse Testing, Data Warehouse Workflow and Case Study, Data Checks using SQL, Scope of BI testing and as a bonus you will also get the steps to set up the environment with the most popular ETL tool Informatica to perform all the activities on your personal computer to get first hand practical knowledge. We provide the best online classes to help you learn Data Warehousing, OLAP, OLTP, deploying SQL for checking data, and the basics of Business Intelligence.
Course content
Data Warehousing Concepts
- Dataware house architecture
- Datamart
- DW Schema – Star Schema – Snow Flake Schema
- Objects in DWH – Dimension table – Fact table
- SCD(SLOWLY CHANGING DIMENSIONS) – SCD TYPE 1 – SCD TYPE 2 – SCD TYPE 3
Building Queries
- Practical query session with sql query
- Advance query writing session
- Understanding the ETL mapping documents
- Advance practical sessions on building queries
- Notes on real time validated queries.
Building queries for BI report
- Implementation of SCD types
- Validating the schema tables
- Building queries for BI report
- Informatica Tool overview.
Differences between OLTP and OLAP SDLC And STLC
- Agile Methodologies
- Waterfall Model
SQL (Structured Query Language)
- DDL (Data definition language)
- DML (Data manipulation language)
- DQL (Data query language)
Data Ware Housing Life Cycle w.t.r ETL ETL TESTING TYPES
- Data migration testing
- Sample testing and Scenario Testing
- BATCH JOB Testing
- Inbound Testing
- OutBound Testing
ETL TESTING TASKS
- Spec analysis
- Designing Testcases
- ETL Test scripts preparation
- Environment Preparation
- Test Execution
- Peer Reviews of QA deliverables
ETL Testing validations
- Structure validation
- Count validation
- TRANSFORMATION Logic Check
- Data validation
- MINUS Query
- Duplicate Check
- Error logic Check
- RI Validation( Referential integrity constraint check)
- Scenario testing
- Derived checks
- Default values check
- Data Integrity check
Basic checks at ETL Phases
- Extraction phase testing
- Transformation phase testing
- Loading phase testing
Testing for SCD
- SCD Type1 Testing
- SCD Type2
Testing Overview of ETL Tool (Data stage) CODE PROMOTION PROCESS
- Dev to QA
- QA to UAT
- UAT to Production
CONTROL M ( Scheduling tool slides) UNIX
To see the full course content Download now
Course Prerequisites
- Some basic knowledge of SQL concepts can be helpful.
- PL/SQL Skills
- Manual Testing Skills
- ETL/Data Warehousing Knowledge
Who can attend
- SQL Developers, Software Engineers, and Analysts
- BI, Mainframe, and Database Project Managers
- Professionals that want to become Business Object Professionals
Number of Hours: 40hrs
Certification
ETL Testing Professional Certification
Key features
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Virtual Live Experience
- Preparing for Certification
FAQs
DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.
- One to One Training
- Online Training
- Fastrack & Normal Track
- Resume Modification
- Mock Interviews
- Video Tutorials
- Materials
- Real Time Projects
- Materials
- Preparing for Certification
Call now: +91-99003 49889 and know the exciting offers available for you!
We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.
Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.
All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.
No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.
DASVM Technologies provides many suitable modes of training to the students like:
- Classroom training
- One to One training
- Fast track training
- Live Instructor LED Online training
- Customized training
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.
Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.
Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.
We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.
DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com