TOSCA Online Course Training

ETL Job Oriented and Certification Training Program

4.9 / 5

4.7 / 5

4.6 / 5

4.6 / 5

Become an ETL expert in just 60 days with master essential ETL Concepts

ETL Training Key Highlights

70 Hrs Instructor Led Training Live Session

92 Hrs Self-paced Videos

184 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

ETL Training Course Outline

Pre Requisite - SQL

Module - I: Database Introduction
  • Database Basic Concepts
  • SQL Fundamental
  • Data Types
Module - II: SQL (Basic to Advance)
  • Entering to SQL Query Writing
  • Clauses
  • Basic Operator
  • Set Operator
  • SQL Statements/Commands
  • Constraints
  • Virtual Table & Column
  • Join
  • Subquery
  • Object
  • Common Table Expression (CTE)
  • Conditional Statement
  • Built-In Function
  • Pivoting
  • Regular Expression
Module - III: PL/SQL Basics
  • PL/SQL Overview
  • Procedure
  • Function

ETL/DWH (Testing)

Module - I: Data Warehouse/ETL/BI Concepts
  • Data Warehouse Fundamental
  • Data Warehouse Terminologies
  • Data Mart
  • ETL Overview
  • Datawarehouse Architecture
  • Dimensional Modeling
  • OLAP
  • Data Warehouse Schema
  • Partitioning
  • Metadata
  • Data Warehouse Dimension
  • ETL Testing
  • Business Intelligence
  • Bigdata Hadoop Overview
Module - II: ETL Tool (Informatica Power Center)
  • Informatica Power Center Tool Overview
  • Designer Component
  • Workflow Manager Component
  • Workflow Monitor Component
  • Transformation
  • Types Of LookUp Caches
  • Power Center Functions
  • Task Types

ETL Tool - Informatica Power Center (Dev)

Module - I: Data Warehouse/ETL/BI Concepts
  • Data Warehouse Fundamental
  • Data Warehouse Terminologies
  • Data Mart
  • ETL Overview
  • Datawarehouse Architecture
  • Dimensional Modeling
  • OLAP
  • Data Warehouse Schema
  • Partitioning
  • Metadata
  • Data Warehouse Dimension
  • ETL Testing
  • Business Intelligence
  • Bigdata Hadoop Overview
Module - II: ETL Tool (Informatica Power Center)
  • Informatica Power Center Tool Overview
  • Repository Components
  • Designer Component
  • Workflow Manager Component
  • Workflow Monitor Component
  • Transformation
  • Types Of LookUp Caches
  • Power Center Functions
  • Advance Concepts
  • Task Types

ETL Tool - IICS (Dev)

Module - I: Data Integration
  • ETL Concept
  • Dataware Housing Concept
  • Informatica Cloud Overview
  • Runtime Environments and Connections
  • Synchronization Task
  • Cloud Mapping Designer
  • Cloud Mapping Designer – Transformations
  • Mapping Parameters
  • Expression Macro and Dynamic Linking
  • Replication Task
  • Masking Task
  • Mass Ingestion Task
  • Taskflows
  • Hierarchical Connectivity
  • Intelligent Structure Model
  • Advanced Task Settings and Performance Tuning
  • Exception Handling
  • Administration
  • Automating and Monitoring Tasks
  • Discovery IQ
  • External Tool & Practical (Senario Based )
Module - II: Application Integration
  • Overview of Cloud Application Integration
  • Understanding the Basics: Process Designer
  • Working with Assets
  • Adding Web Services to a Process
  • Fault Handling
  • Introduction to Guides Designer
  • CAI and CDI Integration
  • Troubleshooting, Tips & Tricks, Best Practices

Who Should Enroll?

Eligibility/Qualification

Aspiring IT Professionals

Whether you hold a degree in B.E, B.Tech, MCA, MBA, M.Sc, MS, ME, M.Tech, BCA, BSC, BCom, or BA, this course is your stepping stone to a thriving career in IT.

Current IT Experts

Current IT experts seeking ETL testing or developer roles need proficiency in data warehousing, SQL, and data integration tools.

Students & Freshers

All streams of Graduates & Post-Graduates are welcome to explore the dynamic world of data with us.

Become a sought-after data professional with our ETL Training Course. Enroll today and begin your journey to mastering data integration

Training Pattern Details

Congratulations to our student

Appreciations through WhatsApp

Here are our recognitions from our students through whatsapp communication that add value to our training cum placement service

Why Choose Us?

Practical Project Experience

Get hands-on with genuine projects through hands-on experience.

Affordable Fees

Access our courses at reasonable prices, with flexible payment options available.

Flexible Schedule

We offer the convenience to select a learning schedule that suits you.

Expert-Led Training

Learn from real-time experts who are actively shaping the industry.

Job Placement Support

Discover our comprehensive support system for job placement, thoughtfully crafted to launch you into your ideal career.

Recognized Certification

Earn certifications that are respected in the industry, boosting your career prospects.

ETL Training Salary Comparison Data

Pre-Requisites:

Course Objectives:

Enrolled Student Feedback

Top Recruiters for ETL Testing / Developer

Copyright ©2024 Digital Hub Tech . All rights reserved.

Enroll Now

Discover the comprehensive training offered at Digital Hub Tech by enrolling today.
×

Hello!

Click one of our contacts below to chat on WhatsApp

× Text Me