📢 Nouveau : recevez les offres du jour sur notre canal WhatsApp
Jobiglo

Aucun resultat.

Senior Data Engineer - ETL Pipelines, Snowflake & Informatica

rbc · 745 Thurlow St:vancouver

Nouveau
Senior 🇬🇧 English
Informatica PowerCenter Snowflake Snowpark Python PySpark SQL Git CI/CD Azure DevOps GitHub Actions AWS Azure

Description du poste

About the role

CNB (City National Bank), an RBC company, is modernizing its data architecture as part of its digital transformation strategy. It is looking for a Senior Data Engineer to architect and build scalable, cloud-native ETL/ELT pipelines that feed its enterprise data ecosystem. The role blends traditional data warehousing with cloud technologies, using Informatica (PowerCenter/IDMC) and Snowflake, with Python for scripting and automation.

Key responsibilities

  • Design, build and maintain batch and near-real-time ETL/ELT pipelines that ingest and transform data from APIs, databases and third-party systems into Snowflake.
  • Build and optimize data mappings, task flows and transformations in Informatica Intelligent Cloud Services (IICS/IDMC) or PowerCenter.
  • Manage and tune Snowflake environments, including workload management, query optimization, virtual warehouse sizing and cost optimization.
  • Develop custom Python components, reusable frameworks and PySpark scripts for advanced processing and data validation.
  • Implement dimensional data models, star/snowflake schemas and Slowly Changing Dimensions (SCD Type 1 and 2).
  • Set up Git-based CI/CD pipelines for database schemas, Python code and Informatica assets.
  • Implement automated data quality checks, reconciliation, audit controls and data lineage.
  • Partner with architecture, BI and data science teams and mentor junior engineers.

Required profile

  • 7-10+ years of experience in data engineering, ETL development and enterprise data warehousing.
  • 5+ years of hands-on development with Informatica PowerCenter or Informatica Cloud (IICS/IDMC).
  • 5+ years of deep Snowflake expertise, including SnowSQL, Snowpark (Python) and native cloud loading.
  • Proven experience with Git and automated deployment tools (Azure DevOps or GitHub Actions).
  • Nice to have: Snowflake or Informatica certifications, exposure to Spark/Kafka, data security and compliance knowledge, and experience preparing datasets for machine learning and AI.

Required skills

  • Advanced Python (Pandas, PySpark) and expert SQL (stored procedures, analytical functions, performance tuning)
  • Snowflake and Informatica PowerCenter or ICS/IDMC
  • Familiarity with AWS (S3, Lambda, Glue) or Microsoft Azure

What we offer

  • Total Rewards program with competitive compensation, bonuses and flexible benefits
  • Coaching, career advancement and access to learning resources
  • Work on enterprise-scale challenges with a collaborative team, with growing technical leadership roles

Questions fréquentes

Le salaire n'est pas communiqué publiquement par le recruteur. Vous pouvez postuler et négocier directement avec rbc.
Cliquez sur "Postuler maintenant" en haut de la page. Vous pouvez importer votre CV en 1 clic — Jobiglo extrait automatiquement vos informations et postule pour vous.
Source : ats:workday

Pourquoi signalez-vous cette offre ?

Merci pour votre signalement. Nous allons examiner cette offre.

Postulez en 30 secondes

Entrez votre email pour postuler. Un compte sera cree automatiquement.

Postuler maintenant →

En continuant, vous acceptez nos conditions d'utilisation.

Deja un compte ? Connexion

Une question sur cette offre ?

Posez-la ici : vous recevrez le récapitulatif de l'offre par e-mail, tout de suite.

Publie il y a 2 jours

Expire dans 1 mois

7 vues · 0 interesses

Boostez vos chances

Importez votre CV : nous vous proposons les offres qui matchent votre profil.

Analyse de votre CV en cours...

rbc

745 Thurlow St:vancouver