C

Capgemini

Global consulting, technology services, outsourcing

Abl – Data Engineer GCP Postgresql

Data EngineeringUpdated on Nov 14
Full-timeMexico City, CDMX, MexicoNo salary listed

About the Job

Requirements

  • At least 2 years of experience in data engineering.
  • Practical, verifiable experience with Google Cloud Platform (GCP).
  • Experience with PostgreSQL and AlloyDB for PostgreSQL.
  • Advanced SQL skills, including PL/SQL and Transact-SQL.
  • Experience designing relational data models and developing SQL functions and stored procedures.
  • Experience optimizing SQL queries and database performance.
  • Experience administering database permissions and roles.
  • Experience with Cloud Data Fusion and designing and developing data integration pipelines.
  • Experience with ETL, ELT, data quality pipelines, data integration, data transformation, and information loading and processing.
  • Experience monitoring data pipelines and troubleshooting integration processes.
  • Experience designing data solutions on GCP, working with workflows, and validating and debugging data processes.
  • Experience resolving incidents in production environments.
  • Experience with Git, version control, and technical documentation.
  • Knowledge of data security on GCP, code quality practices, and managing data in cloud environments.
  • Experience participating in data integration projects and working with multidisciplinary teams.
  • Ability to translate functional requirements into technical solutions.

Responsibilities

  • Design and implement data quality pipelines on Google Cloud Platform.
  • Develop and maintain data integration solutions using Cloud Data Fusion.
  • Design, develop, and optimize ETL and ELT processes.
  • Build data components using PostgreSQL and AlloyDB.
  • Develop functions, stored procedures, and data transformation logic.
  • Analyze functional requirements and translate them into technical solutions.
  • Implement information loading, validation, and transformation processes.
  • Monitor and support production data integration processes.
  • Analyze and resolve incidents related to databases and pipelines.
  • Optimize SQL queries and database performance.
  • Design relational data models.
  • Implement data quality and integrity controls.
  • Participate in testing, deployments, and validation of data solutions.
  • Collaborate with architects, technical leads, and multidisciplinary teams.
  • Manage repositories and version control using Git.
  • Document technical processes, pipelines, and developed components.
  • Apply data security and governance best practices in GCP.
  • Develop automations for operational and integration processes.
  • Participate in ceremonies and activities under agile methodologies.
  • Provide support and maintenance for implemented solutions.
  • Analyze, design, and develop client technology solutions; work with functional, technical, and business specialists to implement and integrate solutions and systems; and provide timely services and products that support client satisfaction.

Desired Qualifications

  • Python.
  • Process automation.
  • BigQuery.
  • Cloud Functions.
  • Cloud Storage.
  • Secret Manager.
  • Cloud Logging.
  • Cloud Monitoring.
  • Agile methodologies and Scrum.
  • Event-driven architectures.
  • DevOps.
  • Cloud service integration.
  • Experience with data platform modernization projects.
  • Knowledge of analytics and reporting on GCP.

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