Advanced SQL and database knowledge (Oracle, SQL Server, Teradata).
Key Responsibilities ETL Development: Design and build complex Informatica mappings, sessions, and workflows to move data from various sources to target data warehouses.
Performance Tuning: Optimize slow-running queries, mappings, and database loads using partitioning and indexing.
Data Quality & Cleansing: Perform data profiling, validation, and de-duplication to ensure data accuracy.
Troubleshooting: Monitor daily data loads and fix extraction or loading failures.