Senior ETL Data Engineer with GCP experience to build data pipelines for ingestion using tools such as Fivetran, Qlik, Airbyte with one of our major banking clients- 35854

S.i. Systems
Toronto
Temps plein

Senior ETL Data Engineer with GCP experience to build data pipelines for ingestion using tools such as Fivetran, Qlik, Airbyte with one of our major banking clients-

Location Address : Toronto- Hybrid model ( 1 day a week in office- No specific days)

Contract Duration : 3 Months and will be extended beyond February. (Possibility of extension & conversion to FTE Possibly - Depending on performance and funding approval)

Schedule Hours : 9 am-5 pm Monday-Friday, 37.5 hours (No overtime to be discussed with the hiring manager if needed)

Story Behind the Need

Business group :

  • GWRT Data and Analytics Technology (OU) Build the data pipelines and analytics for the bank.
  • Project : International banking Salesforce effectiveness - Support to migrate IB Commercial Banking data to Google Cloud Platform (GCP) and to CB Commercial Banking's Salesforce Financial Services Cloud (FSC) instance to create a global commercial Salesforce org.

A total of 10 people working on this project Current pre-planning.

Typical Day in Role :

  • Design, develop and maintain robust data pipelines for ingestion, transformation, and distribution of large datasets.
  • Utilize services and tools to automate data workflows and streamline the data engineering process.
  • Collaborate with stakeholders and product managers to analyze, and build data mapping, models and reporting needs.
  • Monitor application and pipeline performance.
  • Conduct data quality checks

Must Have Skills :

  • 10+ years of experience as a Data Engineer with Data Warehouse / Data Platforms
  • 5+ years of experience creating ELT data pipelines from scratch, working with structured, semi-structured, and unstructured data and SQL.
  • 2+ years of experience configuring and using data ingestion tools such as Fivetran, Qlik, Airbyte or others.
  • 5+ years of experience with Cloud : GCP
  • 5+ years of experience working as a data developer, data engineering, programming, ETL, ELT, processes for data integration.
  • 5+ years continuous integrations and continuous deployment pipeline (CI / CD) and working with source control systems such as Github, Bitbucket, and Terraform

Nice-To-Have Skills :

  • Experience in data modelling, manipulating large data sets and handling raw SQL, and handling other cleaning techniques.
  • Python nice to have
  • DBT nice to have

Education & Certificates :

Bachelor's degree in a technical field such as computer science, computer engineering or related field required or sufficient experience.

Best VS. Average Candidate :

The ideal candidate is someone who can quickly adapt to any change, solve problems effectively, and implement sustainable solutions.

1st round Interview with the Hiring manager and Tech lead MS Teams- Talk about work experience and get to know, the manager will ask questions to assess previous experience.

Ex : scenario-based questions and behavioural questions

Il y a 6 jours
Emplois reliés
S.i. Systems
Toronto, Ontario

You will be directly supporting the adoption of several tooling solutions to enable teams to move forward with the interoperability project and related corporate data governance activities. Access to effective tooling will improve productivity, quality and consistency, internal and external collabor...

Sigma Software
Toronto, Ontario

We are looking for an experienced Software Engineer who has a background in the AdTech industry and is excited to contribute to the development of an innovative defense platform that will disrupt the economics of cybercrime. This includes the onboarding and integration process for various companies ...

Royal Bank of Canada>
Toronto, Ontario

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. If you’re a bright mind with fresh ideas, top of your class, own the hackathon circuit and are passionate about innovati...

Canadian Institute for Health Information
Toronto, Ontario

The Senior Analyst, Data Request Services (DRS is responsible for responding to custom data requests related to CIHI's acute and ambulatory care data, including requests received through Health Data Research Network Canada’s Data Access Support Hub (DASH) and the management of CIHI’s corporate data ...

S.i. Systems
Toronto, Ontario

We require Claims Assessors to be responsible for the processing, review, and communications associated with class action settlement claims. Will also be required to perform administrative duties as required including data entry, clerical duties, and responding to requests and enquiries through emai...

Canadian Institute for Health Information
Toronto, Ontario

The Senior Analyst will contribute to the full range of activities involved in the data quality, analysis and reporting of various primary health care information projects, with a focus on PHC Electronic Medical Record (EMR) data. Responsible for the production and dissemination of data quality and ...

Index Exchange, Inc.
Toronto, Ontario

Our team builds tools and infrastructure to manage this vast amount of data and make it available to both internal and external customers and partners for their reporting and analytics as well as machine model training needs. Evaluate new technologies, design, implement, and maintain data pipelines ...

Lyft
Toronto, Ontario

As a Data Scientist on the Driving XP team, you will collaborate with our world class team of engineers, product managers, and designers to design the end-to-end driving experience for hundreds of thousands of drivers who interact deeply with our app every day. Lyft believes that every person has a ...

Thumbtack
Ontario

As a Data Scientist, you’ll be the person responsible for all the analytical needs of an entire team of engineers, designers, and product/marketing managers -- helping empower the team and Thumbtack more broadly to build the best product, as quickly as possible. Data Scientist embed with product tea...

S.i. Systems
Toronto, Ontario

Senior Quality Assurance Analyst with public sector experience to design and create automated test scripts (Cypress, Selenium, and/or Jest) and API testing using Postman in DevOps environment. This is a primarily remote role but may require occasional travel to Alberta. Experience working in the Pub...