ETL Testing Training Course in Jaipur
Industry-oriented certification Digital Marketing training course to furnish your career to kick-start/grow at MNCs/Non-MNCs Organization & corporate
Professional expert Sr. Digital Marketing Institute With 15+ Years of working experience will provide you industrial level training.
You can attain the practical training session to get the indutrial exposure & prepare for the corporate level challanges.
You’ll attain knowledge on bases of real-time scenarios, live projects & best case study to complete E-lite workshop.
ETL Testing Programme Details
Course Duration:40 HRS with Highly Skilled Corporate Trainers
ETL Testing for 9 Modules – Available Sessions on Weekdays / Weekend
E-Lite Institute Jaipur – ETL Testing Practical Training & Delivery Method:
- Web / Desktop Base.
- Instructor-Led Classroom Sessions.
- Presentations/Demonstration/Practicals of concepts.
- Handouts/Assignments/Real-time Exposure to work on Clients.
ETL Testing Programme Modules
ETL Testing Training Modules
<ul>
<li>How to implement data warehousing?</li>
<li>Why data warehousing is important?</li>
<li>OLTP and OLAP database</li>
<li>Introduction to OLTP, ETL and OLAP Systems</li>
<li>Data Warehouse Architecture</li>
<li>ODS [Operational Data Store]</li>
<li>Star Schema and Snowflake Schema</li>
<li>What is fact table</li>
<li>What is Dimension table</li>
<li>Normalization and De-Normalization</li>
</ul>
<ul>
<li>Data Acquisition</li>
<li>Data extraction</li>
<li>Data transformation</li>
<li>Data Loading</li>
<li>Data mart</li>
<li>Data Modeling</li>
</ul>
<ul>
<li>Bid Data (Hadoop)</li>
<li>Oracle</li>
<li>SQL in RDBMS</li>
<li>DDL, DML and working with SQL Queries</li>
<li>Hadoop Distributed file system</li>
<li>Hbase</li>
<li>Apache Pig</li>
<li>Sqoopsss</li>
<li>Microsoft Excel and VBA</li>
</ul>
<ul>
<li>ETL architecture.</li>
<li>What is ETL and importance of ETL testing</li>
<li>Incompatible and duplicate data.</li>
<li>Loss of data during ETL process.</li>
<li>Fault in business process and procedures.</li>
<li>ETL Testing Work flow activities involved</li>
<li>Execute system testing and integration testing.</li>
<li>Best practices to Create quality documentations (Test plans, Test Scripts and Test closure summaries)</li>
<li>How to detect the bugs in the ETL testing</li>
<li>How to co-ordinate with developer team for resolving the defects</li>
</ul>
<ul>
<li>Production validation testing</li>
<li>Metadata testing</li>
<li>Data completeness testing</li>
<li>Data accuracy testing</li>
<li>Data transformation testing</li>
<li>Data quality testing</li>
<li>GUI/Navigation Testing</li>
</ul>
<ul>
<li>Data transformation and Data quality.</li>
<li>Performance and scalability.</li>
<li>Integration testing.</li>
<li>User-acceptance testing.</li>
<li>SQL Queries for ETL Testing</li>
<li>Incremental load testing</li>
<li>Initial Load / Full load testing</li>
<li>Different ETL tools available in the market</li>
<li>Duplicate check</li>
<li>Date validation</li>
<li>ETL Bugs</li>
<li>Difference between ETL Testing and Database testing</li>
</ul>
<ul>
<li>Business transformation logic</li>
<li>ETL software</li>
<li>Test components of ETL warehousing</li>
<li>Create, design and execute test cases</li>
<li>Identify problems and provide solutions</li>
<li>Write SQL queries for different scenarios</li>
</ul>
<p>Automation of ETL Testing</p>
Find the ETL Testing course details below.
Duration of Module
| ETL Testing Course Module | ETL Testing Course Duration |
|---|---|
| ETL Testing Course | 40 (Hours) |
Batch Timings
| ETL Testing Course Schedule | ETL Testing Course Timing |
|---|---|
| Monday to Friday | 8:00 AM – 10:00 AM |
| Monday to Friday | 10:00 AM – 12:00 PM |
| Monday to Friday | 2:00 PM – 4:00 PM |
| Monday to Friday | 4:00 PM – 6:00 PM |
| Saturday/Sunday | 8:00 | 12:00 | 2:00 | 4:00 |
| Sunday | 8:00 AM – 10:00 AM |
| Sunday | 10:00 AM – 12:00 PM |
| Sunday | 2:00 PM – 4:00 PM |
| Sunday | 4:00 PM – 6:00 PM |