This workshop is focused on allowing the participants to experience how to process and engineer data efficiently in Informatica.

A basic working knowledge of data engineering basics would be a plus.
Applicable to students, working professionals and PMETs.

What you'll learn

Data engineering is the complex task of making raw data usable to data scientists and groups within an organization. Data engineering encompasses numerous specialties of data science. In addition to making data accessible, data engineers create raw data analyses to provide predictive models and show trends for the short- and long-term. Without data engineering, it would be impossible to make sense of the huge amounts of data that are available to businesses. In this workshop, learn how Informatica, a powerful ETL enterprise tool, can help make data engineering tasks easier.

About this course

Delivering a personalized customer experience, accelerating digital transformation, and driving operational efficiency is becoming an important agenda in every organization. Enterprises continue to struggle with the various disparate sources of information, a multitude of technologies, and adapting customized legacy systems to a bursting multi-cloud environment.

Informatica is a data processing tool that is widely used for ETL to extract transform and load processing. This is an industry-leading software in the field of data processing and data governance. In this module participants will have the opportunity to explore the Informatica architecture and experience how Informatica can be a powerhouse for data processing.

Learn In No Time

Course Duration

Have a look
Course Plan

In this section, participants will get a quick overview of the in-depths of Data Warehousing and the various enterprise architectures associated with Data Warehousing today.
What is a Data Warehouse and why do we need it?
Data Warehouse Architectures
Recap: Dimensional Modelling
ELT vs ETL explained

This section will allow the participants to experience how process data efficiently in Informatica. The participants will also be able to understand and apply the best practices of data warehousing and transformation.
Understanding the Informatica Domain Architecture
Understanding Data Types
Exploring various Transformations
o Active and Passive
o Filter Transformations
o Lookup Transformations
o Joiner Transformations
o And others
Learning how to create a workflow
Working with relational/flat file sources and targets

This section will allow participants to experience some of the advanced features in Informatica. It will give the participants further insights into how far the ETL tool can be an enabler for analytics in the organization.
Understanding functions
Insight into the various types of tasks
Performance Testing and Optimization

Looking for something else?

Data Analysis with Excel

Excel has also been the backbone for organizations for a very long time! This course helps you understand how you could leverage the power of Excel and SQL for data management & visualization.

Data Analysis with PowerBI

Depicting the insights from your data in the best possible manner is very important to any organization. This course provides an intensive hands on training on PowerBI for storytelling and analytics!

Data Analysis with MicroStrategy

MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad-hoc queries, thresholds and alerts, and automated report distribution.

Join us & launch your career in data science

It's time to upskill for the Industry 4.0