ETL Testing - Class 1 | Data Warehouse | Business Intelligence | Big Data Testing - Basic concepts

ETL Testing - Class 1 | What is Data Warehouse | What is Business Intelligence | What is Big data Testing - Basic Concepts

A data warehouse, also known as an enterprise data warehouse, is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integrated data from one or more different sources. Data Warehouse (DW) is a relational database that is designed for query and analysis rather than transaction processing.

Business intelligence (BI) refers to the procedural and technical infrastructure that collects, stores, and analyzes the data produced by a company's activities. BI is a broad term that encompasses data mining, process analysis, performance bench marking, and descriptive analytics.
BI tools are types of software used to gather, process, analyze, and visualize large volumes of past, current, and future data in order to generate actionable business insights, create interactive reports, and simplify the decision-making processes.

Big Data Testing can be defined as the procedure that involves examining and validating the functionality of the Big Data Applications. Big Data is a collection of a huge amount of data that traditional storage systems cannot handle.
Data Ingestion: Zookeeper, Kafka, Sqoop
Data Processing: MapR, Hive, Pig
Data Storage: Amazon S3, HDFS
Data Migration: Talend, Kettle, CloverDX

ETL Testing complete training | ETL Testing interview preparation | What is ETL testing | ETL Interview Question and Answers |
SQL Question and Answers | Testing Interview | Manual Testing Interview Questions | Software Testing Interview Questions |
Data Warehouse Questions | BI Interview Questions | ETL Testing | Real Time ETL Testing Interview Questions and Answers Part |
ETL Testing Q&A | Skills required to become ETL Tester | Scope of ETL Tester | ETL Testing Jobs | ETL Testing Project Overview |
ETL TESTING PROJECT EXPLANATION | Real time ETL Testing Interview | How To Become an ETL Tester? Career in ETL Testing

Testing's Can Perform:

Software Testing, ETL Testing, Data Warehouse Testing, Business Intelligence Testing, Manual Testing, Automation Testing, Big data Testing,
BI Testing, DWH Testing, Hadoop Testing, Cloud Testing, data testing, functional testing etc.

Key Words / Key Tools / Key Technologies:

ETL : Informatica Powercenter, IBM Data Stage, Talend, Query Surge, SSIS, Abinitio, Oracle Data Integrator, Pentaho etc.

BI : Microsoft Power BI, Tableau, IBM Cognos, Qlik Sense, SAS Business Intelligence, SAP BO, Oracle Analytics cloud, Qlik view, Alteryx,
Apache spark, spotfire etc.

Cloud / Big data : Hadoop, Salesforce, VMware, Amazon AWS Glue, Microsoft Azure, Google Cloud Platforms, Hive, Stitch, Apache nifi, Dataddo etc.

Testing Types:

Functional Testing, Non-functional Testing, Regression Testing, Retesting, Sanity Testing, Smoke Testing, UAT Testing, GUI Testing, Exploratory Testing Etc.

Technologies Used:

Java, Python, Java Script, SQL, Linux, Selenium, Python pandas etc.