Skip to content
CV Rocket
Get started
How it worksThe enginePricingBlogContactSign in

Open nowFirst seen 30 hours ago

RQ08204 - Sr. Software Developer

Rubicon Path638 open roles

Where
Toronto, ON, Canada
Get the CV for this job

From $25 per CV, paid once. No subscription.

Your applicationOpen nowRQ08204 - Sr. Software DeveloperRubicon Path · Toronto, ON, Canada

  1. YouYes, apply to this one.

  2. CV RocketCV written for this posting.

  3. 25 readersRecruiter, hiring manager, skeptic. Round after round.

  4. CV RocketApplied on Rubicon Path's own form.

The reply lands in your private mailbox

3×more interviews than doing it yourself with ChatGPT.

The clock on this job

Early applications get read.

11.5% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.0%1 day
  2. 4.3%3 days
  3. 11.5%7 days
  4. 18.1%14 days
  5. 35.6%30 days
  6. 44.6%60 days
This job: first seen 30 hours ago

The posting

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.

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 1000+ 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%

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

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.
From $25, paid onceGet the CV for this job

What happens when you press

One press. We do the rest.

  1. A CV for this posting

    Written against Rubicon Path's own wording, from every piece of relevant proof in your profile.

  2. 25 readers review it

    Recruiter, hiring manager, skeptic and more read every draft, round after round. You get the best round.

    The review screen in CV Rocket: how each CV was read, round by round.

  3. We apply on Rubicon Path's form

    Our application engine gets through the hardest forms there are. Where a question needs you, AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

    An application in CV Rocket: every answer filled in on the employer's form.

  4. Every reply, sorted

    Rubicon Path's answer lands in your private mailbox, and we classify it on arrival: interview, question, rejection.

    The CV Rocket inbox: each employer reply classified as an interview, an action or a rejection.

  5. Reply with AI

    AI helps you write the email, checks it and sends it. We show you whether the recruiter read it.

  6. The interview in your calendar

    Full integration with your calendar. The invitation goes straight in.

    An interview invitation in the CV Rocket inbox, added to the candidate's calendar.
Get the CV for this job

From $25 per CV, paid once. No subscription.

Why it works

3×

more interviews than doing it yourself with ChatGPT.

ChatGPT writes a CV and never learns what happened to it. We see every reply. For each CV we know:

  • How it was written, and how the review scored it
  • When we applied, and how long after the posting went up
  • Which posting, which company, which city
  • Who got the interview, and who heard nothing

That is how we know which CVs get called.

Get the CV for this job

From $25 per CV, paid once. No subscription.

The numbers game

More applications. More interviews.

Every application goes out with its own CV, written for that posting and paid once. Send enough of them and the law of large numbers finds you the job.

Get the CV for this job
By hand5–10
With CV Rocket100
applications a day

Nearby

Live postings like this one

Same employer first, then the same role elsewhere.

Before you press

Straight answers

Get the CV for this job

From $25 per CV, paid once. No subscription.

What if my background isn't good enough?

We make the most of the background you have. The CV uses every piece of relevant proof your profile holds, and one of the 25 readers reads your whole profile and flags what the CV left out.

Do you really apply for me?

Yes, on the employer's own form, the hardest ones included. Where a question needs you, you answer it right there and AI suggests the best answer. Don't want us applying from our IP addresses? Use our Chrome extension: we apply straight from your own browser.

Is it a subscription?

No. You pay once per CV, from $25. Every application goes out with its own CV, written for that posting.

One job. One CV.
Paid once.

Pick the posting you want. We write for it, apply for you and catch the reply.

Get the CV for this job

From $25 per CV, paid once. No subscription.