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...
Senior Business Systems Analyst
We expect the Business System Analyst to be a trusted partner to our business team with a passion for technology and with proven Business Analyst capabilities. As a Business Systems Analyst in Integrated Informatics, you will work closely with our IT team and our business partners in Medical Affairs...
Technical Business Analyst - Metal Trading and Risk System
Works independently as a senior or lead business analyst and coaches and guides members within area of expertise. Support business with defining the business need or problem and identifying potential solutions. Works closely with the trading and sales desks to plan, elicit, analyze, document, commun...
CRM Business Analyst & Product Trainer | Macropus Global Ltd
January 2009 with a vision of providing best services in the field of Information Technology Consulting Business Services. Must have extensive Business Analysis and Implementation experience in CRM. Responsibility of documentation and updating of the existing CRM knowledge kit and work with IT and b...
Staff Data Analyst, Core Experience
TextNow is looking for an experienced Staff Data Analyst to fuel the next stage of our growth. Skilled in extracting and transforming data from Snowflake warehouse using SQL. Respectfully candid with the ability to collaborate with multiple stakeholders as well as peers on the data team. ...
Senior Database Administrator
Worldline is hiring a senior database administrator to join our North America IT operations team. As a Worldline DBA, you will be a critical member of the team managing our production and non-production databases. You will build, configure, and optimize SQL Server database engines in a variety of en...
Full Stack Software Engineer II- D&D Beyond
As a Full Stack Software Engineer working on the D&D team you will help design and build the clients and services that will power the next generation of D&D’s best-in-class digital toolset and marketplace, D&D Beyond. At least 2 years of experience as a software engineer building service...
Analyst - Business Valuation
Now, we are partnering with them looking to bring an Analyst - Business Valuation to their team in Saint John. Ocean Capital Holdings Limited is a privately held company located in Saint John, NB with interests across a number of business lines, including broadcasting, real-estate, construction, ind...
Java Lead Software Engineer
Mentoring and Vision: As a Lead Engineer the Software Engineer, Orchestration will Set the technical direction, mentor the software engineers, and ensure the code quality for the Orchestration Layer team. Intersog® is a Chicago-based provider of software engineering, custom development, and IT consu...