Senior Informatica PowerCenter Developer - IDMC / IICS

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Astra-North Infoteck Inc. is seeking a Senior Informatica PowerCenter Developer to lead ETL initiatives using PowerCenter and IICS/IDMC. The role requires strong SQL skills (Oracle/MS SQL) and experience translating detailed specs into scalable data solutions.

You will work with cross‑functional teams, develop dashboards and KPIs, and document designs while supporting SIT/QA and production troubleshooting. Strong communication and Agile collaboration are essential.

Qualifications

• 8–10 years of ETL development experience in large IT organizations.
• Minimum 5 years with Informatica PowerCenter and at least 2 years with IICS/IDMC.
• Strong hands‑on SQL experience with Oracle and MS SQL.
• Experience designing, developing, and testing ETL solutions in cloud/on‑prem environments.

Responsibilities

• Design, develop, and implement ETL solutions using IICS/IDMC and PowerCenter.
• Translate specifications into ETL process designs and implementations.
• Analyze, develop, test, and document ETL processes following best practices.
• Build data sources, reports, dashboards, and KPIs to support business needs.
• Collaborate with cross‑functional Agile teams and stakeholders.

Skills

ETL development

Informatica PowerCenter

IICS/IDMC

SQL (Oracle & MS SQL)

Scripting (VB, Shell, Perl)

Agile / Jira

Stakeholder communication

Data warehousing / dashboards

Tools

Jira

Bitbucket

Oracle

MS SQL

Job description

Senior Informatica PowerCenter Developer - IDMC / IICS

Key Requirements & Responsibilities

• 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.
• Strong 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).