- Develop and maintain ETL workflows using Informatica PowerCenter.
- Design mappings, mapplets, sessions, and workflows.
- Extract data from multiple sources such as Oracle, SQL Server, flat files, and XML.
- Perform data transformations using Informatica transformation components.
- Develop complex SQL queries, stored procedures, and PL/SQL scripts.
- Implement incremental loads and full loads.
- Handle data cleansing, data validation, and data quality checks.
- Perform performance tuning of mappings and workflows.
- Troubleshoot ETL failures and resolve production issues.
- Work with business analysts and data warehouse teams to understand requirements.
- Prepare technical design documents and unit test cases