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
Senior IDMC / IICS Developer • Toronto, ON, Canada
An established industry player is seeking a skilled HR Talent Acquisition Specialist with an MBA in Finance and Operations.This dynamic role involves leading the development of integration solution... Show more
A leading engineering firm is seeking a Senior Application Architect in Markham, Canada, to design and oversee software systems architecture.The role involves ensuring scalability, security, and in... Show more
A leading AI/ML technology firm in Canada is seeking a Senior iOS Developer to lead architecture and technical decisions for mobile products.This role involves working with Swift and integrating Ap... Show more
A technology services firm in Toronto, ON is seeking a qualified professional to support IMS architecture and network performance analysis.Ideal candidates will have experience in workload characte... Show more
Lead for Information Lifecycle Management in Toronto.Focus on automating data lifecycle controls and compliance. Show more
Applications Architect - Intermediate.Days (with possible extension).Seeking an experienced Applications Architect with 10+ years of experience to lead solution architecture, cloud application desi... Show more
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.We are looking for a Senior iOS Developer who possesses a passion for pushing mobile technologi... Show more
High‑performance, people‑focused culture with equity, diversity, and inclusion as core values.Employees feel valued and empowered to be authentic, supported by learning and development initiatives ... Show more
A leading engineering consulting firm in Canada is looking for a Senior Application Architect.This role involves designing and overseeing scalable software systems architecture, primarily focusing ... Show more
Become a Lead Senior Integrations Developer at Engineered Intelligence Inc.AI-enhanced data integration platform.This hybrid role combines data engineering with cutting-edge AI technologies.In this... Show more
At AMD, our mission is to build great products that accelerate next‑generation computing experiences—from AI and data centers, to PCs, gaming and embedded systems.Grounded in a culture of innovatio... Show more
Seeking a hybrid Integration Architect in Toronto to design and develop system integration architectures for Varicent ICS, requiring 5-10+ years of experience and skills in Python, C#, and data mod... Show more
This range is provided by PRI Technology.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Direct message the job poster from PRI Technology.My na... Show more
A technology firm in Toronto is seeking a Senior Software Developer to design and implement REST APIs in a complex enterprise environment.The ideal candidate has over 5 years of experience in API d... Show more
Mid-Senior level contract role as Sr.Applications Architect & Solutions Designer – Health Data & Platforms, based in Toronto, Ontario, Canada.Leading the design and implementation of scalable, secu... Show more
Become a pivotal part of Intact Lab as a Tech Lead focused on Snowflake, IICS, and AWS.Enjoy a balanced hybrid work model while influencing transformative data projects.As a Tech Lead at Intact Lab... Show more
Be among the first 25 applicants.Direct message the job poster from Procom.On behalf of our Financial Services client, Procom is searching for a Informatica Developer – IICS/CAIfor a 7 month contra... Show more
Job Area: Engineering Group, Engineering Group >.The successful candidate will join the Display IP Design team in developing leading edge display solutions in Qualcomm SoC's.We are looking for indi... Show more
A technology consulting firm in Canada is seeking an API and SAP Process Integration Expert for a critical project.The ideal candidate will have over 5 years of experience in enterprise application... Show more
Join the Office of the Public Guardian and Trustee as a Senior Software Developer focused on ETL migration.This role emphasizes data transformation, security, and report generation.With over 5 year... Show more
