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
Full-time

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

6 days ago
Related jobs
S.i. Systems
Toronto, Ontario

Lead by example: Set the tone for a data-driven culture within your team by incorporating data analysis in discussions, encouraging data-backed solutions, and recognizing and promoting data literacy efforts among team members. Collaborate with platform leadership team to define what constitutes cust...

Zonda
Canada Remote
Remote

Zonda is looking for a passionate Senior Data Engineer to evolve and expand our team. As a Senior Data Engineer, you will play a crucial role in designing, implementing, and optimizing our data infrastructure. Collaborate with cross-functional teams to integrate data from various sources into the SQ...

S.i. Systems
Toronto, Ontario

Cash flow projects- experience with the FR- A report. Postman- dealing with and Familiar with API’s. Good exp with confluence/ Jira. Liquidity risk/ Cash Flow projects – 5 years. ...

Huawei Technologies Canada Co., Ltd.
Markham, Ontario

Domain expertise in the implementation of one or more of the following:  AI end to end data processing, scenarios and system optimizations, core database internals (Ex: query optimization, runtime, scheduling, storage engine, transaction processing, etc. Experience leading teams and products to gene...

University of Toronto
Ontario, Canada

Meet with or respond to students inquiries during office hours. Minimum Qualifications Must have completed and achieved a minimum grade of “A” in MGT200 or equivalent course. Dutiesa) Grading quizzes, tests, assignments & exams. Update material and grades on Quercus courseware. ...

Lumerate
Toronto, Ontario

We believe that the business world is a collection of complex information niches that end up with crummy software and information products  because they aren't mainstream enough for any one SaaS company to focus on. Already picturing your first day as our Senior Data Analyst? Apply now with you...

Astellas
Markham, Ontario

The scope of this role includes designing and implementing solutions to data and analytics use cases tailored to the unique requirements of life sciences research and development and managing day to day operations and enhancements of multiple data and analytics foundational platforms. We work to cre...

System One
Toronto, Ontario

Extensive understanding and/or prior experience with engineering lifecycles, delivery, and HW/SW integration lifecycle and demonstrate the ability to deliver solutions to closure. Demonstrated ability to lead, engage, and manage tasking of cross-functional teams of varying skills/experience. Prefer ...

NTT DATA
Toronto, Ontario
Remote

Familiar with the concepts of SDLC with proficiency in mapping business requirements, technical documentation, application design, development and troubleshooting for information systems management. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and tr...

Aritzia
Canada, Canada

As a Senior Data Analyst, Digital at Aritzia, you will combine your deep understanding of digital customer experiences with your passion for data and masterful analytics skills to drive decisions that will create long lasting relationships with our customers and enhance outcomes for our eCommerce bu...