ETL Developer

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.