Current jobs related to SQL / ETL Developer - Fredericton - CGI


  • Fredericton, New Brunswick, Canada Alcool NB Liquor Full time

    About the PositionWe are seeking a highly skilled ERP Solution Integration Developer to join our team at Alcool NB Liquor. As a key member of our IT department, you will play a critical role in designing, testing, and implementing integrations between various systems and applications.Key ResponsibilitiesDevelop strategies and design architectures for systems...


  • Fredericton, New Brunswick, Canada Alcool NB Liquor Full time

    About the PositionWe are seeking a highly skilled ERP Solution Integration Developer to join our team at Alcool NB Liquor. As a key member of our IT department, you will play a critical role in designing, testing, and implementing integrations between various systems and applications.Key ResponsibilitiesDevelop strategies and design architectures for systems...


  • Fredericton, New Brunswick, Canada Alcool NB Liquor Full time

    About the RoleWe are seeking an experienced ERP Solution Integration Developer to join our team at Alcool NB Liquor. As a key member of our IT department, you will be responsible for designing, testing, and implementing integrations between various systems and applications.Key ResponsibilitiesDeveloping strategies and designing architectures for systems...


  • Fredericton, New Brunswick, Canada Alcool NB Liquor Full time

    About the RoleWe are seeking an experienced ERP Solution Integration Developer to join our team at Alcool NB Liquor. As a key member of our IT department, you will be responsible for designing, testing, and implementing integrations between various systems and applications.Key ResponsibilitiesDeveloping strategies and designing architectures for systems...


  • Fredericton, New Brunswick, Canada Mariner Full time

    Summary: We are seeking an Oracle APEX Developer to design, develop, and implement applications using the Oracle Application Express (APEX) platform. Mariner innovates always and everywhere, turning novel ideas into practical solutions. Our purpose has always been to be a great, everlasting technology company for those who make an impact - elevating people,...


  • Fredericton, New Brunswick, Canada Mariner Full time

    About the RoleWe are seeking a skilled Oracle APEX Developer to join our team at Mariner. As a key member of our technology team, you will design, develop, and implement applications using the Oracle Application Express (APEX) platform.Key ResponsibilitiesDesign and develop web applications using Oracle Application Express (APEX).Work with Oracle databases...


  • Fredericton, New Brunswick, Canada Mariner Full time

    About the RoleWe are seeking a skilled Oracle APEX Developer to join our team at Mariner. As a key member of our technology team, you will design, develop, and implement applications using the Oracle Application Express (APEX) platform.Key ResponsibilitiesDesign and develop web applications using Oracle Application Express (APEX).Work with Oracle databases...


  • Fredericton, New Brunswick, Canada Mariner Full time

    About the RoleWe are seeking a skilled Oracle APEX Developer to join our team at Mariner. As a key member of our technology team, you will design, develop, and implement applications using the Oracle Application Express (APEX) platform.Key ResponsibilitiesDesign and develop web applications using Oracle Application Express (APEX).Work with Oracle databases...


  • Fredericton, New Brunswick, Canada Alcool NB Liquor Full time

    About the PositionWe are seeking an ERP Solution Integration Developer for a 2-year term to design, test, and implement integrations between various systems and applications. Reporting to the ERP Solution Integration Lead and in collaboration with the external System Integrator partner, they will support system configurations and implement data integrations...


  • Fredericton, Canada New Brunswick Liquor Co Full time

    Solution Integration Analyst/Developer 2-year term ANBL Alcool NB Liquor is embarking on a multi-year business transformation project, including the implementation of Microsoft D365. About the position We are seeking an ERP Solution Integration Developer for a 2-year term to design, test, and implement integrations between various systems and applications....


  • Fredericton, Canada New Brunswick Liquor Co Full time

    Solution Integration Analyst/Developer 2-year term ANBL Alcool NB Liquor is embarking on a multi-year business transformation project, including the implementation of Microsoft D365. About the position We are seeking an ERP Solution Integration Developer for a 2-year term to design, test, and implement integrations between various systems and applications....


  • Fredericton, Canada Alcool NB Liquor Full time

     Solution Integration Analyst/Developer  2-year term ANBL Alcool NB Liquor is embarking on a multi-year business transformation project, including the implementation of Microsoft D365. About the position We are seeking an ERP Solution Integration Developer for a 2-year term to design, test, and implement integrations between various systems...


  • Fredericton, New Brunswick, Canada Alcool NB Liquor Full time

    About the PositionWe are seeking an ERP Solution Integration Developer for a 2-year term to design, test, and implement integrations between various systems and applications. Reporting to the ERP Solution Integration Lead and in collaboration with the external System Integrator partner, they will support system configurations and implement data integrations...


  • Fredericton, New Brunswick, Canada CareerBeacon Full time

    Transformative Software Development OpportunitiesWe're seeking talented individuals to join our Software Development team, where you'll have the chance to make a meaningful impact on our customers' experiences. As a member of our team, you'll be part of a collaborative and innovative environment that fosters growth and development.Key...


  • Fredericton, New Brunswick, Canada CareerBeacon Full time

    Transformative Software Development OpportunitiesWe're seeking talented individuals to join our Software Development team, where you'll have the chance to make a meaningful impact on our customers' experiences. As a member of our team, you'll be part of a collaborative and innovative environment that fosters growth and development.Key...


  • Fredericton, Canada Mariner Remote Work Freelance Full time

    COMPANY DESCRIPTION Mariner innovates always and everywhere, turning novel ideas into practical solutions. From products and services to venture creation, we build better futures powered by people. Our purpose has always been to be a great, everlasting technology company for those who make an impact - elevating people, data, and technology in the best way to...


  • Fredericton, New Brunswick, Canada NR Consulting Full time

    Job Title: BizTalk Integration DeveloperJob Summary:NR Consulting is seeking a highly skilled BizTalk Integration Developer to join our team. As a key member of our integration team, you will be responsible for designing, developing, and implementing HL7 interfaces with MS BizTalk Server.Key Responsibilities:Design and develop HL7 interfaces with MS BizTalk...


  • Fredericton, New Brunswick, Canada NR Consulting Full time

    Job Title: BizTalk Integration DeveloperJob Summary:NR Consulting is seeking a highly skilled BizTalk Integration Developer to join our team. As a key member of our integration team, you will be responsible for designing, developing, and implementing HL7 interfaces with MS BizTalk Server.Key Responsibilities:Design and develop HL7 interfaces with MS BizTalk...


  • Fredericton, New Brunswick, Canada Insight Enterprises, Inc. Full time

    Job Summary:We are seeking a highly skilled Senior Software Developer to join our team at Insight Enterprises, Inc. as a Senior.Net Developer. This is a 4-month contract employment opportunity in the automotive industry.About the Role:As a Senior Software Developer, you will be responsible for developing scalable software solutions, integrating with multiple...


  • Fredericton, New Brunswick, Canada Insight Enterprises, Inc. Full time

    Job Summary:We are seeking a highly skilled Senior Software Developer to join our team at Insight Enterprises, Inc. as a Senior.Net Developer. This is a 4-month contract employment opportunity in the automotive industry.About the Role:As a Senior Software Developer, you will be responsible for developing scalable software solutions, integrating with multiple...

SQL / ETL Developer

4 months ago


Fredericton, Canada CGI Full time

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