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

- 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

📌 Senior IDMC / IICS Developer (Toronto)
🏢 AceStack
📍 Toronto