Responsibilities
- Develop and maintain ETL pipelines using Informatica IICS and SSIS.
- Write, optimize, and troubleshoot stored procedures in MS SQL and Snowflake.
- Build and enhance data-focused APIs using C# and Apigee.
- Design, develop, and maintain ASP.NET web applications and remediate vulnerabilities.
- Build and maintain data pipelines and automated workflows using Stonebranch or Airflow.
- Integrate with and support wealth management software for investments, trust, custody, and trading.
- Translate financial and operational requirements into technical solutions with business partners.
- Participate in code reviews, architecture discussions, and continuous improvement initiatives.
- Troubleshoot production issues across applications, APIs, databases, and ETL jobs.
- Contribute to secure coding practices and remediation of audit or vulnerability findings.
- Assist with reporting and analytics using SAP BusinessObjects or Tableau.
Requirements
- Expertise in SQL, stored procedures, and database optimization.
- Hands-on experience with Informatica IICS and SSIS.
- At least 3 years of experience with C#, .NET, ASP.NET, and VB.NET.
- Experience building and maintaining REST APIs and working with MS SQL Server.
- Understanding of CI/CD pipelines and modern DevOps practices.
- Ability to maintain and modernize legacy codebases.
- Understanding of investment products, trust accounting, custody operations, and trade lifecycle is preferred.
- Experience supporting or integrating with commercial wealth management platforms is preferred.
- Familiarity with financial data anomalies, regulatory expectations, audit trails, data lineage, and security controls is preferred.
- Knowledge of Python and experience with SAP BusinessObjects or Tableau are nice to have.
- Strong analytical, problem-solving, communication, stakeholder collaboration, and end-to-end ownership skills.
Benefits
- Comprehensive total rewards program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
- Coaching and management opportunities supporting professional development.
- Opportunity to make a difference and lasting impact.
- Collaborative, progressive, high-performing team environment.
- World-class training program in financial services.
- Full-time regular salaried position in Toronto, Canada, with 37.5 work hours per week.
Tech Stack
Categories
About RBC
Royal Bank of Canada is a global financial institution with a purpose-driven, principles-led approach to delivering leading performance. Our success comes from the 94,000+ employees who leverage their imaginations and insights to bring our vision, values and strategy to life so we can help our clients thrive and communities prosper. As Canada's biggest bank and one of the largest in the world, based on market capitalization, we have a diversified business model with a focus on innovation and providing exceptional experiences to our more than 17 million clients in Canada, the U.S. and 27 other countries. Learn more at rbc.com. We are proud to support a broad range of community initiatives through donations, community investments and employee volunteer activities. See how at www.rbc.com/community-social-impact. http://rbc.com/legalstuff. La Banque Royale du Canada est une institution financière mondiale définie par sa raison d'être, guidée par des principes et orientée vers l'excellence en matière de rendement. Notre succès est attribuable aux quelque 94 000+ employés qui mettent à profit leur créativité et leur savoir faire pour concrétiser notre vision, nos valeurs et notre stratégie afin que nous puissions contribuer à la prospérité de nos clients et au dynamisme des collectivités. Selon la capitalisation boursière, nous sommes la plus importante banque du Canada et l'une des plus grandes banques du monde. Nous avons adopté un modèle d'affaires diversifié axé sur l'innovation et l'offre d'expériences exceptionnelles à nos plus de 17 millions de clients au Canada, aux États Unis et dans 27 autres pays. Pour en savoir plus, visitez le site rbc.com/francais Nous sommes fiers d'appuyer une grande diversité d'initiatives communautaires par des dons, des investissements dans la collectivité et le travail bénévole de nos employés. Pour de plus amples renseignements, visitez le site www.rbc.com/collectivite-impact-social. https://www.rbc.com/conditions-dutilisation/