Data Engineering with Informatica, Snowflake and Streamlit
From source, through IICS, to Snowflake tables, dashboards and Streamlit apps in a single stack
Development ,Database and Design Development,SQL
Lectures -56
Resources -7
Duration -5.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
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

Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
1 Lectures
-
Introduction to the course 02:11 02:11
Snowflake Setup
7 Lectures

IICS Setup
5 Lectures

SOS - Changing objects permission/ownership on Snowflake
1 Lectures

IICS Data Ingestion
7 Lectures

IICS Delete + Insert
3 Lectures

DWH Logic
7 Lectures

Snowflake Dashboard
6 Lectures

Streamlit - Master Product App
10 Lectures

Streamlit - Mapping Apps
7 Lectures

Course Review
2 Lectures

Instructor Details

Marcos Oliveira
Course Certificate
Use your certificate to make a career change or to advance in your current career.

Our students work
with the Best


































Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now