SQL / ETL Developer
Category: Software Development/ Engineering
Main location: Canada, Nova Scotia, Halifax
Alternate Location(s):
Canada, New Brunswick, Moncton, Fredericton
Canada, P. E. I., Stratford
Canada, Newfoundland and Labrador, St. Johns
Position ID: J0524-0028
Employment Type: 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
Skills:
- Business Development
- Banking
- Credit Unions
- Detail-oriented
- ETL
- Technical Analysis
What you can expect from us:
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
Come join our team—one of the largest IT and business consulting services firms in the world.