IISC Developer - Informatica

Key Responsibilities :

- Develop and maintain integration solutions using Informatica Intelligent Cloud Services (IICS).

- Build Cloud Application Integration (CAI) workflows using REST APIs.

- Design and implement API-based integrations and REST API endpoints.

- Work with IICS service connectors, application connectors, and AWS S3 connectors.

- Develop integrations with Oracle ERP and Oracle EPM.

- Design and implement ETL and data integration workflows for data validation, inserts, and querying.

- Create solution architecture for different ETL and integration use cases.

- Review existing system architecture, identify gaps, and recommend appropriate integration solutions.

- Perform testing, QA, code scanning, and code migration activities.

- Troubleshoot integration issues and perform performance tuning.

- Work with on-premise and cloud databases/data warehouses as required.

Required Qualifications :

- Strong hands-on experience with Informatica Intelligent Cloud Services (IICS).

- Strong experience with Cloud Application Integration (CAI).

- Hands-on experience with API integration projects.

- Strong understanding of REST APIs and REST-based systems.

- Experience with IICS connectors, including service/application connectors.

- Experience with AWS S3 connector.

- Experience integrating with Oracle ERP and Oracle EPM.

- Experience designing and implementing complex ETL processes.

- Proficiency in writing complex SQL queries.

- Good understanding of Oracle, SQL Server, and other RDBMS platforms.

- Experience working with on-premise and cloud databases/data warehouses.

- Experience working in a Linux environment.

- Strong debugging, problem-solving, and performance-tuning skills.

- Good analytical and communication skills.

Skills

Informatica, IICS, Application Integration, Data Integration, AWS, Cloud Integration