Role Overview: We are looking for an experienced Senior Informatica PowerCenter Developer / ETL Developer with strong hands-on expertise in Informatica PowerCenter, Oracle, SQL/PLSQL, Shell scripting, and Perl. The candidate will be responsible for designing, developing, enhancing, troubleshooting, and supporting enterprise Data Warehouse (DW) solutions. The role requires extensive experience in flat-file to database transformations and data loading, data quality remediation, ETL performance optimization, production support, and analysis of existing data warehouse platforms.
Key Responsibilities:
- Design, develop, test, deploy, and maintain ETL workflows using Informatica PowerCenter.
- Develop mappings, mapplets, sessions, workflows, and reusable ETL components based on business and technical requirements.
- Build robust flat-file to database extraction, transformation, and loading processes.
- Work extensively with Informatica transformations such as: Source Qualifier Expression Lookup Joiner Aggregator Filter Router Update Strategy Sorter Implement incremental, full-load, and data synchronization strategies as required.
- Perform unit testing, system/integration testing, and support user acceptance testing.
- Analyze and resolve ETL failures and production issues.
