Data Integration Expert

1 week ago


Calgary, Alberta, Canada Royal Bank of Canada Full time

Job Summary

Job Description

What is the opportunity?

We are seeking a highly skilled Senior DataStage Developer to join our team at the Royal Bank of Canada. As a key member of our Global IT Data Services Canada team, you will be responsible for designing, developing, and implementing complex data integration solutions using DataStage and other ETL tools. You will work closely with our development team to deliver high-quality solutions that meet the needs of our business stakeholders.

What will you do?

  • Design and develop complex data integration solutions using DataStage and other ETL tools
  • Work closely with the development team to deliver high-quality solutions that meet the needs of our business stakeholders
  • Contribute to the development of technical design documents, specifications, and unit test plans
  • Participate in walkthrough reviews of technical design, specifications, and unit test plans
  • Assist the DevOps/support teams in troubleshooting high-priority implementation issues and production investigations

What do you need to succeed?

Must-have

  • Hands-on experience with IBM Infosphere DataStage and QualityStage
  • Exposure to application programming and analysis required with DataStage and ETL tools
  • Database query performance tuning experience
  • Development background in Java technologies, including Spring Boot
  • Experience developing API/Web Services, REST, Messaging-based Applications like Kafka, MQ, Kubernetes
  • Experience with Enterprise applications and Systems like Traditional RDBMS, In-Memory distributed databases (MemSQL), Cassandra
  • Hands-on experience with developing complex stored procedures and SQL tuning
  • Experience with Containerization and DevOps/automation methods/tools (OpenShift, Docker)
  • Experience with mainstream programming languages (Java) as well as scripting languages
  • Experience with multiple platforms (Unix/Linux, Windows) in both Agile and Waterfall environments

Nice-to-have

  • Strong experience in development and support of applications, especially integration technology IBM ACE (IIB), IBM MQ
  • Prior experience managing small teams

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
  • Network and build lasting relationships with colleagues from diverse backgrounds
  • Participate in fun events and gamification challenges to help build your career toolkit while enjoying a work-life balance
  • Leaders who support your development through coaching and learning opportunities
  • Work in a dynamic, collaborative, progressive, and highly performing team
  • Ability to make a difference and lasting impact
  • Enjoy a comfortable work environment with the option to dress casually

Job Skills

Active Learning, Agile Methodology, Application Integrations, Applications Programming, Database Development, Database Management Systems (DBMS), Databasing, Data Modeling, Detail-Oriented, Enterprise Application Delivery, ETL Processing, Group Problem Solving, IBM WebSphere MQ, Programming Languages, Software Development Life Cycle (SDLC)



  • Calgary, Alberta, Canada Data Engineer Jobs Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our team at Data Engineer Jobs. As a Senior Data Engineer, you will be responsible for designing, developing, and maintaining scalable data pipelines and architectures within the Snowflake Data Cloud.Key ResponsibilitiesDesign and implement complex data pipelines and ETL processes...


  • Calgary, Alberta, Canada Data Engineer Jobs Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our team at Data Engineer Jobs. As a Senior Data Engineer, you will be responsible for designing, developing, and maintaining scalable data pipelines and architectures within the Snowflake Data Cloud.Key ResponsibilitiesDesign and implement complex data pipelines and ETL processes...


  • Calgary, Alberta, Canada SAIT Full time

    About the RoleWe are seeking a highly skilled Data Integrity Specialist to join our team at SAIT. As a key member of our Office of the Registrar, you will play a critical role in ensuring the accuracy and integrity of student data.Key ResponsibilitiesStudent Record Data Quality Analysis and Reporting: 50%Oversee the governance of data elements and ensure the...


  • Calgary, Alberta, Canada SAIT Full time

    About the RoleWe are seeking a highly skilled Data Integrity Specialist to join our team at SAIT. As a key member of our Office of the Registrar, you will play a critical role in ensuring the accuracy and integrity of student data.Key ResponsibilitiesStudent Record Data Quality Analysis and Reporting: 50%Oversee the governance of data elements and ensure the...

  • Data Integrity Lead

    3 weeks ago


    Calgary, Alberta, Canada Parkland Corporation Full time

    About Parkland Corporation Parkland Corporation is a leading independent energy company with a diverse portfolio of businesses across Canada, the United States, and the Caribbean. We are committed to providing reliable and sustainable energy solutions while fostering a culture of safety, integrity, and innovation. The Opportunity: We are seeking a highly...


  • Calgary, Alberta, Canada CB Canada Full time

    About the RoleWe are seeking an experienced Data Engineer to join our team at CB Canada. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining our data integration processes and associated data pipelines.Key ResponsibilitiesDesign and develop modern data solutions using Azure PaaS services to support...


  • Calgary, Alberta, Canada Alberta Blue Cross Full time

    About Alberta Blue CrossAlberta Blue Cross is a leading health insurance provider in Alberta, dedicated to delivering exceptional customer experience and community leadership. We're committed to providing the best health coverage to over 1.8 million members and take an active role in promoting wellness.Our TeamWe're a team of passionate professionals who...


  • Calgary, Alberta, Canada Alberta Blue Cross Full time

    About Alberta Blue CrossAlberta Blue Cross is a leading health insurance provider in Alberta, dedicated to delivering exceptional customer experience and community leadership. We're committed to providing the best health coverage to over 1.8 million members and take an active role in promoting wellness.Our TeamWe're a team of passionate professionals who...


  • Calgary, Alberta, Canada Insight Enterprises Full time

    Job DescriptionAbout the Role:Insight Enterprises is seeking a highly skilled Data Integration Analyst to join our team. As a Data Integration Analyst, you will play a critical role in building out a data fabric across the organization, working primarily with Microsoft Fabric to connect systems such as Dynamics 365, Agiloft, JDE, and SmartSimple.Key...


  • Calgary, Alberta, Canada Insight Enterprises Full time

    Job DescriptionAbout the Role:Insight Enterprises is seeking a highly skilled Data Integration Analyst to join our team. As a Data Integration Analyst, you will play a critical role in building out a data fabric across the organization, working primarily with Microsoft Fabric to connect systems such as Dynamics 365, Agiloft, JDE, and SmartSimple.Key...


  • Calgary, Alberta, Canada Insight Enterprises Full time

    Job DescriptionAbout the Role:We are seeking a highly skilled Data Integration Specialist to join our team at Insight Enterprises. As a Data Integration Specialist, you will play a critical role in building out a data fabric across our organization, working primarily with Microsoft Fabric to connect systems such as Dynamics 365, Agiloft, JDE, and...


  • Calgary, Alberta, Canada Insight Enterprises Full time

    Job DescriptionAbout the Role:We are seeking a highly skilled Data Integration Specialist to join our team at Insight Enterprises. As a Data Integration Specialist, you will play a critical role in building out a data fabric across our organization, working primarily with Microsoft Fabric to connect systems such as Dynamics 365, Agiloft, JDE, and...


  • Calgary, Alberta, Canada Data Engineer Jobs Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Data Engineer Jobs. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining scalable data pipelines and architectures within the Snowflake Data Cloud.Key Responsibilities:Design and Implement Data Pipelines: Develop and...

  • Senior Data Architect

    23 hours ago


    Calgary, Alberta, Canada Data Engineer Jobs Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Data Engineer Jobs. As a key member of our data engineering team, you will be responsible for designing, developing, and maintaining scalable data pipelines and architectures within the Snowflake Data Cloud.Key Responsibilities:Design and Implement Data Pipelines: Develop and...


  • Calgary, Alberta, Canada Tektronit Full time

    About TektronitTektronit is a leading provider of innovative solutions for data-driven businesses.Job SummaryWe are seeking an experienced ETL Developer to join our team in a full-time capacity. The successful candidate will be responsible for designing, developing, and maintaining complex data integration systems.Key ResponsibilitiesDesign and develop ETL...


  • Calgary, Alberta, Canada Tektronit Full time

    About TektronitTektronit is a leading provider of innovative solutions for data-driven businesses.Job SummaryWe are seeking an experienced ETL Developer to join our team in a full-time capacity. The successful candidate will be responsible for designing, developing, and maintaining complex data integration systems.Key ResponsibilitiesDesign and develop ETL...


  • Calgary, Alberta, Canada Tektronit Full time

    ETL Developer with extensive knowledge in SQL, Tableau, and project management tools such as Jira and Confluence. Opportunities for remote work are available.Key Responsibilities:Develop and maintain ETL processes to ensure data integrity and availability.Expertise in ETL platforms is a must.Experience with cloud-based data solutions, particularly...


  • Calgary, Alberta, Canada Tektronit Full time

    ETL Developer with extensive knowledge in SQL, Tableau, and project management tools such as Jira and Confluence. This position offers the flexibility of remote work.Key Responsibilities:Develop and maintain ETL processes to ensure efficient data integration.Expertise in ETL platforms is a fundamental requirement.Experience with cloud-based data solutions,...


  • Calgary, Alberta, Canada Vista Projects Limited Full time

    About Vista Projects LimitedVista Projects Limited is a leading industrial engineering firm that provides innovative solutions to clients in the energy sector. Our company is committed to delivering high-quality projects and services that meet the needs of our clients.Job SummaryWe are seeking an experienced ETL Data Integration Specialist to join our team....


  • Calgary, Alberta, Canada Vista Projects Limited Full time

    About Vista Projects LimitedVista Projects Limited is a leading industrial engineering firm that provides innovative solutions to clients in the energy sector. Our company is committed to delivering high-quality projects and services that meet the needs of our clients.Job SummaryWe are seeking an experienced ETL Data Integration Specialist to join our team....