Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Data Engineering with Informatica, Snowflake and Streamlit

person icon Marcos Oliveira

4.2

Data Engineering with Informatica, Snowflake and Streamlit

From source, through IICS, to Snowflake tables, dashboards and Streamlit apps in a single stack

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Marcos Oliveira

category icon Development ,Database and Design Development,SQL

Lectures -56

Resources -7

Duration -5.5 hours

Lifetime Access

4.2

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

Unlock the Power of Data Integration and Transformation Unlock the power of data integration and transformation with this comprehensive course to boost your skills on handling data and unlocking Snowflake tables using Informatica Intelligent Cloud Services (IICS).

You will go through a transformation journey in this course-from basing ETL extracted from CSV files into Snowflake tables using IICS Data Integration to deeper understandings of data movement and manipulation, so you can get proficient in streamlining processes for smooth integration.

In this course, you will begin exploring the capabilities of Snowflake's Dashboard, which gives opportunities for validation and analytics to further extend data. Now, discover how to create really nice and insightful dashboards that will give you a comprehensive view of your data landscape in order to make all of your choices on confidence.

But there's more to it. We would also make you aware of Streamlit, a powerful tool for developing interactive data applications using Python. Learn how to exploit the functionality of Streamlit to create custom data apps that do not only improve the ETL process but, also offer dynamic functionalities that can potentially replace some steps in full.

You will be able to graduate from this course end with a robust set of data integration skills, validation, and application development skills to get back at real-world challenges involving data head-on. In fact, from an experienced data professional to someone just starting out on the journey in the world of data engineering, this course would really give one the insights and practical knowledge needed to propel his or her career.

Goals

  • 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

Prerequisites

  • Basic knowledge on Informatica Cloud Data Integration (CDI)
  • Proficient knowledge on SQL and basic knowledge on Snowflake database
  • Basic knowledge on data modeling and engineering
  • Basic Python knowledge
Data Engineering with Informatica, Snowflake and Streamlit

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

1 Lectures
  • play icon Introduction to the course 02:11 02:11

Snowflake Setup

7 Lectures
Tutorialspoint

IICS Setup

5 Lectures
Tutorialspoint

SOS - Changing objects permission/ownership on Snowflake

1 Lectures
Tutorialspoint

IICS Data Ingestion

7 Lectures
Tutorialspoint

IICS Delete + Insert

3 Lectures
Tutorialspoint

DWH Logic

7 Lectures
Tutorialspoint

Snowflake Dashboard

6 Lectures
Tutorialspoint

Streamlit - Master Product App

10 Lectures
Tutorialspoint

Streamlit - Mapping Apps

7 Lectures
Tutorialspoint

Course Review

2 Lectures
Tutorialspoint

Instructor Details

user profile image

Marcos Oliveira

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515