This class is for who are fresher to start their journey and also who are already experience in different technology and want to change technology to ETL journey
Complete package of course teach you ETL-Informatica develop role.
Personal laptop mandatory with good internet connectivity.
- Introduction to ETL and its importance in data warehousing
- Setting up and installation of various ETL tools
- Optimizing ETL tools for best results based on specific job requirements
- OLAP, ETL and OLTP systems
- Data modeling and dimensional modeling
- Working with star and snowflake schemas
- Dimensions, measures and fact tables in data warehousing
- Data types and performance tuning in ETL
- SCD types and various methods of handling SCD data
- Various types of data transformation techniques
- Source qualifier transformation and mappings
Anybody can take up this training course. However, having a basic knowledge of SQL can be helpful.
ETL Developer
Develop and design ETL methodologies and techniques to support business data.