Sr. IDMC Developer – Informatica IDMC | IICS | PowerCenter | ETL | SQL
Design, develop, and implement ETL solutions using IICS and IDMC to translate specifications into functional data processes. Collaborate with stakeholders and Agile teams to build data sources, reports, and dashboards while ensuring high-quality production support.
- On-site
- Toronto, ON
- Posted Sep 2, 2026
- Apply by Oct 2, 2026
- 1 position
Opens an external site
More jobs you can apply to directly
Similar opportunities posted by employers hiring on Jobs.ca, with no external application form.
Job summary
Sr. IDMC Developer – Informatica, IICS, SQL & ETL 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).
What you’ll do
Design, develop, and implement ETL solutions using IICS and IDMC to translate specifications into functional data processes. Collaborate with stakeholders and Agile teams to build data sources, reports, and dashboards while ensuring high-quality production support.
Requirements
Requires 8-10 years of ETL experience, including at least 5 years with PowerCenter and 2 years with IICS/IDMC. Candidates must be proficient in SQL and eligible for Reliability Status Clearance with a minimum 5-year residency requirement.
Listed skills
- SQLPreferred
- JiraPreferred
- AgilePreferred
- OraclePreferred
- Stakeholder ManagementPreferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Informatica IDMC
- IICS
- Informatica PowerCenter
- ETL
- SQL
- Oracle
- MS SQL
- VB
- Shell
- Perl
- Agile
- Jira
- Bitbucket
- Data Modeling
- Unit Testing
- Stakeholder Management
Job areas
- Data & Analytics
- Technology
- Software
- Consulting
- Engineering
Additional details
- Minimum experience
- 5+ years
- Apply by
- Oct 2, 2026
- Posting language
- English
- Working hours
- 40 hours per week
- Seniority
- Mid-Senior level
- Application method
- Direct apply is available