Posted 18 days ago
Senior Informatica PowerCenter Developer - IDMC / IICS
@ Astra North Infoteck Inc.
Toronto, Ontario
Overview
Astra North Infoteck Inc. is hiring a Senior Informatica PowerCenter Developer to design and build ETL solutions on Informatica IICS and IDMC, and to support reporting and data delivery. The role requires 8 to 10 years of ETL development experience, at least 5 years on PowerCenter and 2 years on IICS/IDMC, and eligibility for Reliability Status clearance.
Responsibilities:
- Design and implement ETL solutions on IICS and IDMC
- Translate specifications into ETL process design and development
- Build data sources, reports, dashboards and KPIs
- Perform unit testing and support SIT/QA and production troubleshooting
- Prepare design documentation and train users
Requirements summary:
- 8 to 10 years of ETL development experience
- 5+ years hands-on Informatica PowerCenter
- 2+ years IICS/IDMC experience
- Strong SQL on Oracle and MS SQL
- Reliability Status clearance eligibility with 5 years residency
Tools & skills
Source and dates
Source type not verified · zoho
- Employer posting date
- 2026-10-19
- First seen by our source
- 2026-10-13
- Source record updated
- 2026-10-20
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Senior |
| Department | Software development |
| Experience | 8+ years |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Security clearance | Reliability status |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Astra North Infoteck Inc.
| Field | Value |
|---|---|
| Open jobs on Jobsy | 426 |
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).
Journal
Only you can see this. Kept on this device, and in your account when you sign in.