Data Engineering with Informatica, Snowflake and Streamlit

Data Engineering with Informatica, Snowflake and Streamlit, available at $54.99, has an average rating of 4.79, with 57 lectures, based on 7 reviews, and has 68 subscribers.

You will learn about Setup Informatica Cloud, Snowflake and AWS Accounts Design IICS Taskflows and assets Ingest data from S3 to Snowflake with CDI Build Snowflake Dashboards Build Streamlit apps inside of Snowflake This course is ideal for individuals who are Data Engineers looking to get proficient on IICS using cloud platforms for data load/ingestion or Data Engineers looking to get into building Streamlit apps in Snowflake It is particularly useful for Data Engineers looking to get proficient on IICS using cloud platforms for data load/ingestion or Data Engineers looking to get into building Streamlit apps in Snowflake.

Enroll now: Data Engineering with Informatica, Snowflake and Streamlit

Summary

Title: Data Engineering with Informatica, Snowflake and Streamlit

Price: $54.99

Average Rating: 4.79

Number of Lectures: 57

Number of Published Lectures: 57

Number of Curriculum Items: 57

Number of Published Curriculum Objects: 57

Original Price: $49.99

Quality Status: approved

Status: Live

What You Will Learn

Setup Informatica Cloud, Snowflake and AWS Accounts

Design IICS Taskflows and assets

Ingest data from S3 to Snowflake with CDI

Build Snowflake Dashboards

Build Streamlit apps inside of Snowflake

Who Should Attend

Data Engineers looking to get proficient on IICS using cloud platforms for data load/ingestion

Data Engineers looking to get into building Streamlit apps in Snowflake

Target Audiences

Data Engineers looking to get proficient on IICS using cloud platforms for data load/ingestion

Data Engineers looking to get into building Streamlit apps in Snowflake

Unlock the power of data integration and transformation with this comprehensive course designed to elevate your skills in handling data and leveraging Snowflake tables through Informatica Intelligent Cloud Services (IICS).

Throughout this course, you’ll embark on a transformative journey, starting from the basics of extracting, transforming, and loading data (ETL) sourced from CSV files into Snowflake tables using IICS Data Integration. Delve deep into understanding the intricacies of data movement and manipulation, gaining proficiency in streamlining processes for seamless integration.

As the course progresses, you’ll transition to exploring Snowflake’s Dashboard capability, unlocking new avenues for data validation and analysis. Dive into creating visually appealing and insightful dashboards that provide a comprehensive overview of your data landscape, empowering you to make informed decisions with confidence.

But the learning doesn’t stop there. We’ll take it a step further by introducing you to Streamlit, a powerful tool for building interactive data applications with Python. Discover how to harness the capabilities of Streamlit to develop custom data apps that not only enhance the ETL process but also offer dynamic functionalities that can potentially replace certain steps altogether.

By the end of this course, you’ll emerge equipped with a robust skill set in data integration, validation, and application development, ready to tackle real-world data challenges head-on. Whether you’re a seasoned data professional or just starting your journey in the world of data engineering, this course provides invaluable insights and practical knowledge to propel your career forward.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to the course

Chapter 2: Snowflake Setup

Lecture 1: Creating a Snowflake account

Lecture 2: Loging into Snowflake

Lecture 3: Creating Databases and Schemas

Lecture 4: Creating course tables – 1

Lecture 5: Creating course tables – 2

Lecture 6: Creating course tables – 3

Lecture 7: Creating course tables – 4

Chapter 3: IICS Setup

Lecture 1: Creating an IICS Data Integration trial account

Lecture 2: Installing the local secure agent

Lecture 3: Creating a flat file connection

Lecture 4: Creating a Snowflake connection

Lecture 5: Setting up a parameter file

Chapter 4: SOS – Changing objects permission/ownership on Snowflake

Lecture 1: Updating objects ownership on Snowflake

Chapter 5: IICS Data Ingestion

Lecture 1: Source files overview

Lecture 2: STG Product Mapping

Lecture 3: Issue on using mapping task instead of mass ingestion for loading files

Lecture 4: STG Touchpoint Mapping

Lecture 5: PSA Calendar

Lecture 6: STG Media Spend

Lecture 7: Data Review

Chapter 6: IICS Delete + Insert

Lecture 1: PSA Product Mapping

Lecture 2: PSA Product Mapping

Lecture 3: PSA Media Spend

Chapter 7: DWH Logic

Lecture 1: DWH mapping – 1

Lecture 2: DWH mapping – 2

Lecture 3: DWH mapping – 3

Lecture 4: DWH mapping – 4

Lecture 5: DWH mapping – 5

Lecture 6: DWH mapping – 6

Lecture 7: DWH mapping – 7

Chapter 8: Snowflake Dashboard

Lecture 1: Snowflake Dashboard Design – 1

Lecture 2: Snowflake Dashboard Design – 2

Lecture 3: Snowflake Dashboard Design – 3

Lecture 4: Snowflake Dashboard Design – 4

Lecture 5: Snowflake Dashboard Design – 5

Lecture 6: Snowflake Dashboard Design – 6

Lecture 7: Snowflake Dashboard Design – 7

Chapter 9: Streamlit – Master Product App

Lecture 1: Product Master app design – 1

Lecture 2: Product Master app design – 2

Lecture 3: Product Master app design – 3

Lecture 4: Product Master app design – 4

Lecture 5: Product Master app design – 5

Lecture 6: Product Master app design – 6

Lecture 7: Product Master app design – 7

Lecture 8: Product Master app design – 8

Lecture 9: Product Master app design – 9

Lecture 10: Product Master app design – 10

Chapter 10: Streamlit – Mapping Apps

Lecture 1: Product mapping app design – 1

Lecture 2: Product mapping app design – 2

Lecture 3: Product mapping app design – 3

Lecture 4: Product mapping app design – 4

Lecture 5: Touchpoint mapping app design – 1

Lecture 6: Touchpoint mapping app design – 2

Lecture 7: Touchpoint mapping app design – 3

Chapter 11: Course Review

Lecture 1: Historical load

Lecture 2: Course Review

Instructors

Marcos Vinicius Oliveira
Data Engineering Expert

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 2 votes

5 stars: 5 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!