Position Overview
The Senior Software Developer will be responsible for providing subject matter expertise and handson technical leadership across all relevant systems. This includes designing developing and deploying endtoend solutions in both onprem 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 handson 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 crossfunctional 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.Handson 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 onpremise 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.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 23 days per week at 5700 Yonge St.
710 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).
Experience and Skill Set Requirements :
Extensive handson 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 largescale implementations with a focus on ensuring performance scalability and reliability of endtoend 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 largescale enterprises (1000 users) and involvement in datacentric transformation projects.Strong expertise in PL / SQL development including experience with performance tuning stored procedure design and optimization.Extensive handson 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 largescale data migrations.Experience in database performance optimization indexing and query tuning.Ability to provide endtoend 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 endtoend 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 problemsolving and decisionmaking 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 crossfunctional 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 endusers ensuring timely resolution and minimal disruption especially for critical data processes.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.