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

Open nowFirst seen 32 hours ago

RQ09067 - Software Developer - ETL - Senior

Rubicon Path638 open roles

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

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

Your applicationOpen nowRQ09067 - Software Developer - ETL - SeniorRubicon 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.9% of postings close within 7 days. Measured by our own scanner across the market.

Share of postings closed within
  1. 2.1%1 day
  2. 4.4%3 days
  3. 11.9%7 days
  4. 18.6%14 days
  5. 35.6%30 days
  6. 45.1%60 days
This job: first seen 32 hours ago

The posting

Description

Deliverables section:

Scope of Services and Deliverables - The Services and Deliverables to be provided by the Vendor will include the following:

· Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc.

· Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.

· Design logical and physical data models using Sybase Power Designer.

· Produce transformation mapping document.

· Implement data pipelines using Azure Data Factory (ADF), stored procedure, and Informatica PowerCenter performing extraction, transformation, and loading activities.

· Implement solutions using Logic App and Function App.

· Generate structured JSON file using ADF/ SQL.

· Develop Azure CI/CD pipeline to automate ADF release.

· Develop complex Oracle PL/SQL program to fulfill project requirements.

· Implement complex data conversion, e.g., binary to character, EBCDIC to UTF.

· Implement complex data transformation(s) for derived and calculated values.

· Integrate data sets from diverse source systems.

· Implement ADF for initial data load and incremental load.

· Promote ADF and Informatica ETL/ELT through all Ministry environments including Development, Integration Testing, QA, UAT, Production.

· Resolve and troubleshoot ADF pipeline, stored procedure, and Informatica workflow technical problems.

· Monitor and analyze incident, provide timely resolution.

· Collaborate with IT Professionals throughout the Software Development Life Cycle.

· Document information from diverse business area stakeholders and subject matter experts.

· Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow.

· Monitor application functionality and performance on daily basis.

· Provide effective knowledge transfer to Ministry staff at all stages of this assignment.

SkillsExperience and Skill Set Requirements

Evaluation Table

ETL Development-Data Integration 40%

· Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.

· Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:

o Self-Hosted Integration Runtime

o Data movement, ETL pipelines

o Performance tuning on large data volumes

o Complex data transformations

o ADF Debugger to validate data transformation.

o Azure Roles

· Experience with Informatica, including:

o Workflow Manager

o Repository Manager

o Designer

o Workflow Monitor

· Experience with developing solutions using Logic App and Function App.

· Experience in rapid application development (RAD) methodologies.

· Experience in maintaining and improving existing ETL processes.

· Experience in investigating data to identify potential issues within ETL pipelines.

· Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI.

Azure Technologies 40%

· Experience with CI/CD (DevOps) pipelines and concepts, including:

o Azure Resource Management

o GitHub Repo

o Source code version control

o Branching, pull requests, build, release, multiple parallel development repositories merge.

· Experience with Azure DevOps, including:

o Azure Boards

o Azure Test Plans

o Azure Pipelines

o Azure Repos

o Azure Artefacts

Oracle PL/SQL Development 10%

· Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.

Database Technologies 10%

· Experience with Oracle, Microsoft SQL Server database and tools.

· Experience with relational and hierarchical database technologies.

· Extensive knowledge of Azure SQL DB and Synapse platforms, including:

o Performance tuning on large data volume

Must haves:Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.

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.