
Have a clear view of what valuable capabilities you will get after this course.
Understand how ETL and testing process works
Get to know the tool list that is needed for ETL
Learn more from live documents shared by Microsoft
Please read the important note before starting next sections
Be able to set up Azure databricks service on your own after this lecture
You should be able to set up Azure Cosmos DB yourself after this lecture
Be able to connect Azure databricks service to cosmos DB on your own after this lecture
You can load data into cosmos DB by yourself with the tool shared in this lecture
You can understand the project background and where business requirement comes from
You are able to understand what legacy data we have before commencing the open banking project.
You should be able to understand why how to convert business requirements into technical requirements.
You should be able to understand why and how to design the solution for the open banking project
Learn how to load data into delta tables.
You should have a clear view about the targets we are going to achieve for this project and how to create test strategy to achieve the goals.
Static testing is part of shift-left testing approach. You will know what to cover in static testing.
You can understand what is shift-left testing approach and how to plan our testing with it.
You will learn the test principles we are going to follow for our automation test framework.
Implement the automation test framework with a specific solution and you will understand why and how we realize the solution.
Understand why we need this layer and what functionality this layer provides, including how to get the cosmos configuration, etc.
Understand why we need this layer and what functionality this layer provides, including how to present test summary report.
Learn how to implement the functionality including how to log the testing evidence with time stamp, etc.
Learn how to present test summary report.
Learn how to log the testing evidence with time stamp, etc.
Are you thinking of getting higher income for a long time with a short training period? Then, you come to the right place. As you know AI and big data are the driving forces behind Industry 4.0. Data engineer is high-paid role. As the shortage of data engineers continues and the demand for skilled data engineer is soaring. Switching to data testing engineer is one of the best options for your career, which can get higher pay, long-term contracts and less pressure. By joining this course, you will know how the front-line data engineers execute ETL testing with real open banking project from the scratch, get the ready-to-use, practical and powerful ETL testing framework and the ISTQB testing strategy. So, it will be highly possible to pass your job interview because you really have the similar capabilities with data testing engineers who earn $200, 000+ yearly and be able to resolve complex ETL testing issues on your own after this course.
If you are already a data testing engineer, this course will sharpen your ETL skills. This course can free yourself via saving huge amount of computing time and cost during ETL testing process. More importantly, you will get the capabilities of resolving complex issues in terms of performance, stability and reliability. You will enjoy more free time and leave the hard work to the ETL testing framework and scripts.
With 41 lectures and about 6.5 hours of high-quality content, you will learn the following topics in depth:
Section #1: Values We Can Bring to You
You will understand what valuable capabilities you can take away after this course and extra free live resources you can keep learning.
Section #2: Azure Databricks and Cosmos DB Setup
You are able to set up Azure Databricks, Cosmos DB and connect them on your own.
Section #3: ETL Project Initialization
Get real commercial open banking project experience from scratch including grabbing business requirement, Coverting it to technical requirement, designing the solution and implementing it.
Section #4: ETL and Testing Business Goal and Test Strategy
Identify business goals we are going to achieve and adopt right test strategies and plan static testing and shift-left testing approach.
Section #5: Automaton Test Framework and Solution
Create the automation test framework and implement it with customized test solution. The whole solution will be supported by multiple layers: business logic layer, data quality checking layer, presentation layer, data access layer, etc. Customized, dedicated and ready-to-use functionality has been provided for each layer. They can be reused by you directly or called by third party program. It supports DevOps as well.
Section #6: Automation Test Solution Practice
Automate the open banking project with the customized test framework and resolve complex ETL testing issues in terms of performance, stability and reliability, etc. as an expert.
Section #7: Test Summary Report Enhancement and Test Management
Improve and customize the test summary report and organize test cases properly and make them be easy for maintenance and requirement traceability.
Section #8: Data Quality Checking and Code Refractory
Add the functionality to check data quality for various data types like dateTime, enumeration, regex, etc. Do code refractory to make our code neat and tidy.