Capgemini

ABL - Data Engineer

Capgemini
Apply
13 days ago
Aguascalientes, MexicoMid Level

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 for PostgreSQL.
  • Develop SQL functions, stored procedures, and data transformation logic.
  • Implement data loading, validation, and transformation processes.
  • Monitor, support, troubleshoot, and resolve incidents affecting production data pipelines.
  • Optimize SQL queries and database performance.
  • Design relational data models and implement data quality and integrity controls.
  • Participate in testing, deployments, and solution validations.
  • Manage repositories and version control using Git.
  • Document technical processes, pipelines, and developed components.
  • Apply data security and governance practices in Google Cloud Platform.
  • Develop automations for operational and data integration processes.
  • Collaborate with architects, technical leaders, business stakeholders, and multidisciplinary teams.

Requirements

  • At least 2 years of experience in Data Engineering.
  • Practical, demonstrable experience with Google Cloud Platform.
  • Experience with PostgreSQL, AlloyDB for PostgreSQL, advanced SQL, PL/SQL, and Transact-SQL.
  • Experience designing relational data models and developing SQL functions and stored procedures.
  • Experience optimizing SQL queries and administering database permissions and roles.
  • Experience with Cloud Data Fusion, data integration pipelines, ETL, ELT, data quality pipelines, and data transformation.
  • Experience monitoring, validating, debugging, and troubleshooting data processes in production environments.
  • Experience designing data solutions and using Workflows on Google Cloud Platform.
  • Experience with Git, version control, technical documentation, data security, and cloud data environments.
  • Experience participating in data integration projects and working with multidisciplinary teams.
  • Ability to convert functional requirements into technical solutions.
  • Preferred experience with Python, BigQuery, Cloud Functions, Cloud Storage, Secret Manager, Cloud Logging, and Cloud Monitoring.
  • Preferred knowledge of process automation, event-driven architectures, cloud service integration, data platform modernization, and analytics or reporting on Google Cloud Platform.
  • Preferred understanding of DevOps practices and Scrum.

Benefits

  • Competitive compensation and benefits above those required by law.
  • Collaborative, diverse, and inclusive work environment.
  • Recruitment and onboarding support.
  • Career planning and professional development opportunities.
  • Work arrangement: onsite in Mexico City or the State of Mexico.

Categories

Data Engineering
Capgemini

About Capgemini

10,000+ employees

Capgemini is a global IT services and consulting firm that delivers strategy, cloud, AI, software engineering, and managed services to large enterprises and public-sector clients. Founded in 1967 and headquartered in Paris, it is publicly traded on Euronext Paris and operates in 50+ countries. The group expanded its engineering capabilities by acquiring Altran in 2020, now operating as Capgemini Engineering.

Contact me