ETL Developer – Informatica IICS

Role Description:

• Experience in ETL development using Informatica PowerCenter 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.

Skills:

• Informatica PowerCenter

• Informatica CDI (Cloud Data Integration)

Experience Required:

• 6–8 years