Sr. IDMC / IICS Developer

Title: Sr. IDMC Developer

Key Requirements

8–10 years of overall ETL development experience in large IT organizations

Minimum 5 years of strong hands-on development experience with Informatica PowerCenter and at least 2 years with IICS/IDMC

Design, develop, and implement ETL solutions using Informatica Intelligent Cloud Services (IICS) and IDMC

Translate detailed specifications into ETL process design and development

Analyze, design, develop, test, and document ETL processes following industry best practices

Strong hands-on experience in SQL with databases such as Oracle and MS SQL

Develop and optimize complex SQL queries for data processing and reporting

Build data sources, reports, dashboards, and KPIs to support business needs

Work with Subject Matter Experts and stakeholders to understand requirements and design data solutions





Perform unit testing and support SIT/QA and production troubleshooting

Use scripting languages such as VB, Shell, or Perl to support ETL processes

Collaborate with cross-functional Agile teams including developers, architects, and business analysts

Prepare design documentation, review artifacts, and provide training and support to users

Robust understanding of Agile methodologies and tools such as Jira and Bitbucket

Excellent communication, client management, and stakeholder engagement skills

Ability to solve complex problems and deliver high-quality solutions

Eligibility

- Must be eligible for Reliability Status Clearance (Minimum 5 years residency requirement)

📌 Sr. IDMC IICS Developer (Toronto)
🏢 Zodiac Solutions
📍 Toronto