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 :
- Business Development
- Banking
- Credit Unions
- Detail-oriented
- Technical Analysis
SQL / ETL Developer
CGI is offering an exciting opportunity as a ETL / SQL Developer. Minimum 6+ years’ of IT experience with extensive focus on delivering SQL Solutions, preferably MS SQL Server using SSRS and SSIS or PostgreSQL. Writing optimized SQL queries for integration with other applications. Identify and test ...
National Database Administrator
National Database Administrator. National Database Administrator. Breakthrough T1D if growing our IT team and we’re searching for a new team member who is experienced with CRM databases, for the role of. Develop and deliver reusable user-friendly queries for recurring or ad hoc dashboard views...
Staff Data Engineer
Data Architecture: Design and develop large-scale data systems, including databases, data warehouses, and big data platforms, with a strong focus on data governance and compliance requirements. Your expertise in software engineering, data systems, and data governance will play a critical role in bui...
Online Data Analyst Canada (French Language)
A Day in the Life of an Online Data Analyst:. Completing research and evaluation tasks in a web-based environment such as verifying and comparing data, and determining the relevance and accuracy of information. ...
Business Analyst
Mindwire is currently seeking a Business Analyst to work for our valued client. Utilize business analysis techniques to uncover business needs and translate them into inputs to be delivered by Agile teams. Recognize pro-actively where solutions impact related applications, business processes, or dat...
National Database Administrator
National Database Administrator. National Database Administrator. Breakthrough T1D if growing our IT team and we’re searching for a new team member who is experienced with CRM databases, for the role of. Develop and deliver reusable user-friendly queries for recurring or ad hoc dashboard views...
administrator, database
Develop and maintain computer databases. Operate database management systems to analyze data. Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models. ...
Senior Software QA Engineer (TOSCA/SAP)
The Testing Consultancy (TTC) is a global specialist software testing company with a focus on helping organizations transform the way they deliver quality software. The primary purpose of the Senior Software QA Engineer is to lead and deliver testing services using industry standards and best practi...
Backend Product Software Engineer, DocSend Platform
As a Software Engineer on the DocSend Platform team, you will play a key role in tackling the scalability challenges we face as DocSend rapidly grows. Our Engineering Career Framework is and describes what’s expected for our engineers at each of our career levels. Act as a mentor throughout the soft...
Senior Big Data Hadoop ML Engineer (GCP) - Canada
We are seeking a highly skilled and experienced Senior Big Data Engineer to join our dynamic team. This role involves working in Java, and working on Machine Learning pipelines for data collection or batch inference. Leverage GCP for scalable big data processing and storage solutions. Proven experie...