C

Capgemini

Global consulting, technology services, outsourcing

Senior Infrastructure Consultant

Data EngineeringUpdated on Nov 14
Full-timeToronto, ON, Canada

About the Job

Requirements

  • Unix experience.
  • Linux experience.
  • ETL experience.
  • SQL experience.
  • API experience.

Responsibilities

  • Build and optimize scalable data integration processes using tools such as SnapLogic, SSIS, Informatica, or Talend.
  • Clean, deduplicate, and format data to ensure reliable and consistent data for end-users.
  • Structure and define the storage of large-scale datasets within data warehouses or data lakes.
  • Troubleshoot pipeline failures, monitor data quality, and schedule continuous data updates.
  • Work with business analysts, data scientists, and solutions architects to align data workflows with business needs.
  • Set up automated logging and error notifications, such as with Databricks ETL tools, to detect pipeline failures before they affect business decisions.
  • Investigate failed jobs, identify corrupted data, and apply hotfixes or trigger automated data-recovery routines.
  • Diagnose bottlenecks and refine transformation logic to minimize processing overhead and shorten maintenance windows.
  • Manage schema drift and update connectors when third-party APIs or source databases change.
  • Develop and optimize complex T-SQL queries, stored procedures, functions, and triggers to support business rules and reporting.
  • Write and maintain Unix/Linux shell scripts, such as Bash or Korn, to automate batch processing, data extraction, and file transfers.
  • Investigate, troubleshoot, and resolve database application issues and server faults, and ensure high availability for critical business applications.
  • Analyze execution plans, manage indexes, and fine-tune SQL queries and server configurations to improve throughput.
  • Build procedures to extract, transform, and load large datasets between disparate systems and flat files.
  • Work with DBAs, developers, and QA teams to support deployment, maintenance, and system upgrades.
  • Perform hands-on on-premises IT maintenance, including managing hardware, software updates, and server downtime, where applicable.
  • Support cloud and SaaS environments where providers generally handle infrastructure management, upgrades, and connector maintenance, focusing the support team on data quality and business logic.

About the Company

Capgemini

Global consulting, technology services, outsourcing

Capgemini provides consulting, technology services, and outsourcing to help organizations transform digitally. Its offerings include strategy and transformation consulting, system integration, application development, IT infrastructure management, and managed IT operations. It differentiates itself with a global presence in over 50 countries and a focus on applying AI, cloud, and cybersecurity to real business problems. Its goal is to help clients navigate digital transformation and improve efficiency and innovation through tailored, contract-based or managed services.

Company size
10,001+
Company stage
IPO
Headquarters
Paris, France
Founded
1967

Recently Posted Jobs

Explore more opportunities at Capgemini

See more jobs