RQ08204 - Sr. Software Developer

About the job RQ08204 - Sr. Software Developer

Position Overview

The Senior Software Developer will be responsible for providing subject matter expertise and hands‑on technical leadership across all relevant systems. This includes designing, developing, and deploying end‑to‑end solutions in both on‑prem and cloud environments. The role will focus heavily on PL / SQL development, improvement and maintenance while leveraging experience with Cognos and Informatica to enhance reporting, ETL, and integration capabilities.

Responsibilities

• Provide subject matter expertise and hands‑on engagement for all relevant systems, identifying and implementing technical solutions.
• Design, develop, and maintain stored procedures and reports, with a focus on PL / SQL performance tuning.
• Create and refine functional and technical designs throughout the software development lifecycle.
• Develop and execute unit tests, support System Integration Testing (SIT), and assist in Quality Assurance Testing (QAT).
• Support production deployment activities, including conducting root cause analysis for production issues.
• Develop and maintain all functional and technical design documentation.
• Develop and optimize complex stored procedures, functions, triggers, and other PL / SQL database objects.
• Design, develop, and implement ETL processes using Informatica PowerCenter to ensure efficient data extraction, transformation, and loading from various data sources.
• Design and develop business intelligence reports, dashboards, and visualizations using Cognos to provide meaningful insights to stakeholders.
• Collaborate with cross‑functional teams to integrate Cognos reports and Informatica ETL processes into the overall solution architecture.

General Skills

SkillsExperience and Skill Set Requirements

Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 2–3 days per week at 5700 Yonge St.

7–10 years of experience as a Senior Developer with a strong focus on PL / SQL, Cognos, and Informatica, particularly in large public sector environments or big business transformation projects (involving over 1,000+ users).

Experience and Skill Set Requirements :

Extensive hands‑on experience with PL / SQL for database development, performance tuning, and data management, along with demonstrated expertise in Cognos for report development, optimization, and troubleshooting.

Proven experience with Informatica for ETL processes, data integration, and managing complex data migration projects.

Demonstrated expertise in large‑scale implementations, with a focus on ensuring performance, scalability, and reliability of end‑to‑end data and reporting solutions.

Ability to provide technical leadership in case management system integrations, advising on best practices for infrastructure, ETL processes, data integration, reporting, and interface configurations.

Evaluation Criteria :

Technical Expertise - 80%

Methodology, Testing, and Troubleshooting - 20%

Must Have :

#J-18808-Ljbffr