Skip to main content
Full-Time
On-Site

Senior Data Engineer – App Connect Developer

View on Map

Description

This role involves designing, implementing, and supporting Data Engineering solutions and processes within RBC Insurance's Agile Labs. The Senior Data Engineer will focus on data orchestrations and process flows, including extraction, transformation, and loading of data from source systems to interfacing applications, working collaboratively within agile teams to meet data requirements.

What We're Looking For

Create, support, and maintain data orchestrations and process flows, including data extraction from source application systems via Real-Time/Batch processes, transformation of data to specified formats, and load to interfacing applications.,Work closely with agile teams and other stakeholders to understand their data requirements and assist in building data solutions.,Design, develop, and support new and existing batch and real-time data pipelines and recommend improvements and modifications.,Participate in design/code review sessions to ensure all design/code follow industry best practices.,Work closely with Support teams to ensure all Applications running in PROD and pre-PROD environments are working as designed.,Work evening/weekend as required for deployments and DR testing.,Leverage Agile principles and DevOps practices, ensuring enterprise standards are followed and aligned to overall RBC guidelines.,Be part of the developer's community, participate in continuous improvement and best practices.,Create and maintain support artifacts and documentation in Confluence/Jira.,Lead small to medium projects within maintenance from start to end.,3+ years of practical experience with large enterprise applications utilizing IBM App Connect Enterprise and Toolkit.,2+ years of experience with Data transformations, Event driven and asynchronous processing, error handling and retries.,2+ years of experience with XPath/XSLT.,2+ years of experience with Databases and ESQL/SQL language, including data modeling, stored procedures and optimization.,2+ years of Agile development experience.,Experience working with REST/SOAP Web Services and JSON/XML messaging.

Ideal Candidate

Bachelor's degree in Computer Science, Engineering or equivalent (Nice to have).

Minimum Education

Bachelor's Degree

Hard Skills

IBM App Connect Enterprise
IBM App Connect Toolkit
Data transformations
Event driven processing
Asynchronous processing
Error handling
Retries
XPath
XSLT
Databases
ESQL
SQL
Data modeling
Stored procedures
Optimization
Agile development
REST Web Services
SOAP Web Services
JSON messaging
XML messaging
Java
JavaScript
.NET
JCL
Zeke
Mainframe
Kafka
mQueue
OpenShift
Dynatrace
Postman
ServiceNow
PagerDuty
Apigee
Vault
GitHub
UrbanCode Deploy
Helios pipeline
Checkmarx
SonarQube
Aqua
Jira
Confluence
Mural
Agile Methodology
Application Development
Big Data Management
Cloud Computing
Database Development
Data Engineering
Data Mining
Data Modeling
Data Warehousing (DW)
DevOps
IBM DB2 Database
IBM z/OS
Java APIs
Java Frameworks
Job Control Language (JCL)
Requirements Analysis

Soft Skills

Collaboration skills
Adaptability to challenges
Coaching
Mentoring
Strong communication
Analytical skills
Negotiation skills
Conceptual thinking
Requirements interpretation
Solution creation
Problem-solving abilities
Quick learner
Positive attitude
Accountability

Work Hours

37.5 hours/week

Benefits

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.

Special Commitments

Must be willing to work evening/weekend as required for deployments and DR testing.

About the Company

R

Royal Bank of Canada

Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. As Canada's largest bank, it provides personal and commercial banking, wealth management, and capital markets services to over 17 million clients worldwide.

Purpose-driven
Inclusive
Innovative
Collaborative
Professional
View all jobs at Royal Bank of Canada

    We respect your privacy

    BerryMap uses cookies to provide essential features, analyze usage, and improve your experience. You can customize your preferences below.