ETL Development:
Design and develop ETL workflows and mappings in Informatica PowerCenter to extract, transform, and load data from various sources into target databases or data warehouses.
Data Integration:
Work with data sources like relational databases (e.g., Oracle, SQL Server), flat files, and cloud applications, integrating data into a centralized data warehouse or data lake.
Data Modeling & Mapping:
Develop and implement data transformation logic, mappings, and reusable components to integrate large-scale data sets. Ensure data quality, consistency, and integrity during the ETL process.
Performance Optimization:
Monitor and optimize ETL processes for performance improvements, including tuning mappings, workflows, and session performance.
Error Handling & Debugging:
Implement error handling, logging, and debugging strategies to resolve any issues in the ETL pipelines. Ensure data accuracy and timely delivery
