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 QualifierExpressionLookupJoinerAggregatorFilterRouterUpdate StrategySorterImplement 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.