Informatica Developer / Architect

Key Responsibilities

• Design, develop, and maintain ETL workflows using Informatica PowerCenter (10.x and above)
• Build and optimize data warehouse solutions using relational and dimensional modeling techniques
• Develop and test ETL mappings, mapplets, and workflows
• Work with Oracle SQL for data extraction, transformation, and performance tuning
• Translate business requirements into technical ETL solutions
• Collaborate with SMEs and stakeholders for requirement gathering and solution design
• Design ETL/ELT architecture and data flow processes
• Identify and resolve technical challenges in data integration systems
• Ensure data accuracy, integrity, and consistency across systems
• Support Oracle ERP data sources where applicable
• Prepare documentation and support implementation best practices