What you'll 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

Requirements

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

Description

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.