Senior ETL Developer

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?

• 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

What do you need to succeed?

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

• 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

#LI-post

#TECHPJ

Job Skills

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

Additional Job Details

Address:

1597 BEDFORD HWY:HALIFAX

City:

Halifax

Country:

Canada

Work hours/week:

Employment Type:

Full time

Platform:

TECHNOLOGY AND OPERATIONS

Job Type:

Regular

Pay Type:

Salaried

Posted Date:

Application Deadline:

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

---