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

Open nowFirst seen 2 days ago

RQ09197 - 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 nowRQ09197 - 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.8% 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.8%7 days
  4. 18.6%14 days
  5. 35.6%30 days
  6. 45.1%60 days
This job: first seen 2 days ago

The posting

Description

Hybrid Work Environment: The successful candidate is expected to work onsite at 222 Jarvis St 3 days per week, and may work remotely up to 2 days per week.

Responsibilities:

  • Work as an integrated member of the Data Management team to support cross functional data initiatives with various business clients
  • Interact with Business teams to better understand the technical functionality requirements and analyze data requirements and their impact to the existing systems
  • Responsible in connecting various source and target systems (Oracle, Microsoft and Amazon Aurora, Amazon Relational Database Services, databases, APIs, flat files, etc.) and performing Extract, Transform, and Load (ETL) activities
  • Work with team members to develop ETL within Azure Data Factory or Amazon Web Services (AWS) equivalent such as Glue, Kinesis Data Firehose, SageMaker, Data Wrangler, OpenSearch Service, etc. and SQL code to satisfy business requirements
  • Create ETL Mappings and develop stored procedures, SQL queries and tune/optimize SQL code the ETL process and the target database for reporting
  • Execute unit tests to ensure the accuracy of code changes, and to verify that data integrity and performance requirements are met
  • Participate in meetings and scrums, works on incident and enhancement/maintenance tickets assignments and delivers excellent technical support
  • Create and maintains technical documents, including data models

SkillsExperience and Skill Set Requirements

Responsibilities/Assignment Deliverables Senior ETL Developer

Designs, develops, and maintains database back-end and ETL applications for Data Warehouse and Business Intelligence solutions. Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high-quality code using appropriate patterns. Ensures applications remain scalable while complying to standards and following best practices. Tests and debugs applications and ensures that software is properly documented. Collaborates clearly and professionally as part of a development team and communicates with clients.

Mandatory Skills:

  • Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
  • Experience with the Amazon Web Services (AWS) suite of technology including: Amazon Aurora, Amazon Relational Database Search, Glue, OpenSearch, etc.
  • Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
  • Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
  • Experience with data integration, data cleansing, and data analytics
  • Experience with data modeling and design principles for data marts and data warehouses
  • Experience in database management and administration
  • Experience in constructing complex SQL queries and performance tuning
  • Experience with Git and knowledge of source control strategies
  • Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
  • Experience in eliciting, documenting, and validating business requirements
  • Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery
  • Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.

Nice to have skills:

  • Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
  • Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)
  • Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.
  • Experience writing scripts with PowerShell and other scripting languages

Software Developer - Senior - Evaluation Criteria

Description

%

Core Technical Skills

  • Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
  • Experience with the Amazon Web Services (AWS) suite of technology including: Amazon Aurora, Amazon Relational Database Search, Glue, OpenSearch, etc.
  • Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
  • Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
  • Experience with data integration, data cleansing, and data analytics
  • Experience with data modeling and design principles for data marts and data warehouses
  • Experience in database management and administration
  • Experience in constructing complex SQL queries and performance tuning
  • Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.

50%

Other Technical Skills

  • Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing canned reports (scheduled and ad-hoc)
  • Experience with programming languages such as C#, developing application code such as APIs, Functions, etc.
  • Experience writing scripts with PowerShell and other scripting languages
  • Experience with Git and knowledge of source control strategies
  • Experience in software development lifecycle from Development, to Testing and Quality Assurance, to Delivery

35%

Communications Skills

  • Experience in eliciting, documenting, and validating business requirements
  • Solid communications skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.

10%

Standards and Best Practices

  • Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards

5%

MUST HAVES:

· Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI

· Experience with the Amazon Web Services (AWS) suite of technology including: Amazon Aurora, Amazon Relational Database Search, Glue, OpenSearch, etc.

· Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)

· Experience with developing, implementing, and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts

· Experience with data integration, data cleansing, and data analytics

· Experience with data modeling and design principles for data marts and data warehouses

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.