Job Title: Senior IDMC / IICS DeveloperLocation: Toronto, ONWork Mode: OnsiteEmployment Type: Full-TimeExperience: 8 10 YearsJob DescriptionDesign, develop, test, and implement enterprise ETL solutions using Informatica Intelligent Cloud Services (IICS) and Informatica Data Management Cloud (IDMC)Leverage robust hands-on experience with Informatica PowerCenter to develop scalable and reliable data integration solutionsTranslate detailed technical and functional specifications into efficient ETL process designs and development solutionsAnalyze, design, develop, test, optimize, and document ETL processes following industry best practicesDevelop complex SQL queries for data extraction, transformation, validation, processing, and reportingWork extensively with Oracle, Microsoft SQL Server, and other relational database platformsBuild and maintain data sources, reports, dashboards, KPIs,



and data integration processes to support business requirementsCollaborate with Subject Matter Experts, business analysts, architects, developers, and stakeholders to understand requirements and deliver effective data solutionsPerform unit testing and support SIT, QA, UAT, production deployments, troubleshooting, and defect resolutionDevelop and maintain scripts using VB, Shell, Perl, or similar scripting languages to support ETL processes and automationOptimize ETL workflows, mappings, SQL queries, and data processing performanceParticipate in Agile ceremonies and collaborate with cross-functional teams throughout the development lifecyclePrepare technical design documents, mapping specifications, deployment documentation, review artifacts, and operational proceduresProvide knowledge

📌 Senior Idmc / Iics Developer (Toronto)
🏢 AceStack
📍 Toronto