"ETL/ Data Warehouse Testing" is no longer available

No Reviews Yet

Gurukul, Ahmedabad

Course ID: 8669

Gurukul, Ahmedabad

Our Consultant picture
Our Consultant
No Reviews Yet

Date and Time

Not decided yet.

Our Consultant picture
Our Consultant

NA

About Our Consultant

Our Consultant, has over 10 years of experience with more emphasis on Backend / Data Warehouse (DWH) / ETL Testing and Production Support. He has rich experience in Reporting tools like Cognos and ETL testing tool likes Informatica & WhereScape.
Has experience in working with companies like, TechMahindra, Capgemini and Secure Meters and has been involved in all sort of deliverables; right from requirement gathering, estimation, planning , readiness and execution, with regular status updates.
No reviews currently

About the Course

Course Overview & Benefits:
Managing a business in today's dynamic world has never been easy. The challenge is to do more with less and to make better decisions than competitors. Having constant access to current, actionable information has become need of time. The best decisions are made when all the relevant data is available and the best possible source for that data is a well-designed data warehouse.

A data warehouse is a database that is specifically designed to produce information for reporting and analysis. "Reporting and analysis" can be anything from listings of sales figures, to hi-tech dashboards, email alerts, ad-hoc reporting and drill-up, drill-down analytics. Data is extracted periodically from the applications that support business processes and copied onto special dedicated computers. There it can be validated, reformatted, reorganized, summarized, restructured, and supplemented with data from other sources. The resulting data warehouse becomes the main source of information for report generation, analysis, and presentation through ad-hoc reports and dashboards.

Topics Covered

1. Data Warehousing Concepts
• Data Warehouse Concepts, Design.
• Need of Data Warehouse.
• Introduction to OLTP, ETL and OLAP Systems.
• Data Warehousing Architecture.
• Dimensional Modeling.
• Data Marts and ODS.
• Star Schema and Snowflake Schema.
• SCD (slowly changing dimension).
• Types of Fact and Dimension Tables.
2. SQL Concepts
• Introduction to Oracle.
• Basic Concepts in SQL.
• Data Types.
• Select statement usage.
• Joins.
• Sub Queries.
• Performance Tuning Tips & Tricks.
3. ETL Testing – Introduction
• Introduction to ETL.
• ETL Architecture.
• What is the use of testing?
• What is quality & standards?
• Responsibilities of ETL Tester.
• Sub Queries.
• Performance Tuning Tips & Tricks.
4. ETL Testing – Procedure
• Steps in DWH Testing
• Prerequisites of DWH Testing.
• Levels of DWH Testing
• The Data Warehousing process
• Coverage of ETL Testing
• How DWH Testing is Different from Application Testing?
• Challenges in DWH Testing
5. Testing Methodologies.
• ETL Testing WorkFlow Process.
• How to Prepare the ETL Test Plan.
• How to design the Testcases in ETLTesting.
• How to report the Bugs in ETL Testing.
• ETL Testing Responsibilities.
• How to detect the bugs through database queries.
• ETL Performance Testing
6. BO and Reports
• Overview
• Reports Testing Process
• Components of BO Testing
7. Query and tools
• Informatica, Datastage, Cognos etc.
8. Conclusion

Who should attend

NA

Pre-requisites

• Knowledge of Manual Testing
• Knowledge of SQL

What you need to bring

NA

Key Takeaways

NA

Reviews

No reviews currently

Explore the following courses which may meet your requirement (4)

Discussions

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more