ETL Developer – Informatica IICS

Overview

Role

Description:

• Experience in ETL development using Informatica Power Center and Informatica Intelligent Cloud Services (IICS).
• Design, develop, and maintain data warehouse solutions to support organizational data needs.
• Ensure proper data storage, data integrity, and data quality across systems.
• Use Informatica tools to design, implement, and support data integration workflows.
• Analyze and assess business and data requirements for ETL/ELT solutions.
• Load, validate, and test data from multiple source systems.
• Monitor and analyze existing data warehousing and ETL/ELT systems for performance and reliability.
• Design, develop, and maintain Informatica Cloud Data Integration (CDI) processes.
• Implement appropriate data load techniques, including Push-Down Optimization (PDO) for performance tuning.
• Analyze the impact of enhancements or changes on existing ETL/ELT processes and downstream systems.
• Provide L1/L2/L3 production support, including issue analysis, troubleshooting, and resolution.
• Collaborate with cross-functional teams and demonstrate strong communication skills.

• Informatica Power Center
• Informatica CDI (Cloud Data Integration)

• 6–8 years