Sr. IDMC/IISC Developer

Position: Sr. IDMC/IISC Developer

Location: Toronto, ON (Onsite)

Employment Type: Full-Time

Total Experience: 10+ Years

Job Summary:

We are seeking an experienced Sr. IDMC/IISC Developer to design, develop, and support enterprise-grade ETL and data integration solutions using Informatica IDMC/IICS and PowerCenter .

Key Responsibilities:

• Design, develop, test, and deploy ETL solutions using Informatica IDMC/IICS and PowerCenter.
• Design, develop, and implement ETL solutions using Informatica Intelligent Cloud Services (IICS) and IDMC
• Translate business requirements into scalable data integration solutions.
• Develop complex SQL queries, perform data analysis, and optimize performance.
• Support SIT/UAT testing and production issue resolution.
• Create design documents and provide knowledge transfer and user support.

Required Skills:

• 8+ years of ETL/Data Integration development experience.
• 5+ years of hands-on experience with Informatica PowerCenter and 2+ years with IICS/IDMC.
• Strong expertise in designing, developing, and optimizing ETL solutions.
• Advanced SQL skills with Oracle and MS SQL Server.
• Experience building data sources, reports, dashboards, and KPIs.
• Ability to gather requirements and collaborate with business stakeholders, SMEs, and Agile teams.
• Experience in ETL testing, production support, troubleshooting, and performance tuning.
• Knowledge of scripting languages such as Shell, VB, or Perl.
• Familiarity with Agile practices, Jira, and Bitbucket.
• Strong documentation, communication, client-facing, and problem-solving skills.

Eligibility: Must be eligible for Reliability Status Clearance (minimum 5 years of residency requirement).