Senior ETL Developer (Informatica IDMC/IICS)

Role: Sr. IDMC / IICS Developer
Location: Toronto, Ontario - Hybrid
Salary: CAD 115,000 per annum + Standard Benefits
Openings: 5
Employment Type: Full-time / Contract
Experience Level: Mid-Level / Senior
Industry: Banking

Total Experience: 8-10 years Required

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