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.
Tech Stack
Categories
Data Engineering
About Capgemini
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.
