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 expe...Show moreLast updated: 30+ days ago
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The Senior Manager is responsible for assisting in maximizing the profitability of Indigenous B...Show moreLast updated: 20 days ago
Manager, Finance Operations
BrokerLinkMoncton, NB, CA
Full-time
We are looking for a results-driven Finance Operations Manager with over 7 years of experience in.Accounts Payable and Cash Management.
Expertise in optimizing cash flow, streamlining accounts recei...Show moreLast updated: 30+ days ago
PLEASE NOTE - while this is listed as Moncton NB, consideration will be given to candidates in all 4 Atlantic Provinces.This leadership role drives the Commercial Banking Advisors or CBA team to de...Show moreLast updated: 5 days ago
Financial Advisor
RBC - Royal BankMoncton, NB
CA$49,000.00–CA$66,900.00 yearly
As an RBC Financial Advisor, you attract, nurture, and grow relationships with our high-value personal and small business clients by adding value in the moments that matter to them.You provide your...Show moreLast updated: 30+ days ago
Client Development Specialist (Bilingual) - Montreal, QC / Quebec, QC
MD Financial ManagementMoncton, NB
CA$250,000.00–CA$500,000.00 yearly
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.As a Physician Engagement Specialist, you will be responsible for proactively pursuing new clie...Show moreLast updated: 30+ days ago
Promoted
Process Analyst - 53993
Randstad CanadaMoncton, New Brunswick, CA
Temporary
Quick Apply
Are you looking for a challenging role where you will have the opportunity to have a huge impact on an industry leader? Do you have outstanding relationships and a creative streak?.If so, this role...Show moreLast updated: 30+ days ago
Investment Advisor
0000050599 RBC Dominion Securities Inc.MONCTON, New Brunswick, Canada
Full-time
Grow your business, your way – with RBC.As an Investment Advisor at RBC Dominion Securities, you can help your clients reach their goals, while we help you reach yours.
Maybe you’ve dreamed of start...Show moreLast updated: 30+ days ago
First Nations / Metis / Inuit Candidates – Personal and Business Banking - Atlantic Canada
CIBCMoncton, NB
CA$23.00–CA$27.00 hourly
Nous bâtissons une banque axée sur les relations pour un monde moderne.Nous recrutons des professionnels talentueux et passionnés qui ont à cœur de faire ce qu’il faut pour nos clients.À la Banque ...Show moreLast updated: 30+ days ago
Customer Experience Associate - Dieppe
The Toronto-Dominion Bank (Canada)Dieppe, New Brunswick
Part-time
Can you bring your charming self to work and make customer interactions delightful one? Can you process financial transactions accurately and get a sense of achievement by providing excellent custo...Show moreLast updated: 30+ days ago
Hiring Experience Excavator Operator - Residential Construction
Finegrade Excavating]Dieppe, Canada, CA
Full-time
Finegrade Excavating in Dieppe, New Brunswick is now hiring an Experience Excavator Operator in Residential Construction for the busy upcoming season.
Completive wage based on experience.Experience : ...Show moreLast updated: 2 days ago
Promoted
Banking advisor
National BankMoncton, NB, Canada
Full-time
A career as a Banking Advisor at National Bank is a varied role that allows you to live your ambitions and have a positive impact on your own life as well as the lives of your clients and colleague...Show moreLast updated: 30+ days ago
Customer Service Representative
BMONew Brunswick, New Brunswick, Canada
CA$33,850.00–CA$43,500.00 yearly
Part-time
Retail Banking Sales & Service.This role is part time with 18.Delivers exceptional service to BMO customers and prospects.
Identifies customer needs and provides advice and guidance regarding financ...Show moreLast updated: 9 days ago
Bilingual Customer Service Representative
TEKsystemsMoncton,NB,Canada
CA$19.00 hourly
We are looking for a Bilingual Customer Service Representative where you would champion the Banks brand and provide support to our clients as they will interact with us in very different ways; whet...Show moreLast updated: 30+ days ago
Secure Driver (Armed)
GardaWorld CashMoncton, New Brunswick
CA$24.73 hourly
Full-time
Quick Apply
Join a team rich in diversity, respect, and growth to make the world a safer place for families, communities, and businesses.
At GardaWorld Cash Services, we take our security responsibility serious...Show moreLast updated: 30+ days ago
Banking Advisor
NBCMoncton, New Brunswick
CA$49,000.00–CA$66,900.00 yearly
Advisory services, Personal banking.A career as a Banking Advisor at National Bank is a versatile and varied role that allows you to live your ambitions and have a positive impact on your own life ...Show moreLast updated: 30+ days ago
SQL / ETL Developer
CGIMoncton
30+ days ago
Salary
CA$100,000.00 yearly
Job type
Full-time
Job 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