Informatica Intelligent Cloud Services (IICS) Data Integration Consultant

• Job Title: IICS Lead
• Location: Remote, Canada
• Contract

• Job Description
• We are seeking an experienced IICS Lead with strong expertise in Informatica Intelligent Cloud Services (IICS), SQL, ETL/Data Warehousing, Unix shell scripting, and database technologies.

Responsibilities

• Design, develop, and deploy ETL/ELT pipelines using IICS.
• Build mappings, tasks, and taskflows.
• Integrate data from cloud and on-premises systems.
• Monitor and troubleshoot IICS jobs and workflows.
• Optimize performance of data integration processes.
• Ensure data quality, governance, and security compliance.
• Collaborate with data architects, analysts, and business teams.
• Maintain documentation for technical designs and processes.
• Required Skills
• Skill Proficiency IICS4-5Experience in writing SQL Basic and Advanced SQL queries4-5ETL & DWH Skills3-5Experience with Unix Shell Scripting3-5Experience in Databases3-5

• Mandatory Requirements
• Strong hands-on experience with Informatica Intelligent Cloud Services (IICS).
• Experience developing mappings, tasks, and taskflows in IICS.
• Experience writing basic and advanced SQL queries.
• Knowledge of ETL and Data Warehousing concepts.
• Experience with Unix shell scripting.
• Experience working with databases.
• Ability to integrate data from cloud and on-premises systems.
• Experience monitoring, troubleshooting, and optimizing data integration processes.