Grow Data SKills | Most Affordable Courses | Become Top Data Professional

Light
Dark

ETL With Informatica - Basic To Advance

By Sahil In Grow Data Skills

Self Paced
English
Completion Certificate

1 Year

Validity (From the date of Enrollment)

25 Hours

Duration

12

Sessions

2

Projects

INR 2200

Buy Now

This course includes

Content Duration25 Hours
Total Video Sessions12
Total Industry Projects2
Quality Assignments & quizzes after each module
Interview preparation guide
Dedicated placement assistance
Resume & Linkedin profile making
Doubt support on private discord community
Certificate of completion

Course Content

Data Architectures Overview : Databases, Data Warehouses, DataMarts, OLAP, OLTP, and Data Marts
ETL Overview : Need of ETL, Tools available in ETL, and ETL developer’s Roles & Responsibilities
Informatica Overview : Introduction, Market Share, Architecture Overview, Download and Installation

Informatica Setup
Informatica UI Walkthrough
Data Transformations : Active Transformations, Passive transformations, and Data Flows
All the Transformation functions: Routing, Grouping, Filtering, Sorting, aggregates, Joins, Ranking, and lookups

Dimensional Modeling
Reusable Transformations
Workflow Monitoring
Integration with Other tools

Version Control
Deployment : Static and Dynamic Deployment
Documentation of Pipelines and Data Models

ETL Project 1:
Building an end-to-end ETL pipeline to extract, load, and transform sales data from an e-commerce platform from multiple sources into a centralised repository.
ETL Project 2:
Building an end-to-end ETL pipeline with governance and quality management, Will include Pipeline development, Error Handling, Performance optimization, Access Controls, Scheduling, Documentation and Reporting

Attention Seeking Resume Preparation and Interview Strategies
Strategies To Crack Tech Interviews
Linkedin Profile Making
How To Expand Your Professional Network On Linkedin
How To Use Various Job Portals
How To Approach For Referrals

Course Schedule

Mode of the Course:

Recorded

Course Duration:

25 Hours

Session:

Total Project:

Validity:

1 Year (From the date of enrollment)

Prerequisite:

Passion And Willingness To Learn

Instructor

Sahil Choudhary

Sahil is a Google Certified Data Analyst and a Senior Data Analyst at Sigmoid Analytics. He has worked with startups and Fortune 500 companies, helping them make scalable data-driven decisions. He mentored over 350 students in analytics domain and developed third party products and has written multiple whitepapers for BI applications.