SQL / ETL Developer - Stratford, Canada - CGI

CGI Stratford, Canada

2 weeks ago

Full time

Description

Position Description:

CGI is offering an exciting opportunity as a ETL / SQL Developer. As a member of CGI's national practice providing retail banking solutions and services to credit unions, you will be joining an experienced and dynamic team of global IT professionals serving our clients across Canada and the world.

Your future duties and responsibilities:

Key Responsibilities:

•Designing database tables and structures, creating views, functions and stored procedures

•Writing optimized SQL queries for integration with other applications

•Creating database triggers for use in automation

•Identify and test for bugs and bottlenecks in the ETL solution

•Support with developing Source-to-Staging-to-Target mappings and actively work with Development, Test and Implementation efforts

•Design data migration processes including collection of source data, data transfer mechanism and data upload mechanism

•Responsible for capturing data validations that impact the migration process and liaise with data stewards to assess data quality gaps on legacy data against those validations.

•Maintaining data quality, overseeing database security and privacy relating to customer data

Other Responsibilities:

•Maintain a solid understanding of software testing best practices, methodologies, and terminologies

•Lead, coach and mentor other members

Required qualifications to be successful in this role:

Required Experience:

•Minimum 6+ years' of IT experience with extensive focus on delivering SQL Solutions, preferably MS SQL Server using SSRS and SSIS or PostgreSQL

•Hands on experience with designing, building, coding, testing & deploying SQL Queries, stored procedures, functions

•Exposure to ETL/Data Integration activities is mandatory

Nice to Have:

•Experience with scheduling Data Loads using 3rd party tools is highly desirable

•Exposure to MySQL Database

•Experience with Data vault modeling and development

•Experience using Python and API's

•Experience working with Jira, SharePoint,

•Experience in retail banking and/or credit union space

•Exposure to ETL Projects that involved handling Transactional/Normalized Data is highly desirable

Soft Skills:

•Self-motivated with attention to detail and exceptional organizational skills with the ability to balance immediate and longer term tasks and requirements

•Excellent presentation skills, ability to cater messages depending on the audience.

•Strong sense of ownership and ability to drive tasks through to completion

•Demonstrate the ability to provide information and ideas in a clear, comprehensive, concise and organized manner

Required Level of Education:

•Bachelor's Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience

#LI-MT1

Skills:

Business Development

Banking

Credit Unions

Detail-oriented

ETL

Technical Analysis

Gcp Sme

3 weeks ago

Emonics Waterloo, Canada

GCP and GCP functionalities like running DAGs, troubleshooting when there is a failure, console, and all other features present in GCP tool. · - Complex query writing, procedures, routines in Big Query. · - Bigdata testing and tools. · - Any automation experience on tables-to-tab ...
Manager, Data Solutions

2 weeks ago

Sun Life Waterloo, Canada

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspir ...
Intermediate Financial Systems Analyst

1 week ago

Manulife Waterloo, Canada

**_Are you looking for a supportive, collaborative workplace with great teams and inspiring leaders? You've come to the right place. We're looking for ambitious people who share our values and want to make every day better for people around the world. If this sounds like you, and ...
Data Analyst

1 week ago

Vm Groups London, Canada

**Data Analyst Job Duties** · Data analyst responsibilities include conducting full lifecycle analysis to include requirements, activities and design. Data analysts will develop analysis and reporting capabilities. They will also monitor performance and quality control plans to i ...
790465 - Early-career Environmental Data Technician

3 weeks ago

Geosyntec Consultants Waterloo, Canada

If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data T ...
790440 - Early-career Environmental Data Specialist

3 weeks ago

Geosyntec Consultants Waterloo, Canada

If you re looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data S ...
Student, Decision Support, Hmms

2 weeks ago

St. Joseph's Health Care London London, Canada

Posting # [ Non-Union ] · Student, Decision Support, HMMS · HMMS · Healthcare Materials Management - London, ON · Temporary Full Time · HMMS is a joint venture between St. Joseph's Health Care, London and London Health Sciences Centre, that has been operating since 1997 providing ...
IT Technical Data Analyst

2 weeks ago

Descartes Waterloo, Canada

**Descartes Unites the People and Technology that Move the World** · The need for efficient, secure, and agile supply chains and logistics operations has become ever more critical and complex. By combining innovative technology, powerful trade intelligence and the reach of our ne ...
Decision Support Analyst, Hmms

1 week ago

St. Joseph's Health Care London London, Canada

Posting # [ Non-Union ] · Decision Support Analyst, HMMS · HMMS · Healthcare Materials Management - London, ON · Temporary Full Time · - HMMS is a joint venture between St. Joseph's Health Care, London and London Health Sciences Centre, that has been operating since 1997 providin ...
Early-career Environmental Data Technician

3 weeks ago

Geosyntec Consultants, Inc. Waterloo, Canada

If you're looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data T ...
Early-career Environmental Data Specialist

3 weeks ago

Geosyntec Consultants, Inc. Waterloo, Canada

If you're looking for a place to grow your career, where you can contribute to a dynamic innovative firm, tackle challenging project work, and collaborate with industry recognized professionals - Geosyntec is the place for you We are seeking an **Early-Career Environmental Data S ...
Institutional Analyst

2 weeks ago

University of Waterloo Waterloo, Canada

Overview: · **Term: 1 Year** · Under the direction and guidance of IAP leadership, the Institutional Analyst (IA) is responsible for the development of databases, models, analyses, and reporting as well as communicating the results of analyses internal and external to IAP. The IA ...
Director, Portfolio Architecture

2 weeks ago

Canada Life Assurance Company London, Canada

Director, Portfolio Architecture - Business Automation · **Description: · - Permanent Full Time- Canada Life's Enterprise Architecture team works collaboratively with our business and IT partners developing technology strategies and roadmaps enabling the successful delivery of st ...
Cloud Infrastructure Analyst

2 weeks ago

Sun Life Waterloo, Canada

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspir ...
Cloud Infrastructure Analyst

3 weeks ago

Sun Life Waterloo, Canada

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspir ...
Enterprise Data Governance Analyst

2 weeks ago

D2L Kitchener, Canada

D2L is a cloud company that is modernizing education and building the Future of Work. The old models of teaching and learning are in the midst of the largest transformation in history, and D2L is at the heart of that fundamental shift. · New models of teaching and learning enable ...
Reporting Specialist

3 weeks ago

Quorum Information Technologies Inc London, Canada

**Reporting Specialist** · **Location** - Remote · **Reports To** - Development Manager, Software Development · **Quorum is currently looking for a Report Specialist to join our growing team.** · As a Report Specialist, you will be a part of our Data and Reporting Team responsibl ...
Integration Consultant

1 week ago

Sun Life Waterloo, Canada

You are as unique as your background, experience and point of view. Here, you'll be encouraged, empowered and challenged to be your best self. You'll work with dynamic colleagues - experts in their fields - who are eager to share their knowledge with you. Your leaders will inspir ...
Database Integration Specialist

3 weeks ago

Compugen Inc Waterloo, Canada

**Job Title** · - Database Integration Specialist · **Vacancy No** · - VN5943 · **Work Location** · - Waterloo, ON · **Job Details** · **About Compugen** · Compugen is one of Canada's largest privately-owned Information Technology (IT) Solution Providers. We help customers design ...
Product Insight Analyst

1 week ago

D2L Kitchener, Canada

D2L is a cloud company that is modernizing education and building the Future of Work. The old models of teaching and learning are in the midst of the largest transformation in history, and D2L is at the heart of that fundamental shift. · New models of teaching and learning enable ...