About CGI

Founded in 1976, CGI is one of the world's largest independent IT and business consulting services firms, with approximately 94,000 consultants and professionals globally.

CGI provides strategic IT and business consulting, systems integration, managed IT and business process services, and intellectual property solutions. The company works with clients through a local relationship model supported by a global delivery network.

Position Description

The selected candidate will work on data engineering and data warehouse activities using ETL tools such as Informatica PowerCenter, SSIS, DataStage or Talend.

The role also involves Bash, Python, SQL, PySpark, Databricks, Delta Lake and Apache Airflow. Candidates should understand data processing, job scheduling and the responsible use of LLM-based coding assistants.

Future Duties & Responsibilities

• Work on data warehousing, data engineering and data warehouse operations.
• Use Informatica PowerCenter or comparable ETL tools such as SSIS, DataStage and Talend.
• Read and understand ETL mappings and workflow XML.
• Understand ETL concepts, including data types, NULL values, duplicates and rounding differences.
• Work with job scheduling concepts, including dependencies, calendars and retries.
• Support data engineering activities using Bash, Python and SQL.
• Use Python and PySpark for data processing activities.
• Work with Databricks notebooks, Delta Lake and Databricks Workflows.
• Understand Apache Airflow concepts, including DAGs, operators and sensors.
• Understand how Databricks jobs are triggered.
• Use LLM-based coding assistants responsibly to support development activities.

Required Qualifications & Skills

• 1–4 years of experience in data warehousing, data engineering or data warehouse operations.
• Working-level knowledge of Bash, Python and SQL.
• Hands-on experience with Informatica PowerCenter or comparable ETL tools such as SSIS, DataStage or Talend.
• Ability to read and understand ETL mappings and workflow XML.
• Understanding of ETL concepts, data types, NULL values, duplicates and rounding differences.
• Understanding of job scheduling concepts, including dependencies, calendars and retries.
• Experience with schedulers such as Control-M, AutoSys, Robot or Cron.
• Basic knowledge of Python and PySpark.
• Beginner-to-working-level knowledge of Databricks notebooks, Delta Lake and Databricks Workflows.
• Basic understanding of Apache Airflow, including DAGs, operators and sensors.
• Experience using LLM-based coding assistants responsibly.

Good-to-Have Skills

• Exposure to Databricks job-triggering mechanisms.
• Familiarity with multiple ETL tools such as Informatica PowerCenter, SSIS, DataStage or Talend.
• Exposure to Apache Airflow and workflow orchestration.
• Familiarity with AI-assisted development tools and LLM-based coding assistants.

Key Skills

• Analytical Thinking
• Artificial Intelligence
• AWS AI Services
• Communication
• Database
• Machine Learning
• Python

Life at CGI

Life at CGI is rooted in ownership, teamwork, respect and belonging. CGI professionals are called CGI Partners and are encouraged to contribute to the company's collective success and shape its future.

Employees have opportunities to develop innovative solutions, build relationships with colleagues and clients, expand technical expertise and grow their careers with support from experienced leaders.

What You Can Expect From CGI

• A culture based on ownership, teamwork, respect and belonging.
• Opportunities to work on innovative solutions and meaningful projects.
• Access to global capabilities and technology expertise.
• Opportunities to deepen technical skills and grow professionally.
• A workplace committed to fairness and equal opportunity.

Equal Opportunity & Recruitment Notice

CGI is an equal opportunity employer and is committed to providing reasonable accommodation to people with disabilities during the recruitment process.

AI tools may be used to support application assessment. However, they do not replace human judgment, and final hiring decisions remain with CGI recruitment professionals.