Comprehensive Training: From Scratch to Advanced Levels

Pre-requisite learning: SQL and Snowflake (Included in the course)

DBT Daywise content: 

✅ 1. Introduction to Data build tool DBT

✅ 2. Trial account set up and fivetran data extraction

✅ 3. Informatica IICS tool overview, Oracle to Snowflake data load

✅ 4. Informatica IICS tool overview, Oracle to Snowflake data load

✅ 5. DBT materialization, table, and views

✅ 6. DBT reference, sources, and query tag

✅ 7. Reference and source example, up/down stream

✅ 8. Incremental and ephemeral materialization

✅ 9. DBT seeds, macros, pre and post hook 

✅ 10. DBT Snapshot and SCD Type - 2 implementation

✅ 11. DBT test and test case implementation

✅ 12. DBT variables and GitHub integration

✅ 13. Snowflake and Power BI integration

✅ 14. DBT Data model and data pipeline with different layers

✅ 15. Snowflake with DBT resume preparation, project arch

Each day, content will be added until the course completion

Day-wise exercises are added for each topic. 

Resume Preparation
Interview questions and answers
Project-level sessions

For more details, please check the day-wise video topics