Senior ETL Developer (DataStage)

Royal Bank of Canada; Halifax; On-site; CAD 80,000 - 110,000; Full time

Job summary

A major financial institution in Halifax seeks a Senior DataStage Developer to deliver applications that address business system needs. This role involves coordination of project phases, developing solutions in IBM DataStage, and working collaboratively with stakeholders. The ideal candidate has a Bachelor's degree, strong SQL and DataStage experience, and the ability to solve complex technical problems. Flexible work options and a comprehensive rewards program are offered.

Benefits

Comprehensive Total Rewards Program

Flexible work/life balance

Opportunities for challenging work

Qualifications

• 3+ years of work experience as an ETL Developer (DataStage) or Technical Systems Analyst.
• Experience developing applications for business stakeholders.
• Prior experience with DevOps pipelines and automated testing.

Responsibilities

• Coordinate design/implementation phases for projects.
• Participate in walkthrough reviews of technical specifications.
• Facilitate meetings for technical design and problem-solving.
• Support deployment/release and resolve technical issues.

Skills

Strong technical experience in IBM DataStage

SQL

Shell scripting

Strong analytical skills

Design patterns

Data structures

Algorithms

SCM tools like GitHub

Agile methodologies

Education

Bachelor’s degree in IT, Computer Science or related technical field

Tools

SQL Server

Confluence

Jira

GitHub

Maven

Jenkins

Job description

Job Description

This is a Senior DataStage Developer role within Corporate Treasury Technology team. You will be responsible for delivering applications designed to resolve business system needs while working closely with various partners across IT. You will be involved in all aspects of the development and or maintenance process within a well-established team. The preferred candidate should have hands‑on strong development experience in IBM DataStage. What will you do?

Responsibilities

Coordinate design / implementation phases for projects, identifying, tracking and resolving technical issues

Participate in walkthrough reviews of technical specifications, programs and unit test plans

Provide estimates on activities / tasks required to perform design, coding and unit testing, improving accuracy over time

Facilitate business meetings for technical design, problem solving and task implementation

Support Deployment / Releases and provide resolutions to technical issues found in Production environment.

Possible off‑hours support for urgent technical issues

Requirements – Must‑have

Bachelor’s degree in IT, Computer Science or related technical field with 3+ years of work experience as an ETL Developer (DataStage) or Technical Systems Analyst

Strong technical experience working with IBM DataStage, SQL and Shell scripting; hands‑on working knowledge of SQL Server

Strong analytical skillset, including the ability to transform business logic described in business requirements into solutions that include integration between DataStage servers and databases.

Experience working on projects developing and implementing applications for business stakeholders

Dig deep into performance, scalability, capacity and reliability problems to resolve them

Experience with design patterns, data structures and algorithms, strong mathematical / analytical background

Nice‑to‑have

Work experience on Information Technology projects supporting an enterprise‑wide environment

Experience or knowledge of a scheduler such Autosys, Stonebranch, Zeke or another

Know‑how on Snowflake, Cloud, Gen AI areas

Working knowledge of Confluence and / or Jira

Experience in agile or design thinking methodologies

Additional Experience

Experience with SCM tools such as GitHub

Experience working with DevOps pipelines (GitHub, Maven, Jenkins, Urban Code Deploy, Helios), continuous integration / delivery, automated testing (unit, functional, performance)

Prior exposure to work with internal resources and offshore delivery center operating in a time zone different from the primary work location

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable

Leaders who support your development through coaching and managing opportunities

Flexible work / life balance options

Opportunities to do challenging work

Opportunities to take on progressively greater accountabilities

Job Details

Address: 1597 BEDFORD HWY: HALIFAX

City: Halifax

Country: Canada

Work hours / week: 37.5

Employment Type: Full time

Platform: TECHNOLOGY AND OPERATIONS

Job Type: Regular

Pay Type: Salaried

Posted Date: 2025-11-04

Application Deadline

2025-12-02 Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above

Inclusion and Equal Opportunity Employment

At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.

Join our Talent Community

Stay in‑the‑know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well‑being of our clients and communities at jobs.rbc.com.

Job Skills / Additional Job Details

Active Learning, Application Integrations, Detail‑Oriented, Group Problem Solving, Programming Languages, Software Development Life Cycle (SDLC)