Job Description

Term: October 20, 2025- April 17, 2026
Location: Onsite/Hybrid - 525 University Avenue, Toronto, ON
Our client is seeking a Senior Specialized IT Consultant
Key Deliverables - Senior Specialized IT Consultant
Product Requirements & Delivery: Design, develop, and maintain robust ETL/ELT pipelines using Informatica Intelligent Cloud Services (IICS), Oracle 19G, and Azure SQL. Translate technical specifications into scalable, secure, and high-performing data integration solutions. Ensure production readiness through rigorous QA, unit testing, and continuous monitoring of data workflows.
Prioritization & Support: Provide end-to-end production support, including incident management, root cause analysis, and resolution of ETL job failures. Prioritize and manage support tickets, change requests, and enhancements to maintain data quality and system reliability across environments.
Collaboration & Technical Leadership: Collaborate with cross-functional teams to align data integration strategies with business goals. Guide development teams on best practices in shell scripting (Linux 8), Git version control, and CI/CD pipelines. Contribute to architectural decisions and ensure compliance with accessibility (AODA) and OPS standards.
Cloud & Data Strategy: Leverage Azure cloud technologies (Data Lake, SQL DB, Analytics) for scalable data ingestion and transformation. Provide expertise in managing hybrid data sources, APIs, and CRM integrations (Siebel, OBIEE). Ensure solutions are secure, maintainable, and aligned with enterprise data governance.
Must Haves:
8+ years' experience with IICS (Informatica Intelligent Cloud Services)
8+ years' experience with Oracle 19G
8+ years' experience with Azure SQL Database
8+ years' experience with Linux 8 - Shell Scripting

Skills Required