rq08204 software developer.

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.

Advantages
Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities
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.

Qualifications
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.

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.

Summary
If interested and qualified for this role, please apply today for immediate consideration!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.