Job Description
What is the opportunity?
RBC Technology and Operations hires employees of diverse backgrounds who are intelligent, energetic, assertive, quick to adapt, enthusiastic, eager to learn and client focused. We operate in an industry well known for its fast paced, dynamic and challenging atmosphere. The RBC Insurance Sub Ledger Environment (RISE) team are based in downtown Toronto and London, UK, and is part of a larger Finance IT development organization within RBC Technology and Operations group.
What will you do?
Develop, maintain, and architect Oracle PL/SQL and ETL solutions based on business and system requirements, ensuring adherence to overall IT architectural direction.
Design and optimize ETL pipelines and Oracle database workflows to support high-volume transaction processing for the insurance sub-ledger environment.
Prepare estimates, plans, and technical documentation for projects, system upgrades, and technology currency initiatives.
Conduct comprehensive testing, verification, and performance tuning across all system interfaces in adherence to Aptitude and T&O Standards.
Collaborate with business partners, stakeholders, and cross-functional teams on technical design, implementation strategy, and problem resolution, while identifying risks and recommending mitigation strategies.
Continuously learn and develop knowledge of accounting principles, sub-ledger concepts, and insurance financial processes to enhance technical solutions and bridge business and technology perspectives.
What do you need to succeed?
Must-have
Professional experience developing and supporting large, complex systems with multiple applications and interfaces
Hands-on experience with Oracle database platforms and PL/SQL development
Experience designing, building, or maintaining ETL processes and RDBMS solutions
Proficiency in Shell Scripting and familiarity with Python and Java
Basic Unix/Linux navigation skills (ability to navigate system, view and amend files at a fundamental level)
Understanding of middleware technologies
Experience with agile methodologies and collaborative development practices
Nice-to-have
Professional with experience in the banking and/or insurance sector
Practitioner and knowledge of Aptitude Product(s) or similar ETL toolset
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
Ability to make a difference and lasting impact
Work in a dynamic, collaborative, progressive, and high-performing team
Flexible work/life balance options
Opportunities to take on progressively greater accountabilities.
Access to a variety of job opportunities across business and geographies
#Ll-POST
#TECHPJ
Job Skills
Active Learning, Agile Methodology, Application Integrations, Collaboration, Cross-Functional Teamwork, Decision Making, Detail-Oriented, Development Projects, Enterprise Application Delivery, Group Problem Solving, Innovative Thinking, Problem Resolution, Problem Solving, Programming Languages, Software Development, Software Development Life Cycle (SDLC), Software Development Projects, Software Solutions, Technical Knowledge, Technical StandardsAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Our Employment Opportunities
At RBC, we are guided by living shared values of Client First, Integrity, Collaboration, Respect and Excellence and winning together as One 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.
RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.