Data Analytics and Engineering with Informatica & Tableau

Module 1:

1. Basics of SQL
2. Hands on basic SQL
3. Advance Analytical SQL
4. Hands on Advanced SQL

Module 2:

1. Overall Concepts of Data Warehousing
2. Types of SCDs are their Use cases
3. Different Architectures of Storing and Utilizing data
4. Use cases of OLTP and OLAP as per industry trend

Module 3:

1. What is ETL and Its role in Analytics?
2. Overview on ETL Tool- IICS (Informatica Intelligent Cloud Services)
3. Understanding the development with IICS
4. Understanding different types of transformations in IICS
5. Different Optimization strategies through IICS
6. 4 Hands on practice session on IICS

Module 4:

1. Tableau Basics
2. Tableau- Use cases for Data Visualization

Module 5:

1. Doubt clearing session
2. 3 days Interview Preparation with Assignments
3. Mock Interview (2 Mock interviews of 30 mins for each candidate)