Data Engineer with ETL, Python/PySpark & PL/SQL

Overview

Hybrid
$80,000 - $100,000
Full Time

Skills

PySpark
Python
SQL
PL/SQL
Data Quality
Extract
Transform
Load
ETL
ETL Process

Job Details

Position Title : Data Engineer with ETL, Python/PySpark & PL/SQL
Location : Mississauga, ON (Hybrid)
Experience : 8-12 Years in Data Technologies
Employee Type : Full Time with Benefits


Job Description

The ideal candidate will be responsible for designing, developing, and maintaining ETL processes, data pipelines, and database solutions to support our growing data needs.

This role requires a strong understanding of data warehousing concepts, experience with various ETL tools, and proficiency in Python, PL/SQL, and database technologies.

 

Responsibilities:

  • Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into our data warehouse.
  • Write complex SQL queries and PL/SQL scripts to perform data manipulation, validation, and transformation.
  • Develop and maintain data pipelines using Python and related libraries (e.g., Polar ,Pandas).
  • Optimize ETL processes and data pipelines for performance and scalability.
  • Collaborate with data analysts and other stakeholders to understand data requirements and develop solutions to meet their needs.
  • Implement data quality checks and monitoring to ensure data accuracy and consistency.
  • Troubleshoot and resolve data-related issues.
  • Create and maintain technical documentation for ETL processes, data pipelines, and database solutions.
  • Stay up-to-date with the latest trends and technologies in data management and analytics.

Skills:

  • Python/PySpark
  • ETL
  • PL/SQL
  • SQL
  • Data Warehousing
  • Data Modeling
  • Database Management
  • Problem Solving
  • Communication
  • Teamwork

Disclaimer
Capgemini is an Equal Opportunity Employer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, national origin, sex, gender identity or expression, age, religion, disability, sexual orientation, genetic information, citizenship status, veteran status, marital status, or any other characteristic protected by applicable law.

This is a general description of the duties, responsibilities and qualifications required for this position. Physical, mental, sensory, or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Capgemini America, Inc.