SQL / ETL Developer

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: