SQL / ETL Developer
CGIStratford, Canada30+ days ago
Salary
CAD100000 yearlyJob type
- Full-time
Job descriptionMaintain a solid understanding of software testing best practices, methodologies, and terminologies Lead, coach and mentor other members 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 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 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 Bachelor’s Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience Business Development Banking Credit Unions Detail-oriented Technical Analysis
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 :
Required qualifications to be successful in this role :
Required Experience :
Nice to Have :
Soft Skills :
Required Level of Education :
LI-MT1
Skills :