What is the opportunity? 

The Retail Credit and Payment Systems team is looking for an experienced Datastage Developer to join the fast paced and exciting world of credit data platform development. The position “IBM Datastage SME” will be accountable for designing, developing and supporting data stage solutions to accommodate near real time data processing requirements.

What will you do?

Convert the functional requirement into ETL solution and technical design and produce ETL mapping documents and technical design document

Perform PoC before adopting a solution and work with solution architecture team to finalize the solution approach

Develop the ETL code & necessary SQL Scripts according to the specifications and preparation of unit test cases

Develop DS Wrapper Unix scripts to invoke the Datastage job

UAT batch executions and gather stats/test results

Participate in the UAT meetings and resolve any issues that arises and drive the project to closure

Prod readiness and cut over activities and GO LIVE and provide warranty support after production deployment

Plan and transfer knowledge to production support and guide and coach junior team members

What do you need to succeed?

Must-have

Extensive coding experience with Datastage ETL tools and schedule datastage jobs in micro batches

Strong experience with RDBMS, SQL specifically with MSSQL Server

Good experience in UNIX command line and shell scripting

Coding experience with event platform (Kafka) , API and mainframe and familiarity with cloud concepts

Experience with DevOps tools and technologies 

A solid track record of accomplishments in systems design, deployment, troubleshooting, and tuning

A minimum of 8 years of application instrumentation systems design, deployment and support experience is required

Nice-to-have

Understanding of CDC technologies like SQData and Qlik Replicate

Experience in working an agile environment 

Work experience with financial organization

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

Work in a dynamic, collaborative, progressive, and high-performing team

Opportunities to do challenging work

Opportunities to take on progressively greater accountabilities

Access to a variety of job opportunities across business and geographies

Learn more about RBC Tech Jobs

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 rbc.com/careers.