SQL / ETL Developer

CGI is offering an exciting opportunity as an 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
• Identifying and testing for bugs and bottlenecks in the ETL solution
• Supporting the development of Source-to-Staging-to-Target mappings and actively working with Development, Test, and Implementation efforts
• Designing data migration processes including collection of source data, data transfer mechanism, and data upload mechanism
• Capturing data validations that impact the migration process and liaising 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:

• Maintaining a solid understanding of software testing best practices, methodologies, and terminologies
• Leading, coaching, and mentoring 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, and deploying SQL Queries, stored procedures, and 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 APIs
• Experience working with Jira and 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