SENIOR SOFTWARE DEVELOPER - IICS/IDMC:

On behalf of our Financial Services client, Procom is searching for a Senior Software Developer - IICS/IDMC for a 9 month contract role. This position is a hybrid position with 2 days onsite at our client’s Toronto, ON office.

SENIOR SOFTWARE DEVELOPER - IICS/IDMC - JOB DESCRIPTION:

The Senior Software Developer will play a critical role in designing, developing, and optimizing Informatica Intelligent Cloud Services (IICS/IDMC) solutions, with a strong focus on Cloud Application Integration (CAI). Responsibilities include building and maintaining API integrations, architecting ETL solutions, integrating with Oracle ERP/EPM, and managing data workflows. The consultant will also handle system architecture reviews, testing, QA, code migration, and Control M scheduling for batch jobs.

SENIOR SOFTWARE DEVELOPER - IICS/IDMC - MANDATORY SKILLS:

• Minimum 4-5 years’ experience with Informatica Intelligent Cloud Services (IICS/IDMC)
• Proficient in writing complex SQL queries
• Experience with API integration projects
• Strong understanding of RDBMS systems like SQL Server and Oracle
• Excellent problem-solving and communication skills
• Working experience with GIT code versioning
• Experience with REST-based systems and interfaces

SENIOR SOFTWARE DEVELOPER - IICS/IDMC – NICE-TO-HAVE SKILLS:

• Experience with AWS platform
• Experience with Cloud Data Integration (CDI)
• Familiarity with Linux environment
• Experience with on-premises and cloud databases and Datawarehouse
• Knowledge of service connectors, application connectors, AWS S3 connector

• Design and implement complex ETL processes
• Develop and maintain API integrations
• Integrate with Oracle ERP and Oracle EPM
• Manage data integration workflows for data validation, inserts, and querying
• Conduct system architecture reviews and suggest improvements
• Perform testing, QA, and code migration
• Schedule batch jobs under Control M