SQL / ETL Developer

CGI; Fredericton; On-site; CAD 80,000 - 120,000; Full time

Job summary

CGI offers an exciting opportunity as an ETL / SQL Developer. Join a dynamic team providing innovative retail banking solutions, maintaining data quality, and leading projects in a collaborative environment. Candidates with 6+ years of SQL experience and a degree in Computer Science are encouraged to apply.

Qualifications

• Minimum 6+ years of IT experience focused on SQL solutions.
• Hands-on experience designing, building, and deploying SQL queries.
• Experience with ETL/Data Integration activities required.

Responsibilities

• Design database tables and structures; create views, functions, and stored procedures.
• Write optimized SQL queries for data integration.
• Maintain data quality and oversee database security.

Skills

SQL Solutions

ETL / Data Integration

Database Security

Data Quality Management

Presentation Skills

Organizational Skills

Attention to Detail

Ownership

Education

Bachelor’s Degree in Computer Science

Tools

SSRS

SSIS

PostgreSQL

MySQL

Jira

SharePoint

Job 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
• 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