Python Job: Python - SQL Developer

Job added on




Halifax - Canada

Job type


Python Job Details

Position Description:

CGI is offering an exciting opportunity as a Python / 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.

The financial industry is in the midst of dramatic change and credit unions are challenged with finding faster, more innovative ways of providing solutions and services to their customers who have more alternatives than ever before. Digital transformation and digital services are disrupting traditional financial institutions, instead offering businesses and households access to services that are customized specifically to personalized needs and wants of the end consumer. Omni-channel experience, mobile self-service, predictive analytics, data governance, robotic process automation, FinTech partnerships, and open banking requirements have turned the banking industry on its head. Staying relevant is key while customer retention and growth has never been more challenging. Our clients are turning to CGI to help them remodel their operations and assist in navigating through the massive digital transformational changes required to remain competitive.

Key Responsibilities:
  • Designing database tables and structures, creating views, functions and stored procedures
  • Writing optimized SQL queries for integration with other applications
  • Creating reports using Python
  • 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 using API's
  • 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.

Other Responsibilities:
  • Maintain a solid understanding of software testing best practices, methodologies, and terminologies
  • Lead, coach and mentor other members
  • 100% adherence to CGI policies (Member Commitment to the Code of Ethics and Business Conduct, Dress Code, Travel, Expenses, etc.)

Required Experience:
  • Experience using Python
  • Experience with Relational SQL (Oracle, Postgres, SQL Server) databases, Postgres preferred
  • Experience working on data migration projects

Nice to Have:
  • Proficient with AWS Native services like Amazon S3, Amazon Redshift, RDS, EC2, EMR Lambda, Step Functions, Sage Maker etc.
  • Experience working with API's using Python
  • Possess knowledge of Agile or Scaled Agile Frameworks, certifications are a plus.
  • Experience working with Jira, SharePoint,
  • Experience in retail banking and/or credit union space

Soft Skills:
  • Self-motivated with attention to detail and exceptional organizational skills with the ability to balance immediate and longer term tasks and requirements
  • 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


  • Python
  • SQL
  • Banking
  • Credit Unions
  • Detail-oriented
  • Data Migration

What you can expect from us:

Insights you can act on

While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees "members" because they are CGI shareholders and owners and owners who enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today — one of the world’s largest independent providers of IT and business consulting services.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Ready to become part of our success story? Join CGI — where your ideas and actions make a difference.