Senior Data Engineer (Datastage experience)
On-site · Mississauga, Ontario, Canada
Job Summary
Lead DataStage-based data engineering initiatives within RBC Insurance by designing, implementing, and supporting DataStage processes for real-time and batch data flows. Responsibilities include extracting data from source systems, transforming to required formats, loading into interfacing databases, triaging and resolving DataStage production incidents to SLA, providing after-hours on-call support on a rotational basis, collaborating with agile teams to meet testing requirements, coordinating DataStage disaster recovery exercises and migrations, remediation of vulnerabilities per RBC standards, maintaining documentation in Confluence/Jira, and leading projects from initiation to completion. Required expertise spans DataStage components, IBM DB2 and SQL Server data modeling and performance optimization, scripting and automation with JCL and related tools, and experience across mainframe, Windows, and Unix/Linux environments. Desired qualifications include a Bachelor’s degree and programming/cloud skills (Java, JavaScript, C#, .NET, Python, Cloud platforms) along with experience in Kafka, monitoring and incident tools and insurance/financial industry knowledge.
Required Qualifications
- 8+ years experience utilizing IBM DataStage
- Experience with DataStage Designer, DataStage Director and DataStage Console
- 3+ years experience in a Production Support focused function or role
- Strong Knowledge of IBM DB2 and Microsoft SQL Server, including data modeling, stored procedures and optimization
- Experience with JCL, Zeke, StoneBranch and shell scripting
- Experience with tools such as GitHub, Urban Code Deploy, ServiceNow and OnDemand
- Experience working on mainframe, Windows and Unix/Linux environments
- Technical expertise in the design, development, coding, unit testing and debugging of software
- Adaptive and quick to grasp new concepts, even in areas outside of your previous experience
Desired Qualifications
- Bachelor’s degree in Computer Science, Engineering or equivalent
- Knowledge/experience developing with Java, JavaScript, C#, .NET, Python and Cloud technologies (Azure, AWS)
- Knowledge/experience on Kafka, mQueue, Dynatrace, PagerDuty and Apigee
- Insurance and/or Financial Industry experience
- Understanding Automated testing tools, Elastic Search
Apply with one swipe on Sorce. We auto-fill applications and apply on your behalf — no cover letters, no 40-minute forms.
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.