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 ...
Early Career Data Analyst - WFH
Assists in the application of data analysis and data modeling techniques to establish, modify, and maintain basic data structures and their entity descriptions, relationship descriptions, and attribute definitions according to client specifications. Participates in the development and maintenance of...
Data Engineer
Skills Databricks Skills Python or Java PySpark Spark Spark SQL ETL Hadoop Databricks certification. Mandatory Certificate Databricks Certified Developer Apache Spark 3 0. A good professional with at least 6 9 yrs of experience in BigData PySpark HIVE Oracle PL SQL. Databricks-SparkSQL-Scala/Python/...
Entry Level Software Developer (remote)
Currently, We are looking for entry-level software programmers, Java Full stack developers, Python/Java developers, Data analysts/ Data Scientists, Machine Learning engineers for full time positions with clients. REQUIRED SKILLS For Java /Full stack/Software Programmer. Experience in programming lan...
Data Engineer Ii, Marlboro Or Chelmsford, Hybrid/remote, Full-time
The mid-level Data Engineer II plays an important role in the implementation of Enterprise Data Management (EDM) Solutions at DCU. They will be working closely with Cloud Development, Data Architecture, Data Modeling, and Quality Assurance teams to modernize and maintain the DCU data ecosystem to su...
Data Analyst
This position must be able to acquire detailed knowledge on how data is stored and organized in a variety of business systems; some specific systems include Outage Management systems (OMS), Geographic Information Systems (GIS), Customer Information Systems (CIS) and Meter Data Management Systems (MD...
Software Developer
ASE is looking for an experienced Software Developer to work in support of Naval Air Warfare Center Training Systems Division (NAWCTSD) in Orlando, Florida. Updates software or enhance existing software capabilities. Researches, designs, and develops computer and network software or specialized util...
Sql Developer
Our growing team needs an experienced SQL Developer. The primary function of the Lead Developer is to provide project guidance and accountability to a team of developers, produce complex and straightforward code for new and existing applications. Provide one-on-one feedback to developers on individu...
Data Engineer
CGS is seeking a passionate and driven Data Engineer to support a rapidly growing Data Analytics and Business Intelligence platform focused on providing solutions that empower our federal customers with the tools and capabilities needed to turn data into actionable insights. Complete development eff...
Senior Professional Data Analyst
Senior Professional Data Analyst. Assist in optimizing SQL queries and data workflows to improve data landing time. Contribute to the design and build of data pipelines and dashboards that stakeholders can use to meet their needs. Support the maintenance and improvement of existing data infrastructu...