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 solid 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

#J-18808-Ljbffr

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