Teradata SQL

• Should be working in client business hours
• Analyze and tune complex Teradata SQL using EXPLAIN plans, DBQL, and Viewpoint to improve query response times and reduce CPU, I/O, and spool usage.
• Identify inefficient access paths, excessive redistributions, product joins, and skewed AMP processing; redesigned queries to maximize parallelism.
• Develop and execute statistics strategies (single-column, multi-column, and incremental stats) to improve optimizer plans and stabilize query performance.
• Optimize join strategies (merge, hash, nested) by reordering joins, applying early filters, and eliminating unnecessary tables and derived steps.
• Recommend and implement Primary Index (PI) and composite PI changes to resolve data skew and improve AMP distribution.
• Designed and tune partitioning strategies (PPI) to enable partition elimination and reduce full-table scans.
• Reduce excessive spool consumption by rewriting SQL, materializing intermediate results using volatile/global temporary tables, and limiting column selection.
• Rewrite inefficient SQL patterns, including subqueries, IN vs EXISTS, function-based predicates, and nested queries, to improve performance and scalability.
• Tune large INSERT, UPDATE, and DELETE operations to minimize locking, logging overhead, and single-AMP processing.
• Collaborated with DBAs, developers, and data architects to resolve performance incidents and meet SLA requirements.
• Document tuning recommendations, standards, and best practices for ongoing performance optimization.
  
  

Behavioural Competencies:

Proven experience of delivering process efficiencies and improvements

Clear and fluent English (both verbal and written)

Ability to build and maintain efficient working relationships with remote teams

Demonstrate ability to take ownership of and accountability for relevant products and services

Ability to plan, prioritize and complete your own work, whilst remaining a team player

Willingness to engage with and work in other technologies

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Pleas

let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.

Your future duties and responsibilities

Required Qualifications To Be Successful In This Role

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.