Senior IDMC / IICS Developer

Acestack; Toronto; On-site; CAD 120,000 - 170,000; Full time

Job summary

Acestack is seeking a Senior IDMC / IICS Developer to join our Toronto-based, onsite team. You will design, develop, and optimize enterprise ETL solutions using Informatica IICS/IDMC and PowerCenter, work with Oracle and SQL Server, and collaborate with cross functional teams to meet business needs.

You will translate complex requirements into robust data integration designs, perform testing, and contribute to deployment and knowledge transfer.

Qualifications

• 8–10 years of overall ETL development experience in large IT environments.
• 5+ years of hands-on experience with Informatica PowerCenter.
• 2+ years of hands-on development with IICS/IDMC.
• Strong SQL development experience with Oracle and Microsoft SQL Server.
• Experience with VB, Shell, or Perl scripting languages.
• Strong understanding of Agile methodologies and tools including Jira and Bitbucket.
• Excellent communication, client management, stakeholder engagement, and problem-solving skills.

Responsibilities

• Design, develop, test, and implement enterprise ETL solutions using IICS and IDMC.
• Leverage PowerCenter to develop scalable data integration solutions.
• Translate specifications into efficient ETL designs and development solutions.
• Analyze, design, develop, test, and document ETL processes following best practices.
• Develop complex SQL queries for data extraction, transformation, and reporting.
• Collaborate with SMEs, analysts, architects, and stakeholders to deliver data solutions.
• Perform unit testing and support SIT, QA, UAT, and production deployments.

Skills

ETL development

SQL development

Stakeholder communication

Agile

Tools

Informatica PowerCenter

IICS/IDMC

Oracle

Microsoft SQL Server

VB scripting

Shell scripting

Perl

Jira

Bitbucket

Job description

• Job Title: Senior IDMC / IICS Developer
• Location: Toronto, ON
• Work Mode: Onsite
• Employment Type: Full-Time
• Experience: 8 10 Years

Job Description

• Design, develop, test, and implement enterprise ETL solutions using Informatica Intelligent Cloud Services (IICS) and Informatica Data Management Cloud (IDMC)
• Leverage strong hands-on experience with Informatica PowerCenter to develop scalable and reliable data integration solutions
• Translate detailed technical and functional specifications into efficient ETL process designs and development solutions
• Analyze, design, develop, test, optimize, and document ETL processes following industry best practices
• Develop complex SQL queries for data extraction, transformation, validation, processing, and reporting
• Work extensively with Oracle, Microsoft SQL Server, and other relational database platforms
• Build and maintain data sources, reports, dashboards, KPIs, and data integration processes to support business requirements
• Collaborate with Subject Matter Experts, business analysts, architects, developers, and stakeholders to understand requirements and deliver effective data solutions
• Perform unit testing and support SIT, QA, UAT, production deployments, troubleshooting, and defect resolution
• Develop and maintain scripts using VB, Shell, Perl, or similar scripting languages to support ETL processes and automation
• Optimize ETL workflows, mappings, SQL queries, and data processing performance
• Participate in Agile ceremonies and collaborate with cross-functional teams throughout the development lifecycle
• Prepare technical design documents, mapping specifications, deployment documentation, review artifacts, and operational procedures
• Provide knowledge transfer, training, production support, and technical guidance to users and team members
• Use Jira, Bitbucket, and other Agile development and source-control tools to manage work and code repositories
• Identify and resolve complex data integration, ETL, performance, and production issues
• Ensure solutions meet quality, performance, security, maintainability, and business requirements

Key Requirements

• 8 10 years of overall ETL development experience in large IT environments
• 5+ years of strong hands-on experience with Informatica PowerCenter
• 2+ years of hands-on development experience with IICS/IDMC
• Strong SQL development experience with Oracle and Microsoft SQL Server
• Experience developing complex ETL processes, mappings, workflows, transformations, and data integration solutions
• Experience with VB, Shell, Perl, or similar scripting languages
• Strong understanding of Agile methodologies and tools including Jira and Bitbucket
• Excellent communication, client management, stakeholder engagement, and problem-solving skills
• Ability to work effectively with technical and non-technical stakeholders and deliver high-quality solutions

Eligibility

• Must be eligible for Reliability Status Clearance
• Minimum 5 years of residency requirement applies