A highly skilled and experienced Informatica CDI Developer is needed to join a team for a long-term, remote engagement. The ideal candidate will have a proven track record of designing, developing, and maintaining robust data integration solutions using Informatica Cloud Data Integration (CDI), with intermediate expertise in Informatica Cloud Application Integration (CAI).

This role requires a strong understanding of API integration, semi-structured data processing, and expert-level SQL skills.

Key Responsibilities :

- Data Integration Solutions : Design, develop, and deploy complex ETL/ELT processes using Informatica Cloud Data Integration (CDI) to integrate data from diverse sources into various target systems, including cloud data warehouses like Snowflake and Redshift.

- Cloud Application Integration (CAI) : Utilize Informatica CAI to design and implement real-time and batch integration solutions for applications and systems, including developing and consuming REST and SOAP APIs.

- Semi-structured Data Processing : Expertly handle and process semi-structured data formats (like JSON and XML) using Informatica CDI features to ensure efficient data extraction, transformation, and loading.

- API Integration : Integrate various applications and systems using APIs, ensuring seamless data flow and interoperability. This involves designing and implementing API calls and integrating with diverse sources like REST and SOAP services.

- SQL Development and Optimization : Write and optimize complex SQL queries for data extraction, transformation, and loading, ensuring optimal performance and efficiency.

- Troubleshooting and Performance Tuning : Identify and resolve data integration issues and performance bottlenecks in existing and newly developed solutions, ensuring high availability and optimal performance of data pipelines.

- Collaboration and Documentation : Work closely with data architects, analysts, and business users to understand data requirements and translate them into effective integration solutions. Document technical designs, workflows, and implementation steps to facilitate maintenance and future enhancements.

Qualifications :

Experience : A minimum of 5 years of experience in Informatica development, with a strong focus on Informatica Cloud Data Integration (CDI).

Technical Expertise :

- Informatica CDI : Expert-level proficiency in designing, developing, and deploying data integration solutions using Informatica CDI.

- IICS CAI : Intermediate experience with Informatica Cloud Application Integration (CAI), including developing and consuming APIs.

- API Integration : Expert understanding of API concepts and hands-on experience integrating various applications and systems using APIs.

Communication : Effective communication and interpersonal skills to collaborate with technical and non-technical stakeholders and articulate complex technical concepts clearly.

Commitment : A minimum commitment of 12 months to the role.