Skills for Data Warehouse ETL Developer (with Informatica tool):
Data Warehousing: Strong understanding of data warehousing concepts and architectures.
Data Modeling: Understanding of dimensional data modeling principles including ETL Tools Proficiency: Expertise in Informatica PowerCenter and Power Exchange.
slowly changing dimensions, hierarchies, and fact tables.
Data Integration/ETL/ELT: Expertise in integrating data from various sources, including flat files and databases into dimensional data warehouse structures.
Data Quality: Ensuring data quality and adherence to data governance standards.
SQL and DBMS: Advanced SQL skills and experience with databases like Oracle.
Performance Tuning: Skills in optimizing ETL processes for performance and efficiency.