PL/SQL Developer with Cognos exp

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.

Must Have:

• Strong expertise in PL/SQL development, including performance tuning and optimization.
• Proven troubleshooting skills to effectively identify and resolve performance bottlenecks.
• Advanced skills in designing and optimizing stored procedures for efficiency and scalability.
• Experience in Informatica performance tuning for data integration and ETL processes.
• Demonstrated ability to enhance performance and improve efficiency of Cognos reports.

Description

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

• Strong experience in PL/SQL programming, including creating, optimizing, and troubleshooting complex database procedures, functions, and triggers.
• Cognos V11.2 experience, including developing and optimizing reports and dashboards for high availability environments.
• Experience in technical design, development, and delivery of specified technology solutions, including reports, interfaces, conversions, extensions, and customizations.
• Ability to create and update technical design specifications based on project requirements.
• Demonstrated experience in providing accurate estimations for project delivery timelines.
• Experience designing, developing, and testing data conversion programs to ensure accurate and seamless data migrations.
• Knowledge of enterprise architecture methodologies and tools for specified technology environments.
• Hands-on experience with data integration using Informatica, including ETL design and development.
• Experience developing integrated test scenarios, identifying test data, executing tests, troubleshooting issues, and documenting test results.
• Expertise in providing technical leadership in managing stakeholder expectations and requirements.
• Proficient in RDBMS concepts and experience in designing data models and ensuring data quality and consistency.
• Strong experience with SQL development, tuning, and troubleshooting, including the use of relational databases such as Oracle, SQL Server, and DB2.
• Strong experience designing, developing, and maintaining ETL processes using Informatica for data movement, transformation, and integration.
• Experience in optimizing system performance through proactive monitoring and identifying bottlenecks across cloud and on-premise environments.

Desirable Skills

• Experience with Unix scripting to support automation of database and ETL processes.
• Familiarity with version control tools, particularly GitLab.
• Proven experience in facilitating discussions, negotiations, and conflict resolution within development teams.
• Ability to create and develop Web Services for integrating with external systems.
• Knowledge of AIX, UML, XML, and middleware architecture.

Experience and Skill Set Requirements

• 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 1000+ users).
• 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%

• Experience as a Senior Technical Consultant in large-scale enterprises (1,000+ users) and involvement in data-centric transformation projects.
• Strong expertise in PL/SQL development, including experience with performance tuning, stored procedure design, and optimization.
• Extensive hands-on experience with Cognos, including report creation, optimization, and version 11.2.
• Proficiency with Informatica for ETL processes, including data integration, transformation, and Informatica performance tuning.
• Solid understanding of database architecture patterns and best practices, with proven ability to design scalable and maintainable systems.
• Proficiency in working with complex data systems, integrating data from multiple sources (SQL/NoSQL).
• Extensive experience with data integration and ETL tools like Informatica to support large-scale data migrations.
• Experience in database performance optimization, indexing, and query tuning.
• Ability to provide end-to-end technical design for data platforms, offering recommendations to achieve business outcomes in alignment with business requirements.
• Collaborate with stakeholders to understand business goals and support the delivery of successful data integration and reporting outcomes.
• Develop database code following development standards, ensuring consistency and quality in end-to-end solutions.
• Experience in Cognos report design and implementation, with adherence to best practices.
• Incorporate security requirements into data designs, ensuring compliance with industry security standards and policies.

Methodology, Testing, and Troubleshooting - 20%

• Strong analytical, problem-solving, and decision-making skills, complemented by excellent verbal and written communication, interpersonal, and negotiation abilities.
• Experience working in an Agile development environment, with the ability to provide comprehensive user and system documentation as needed.
• Contribute to effective risk and issue management related to performance, data integration, ETL processes, and reporting, ensuring potential problems are identified and addressed proactively.
• Collaborate with cross-functional teams, including data engineers, business analysts, project managers, and QA, to ensure alignment and successful project outcomes.
• Promote industry standards and best practices for data management, ensuring high quality and consistency across data and reporting systems.
• Conduct thorough code reviews and unit testing for PL/SQL scripts, ETL jobs, and report design to ensure software quality and reliability.
• Address defects and provide support to developers, testers, and end-users, ensuring timely resolution and minimal disruption, especially for critical data processes.