Senior IDMC / IICS Developer

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