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.
- Analyze functional requirements and translate them into technical solutions.
- Implement data loading, validation, transformation, and processing workflows.
- Monitor and support production data integration processes and resolve related incidents.
- 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 with Git.
- Document technical processes, pipelines, and developed components.
- Apply data security and governance practices in Google Cloud Platform.
- Develop automation for operational and data integration processes.
- Collaborate with architects, technical leaders, business teams, and multidisciplinary groups.
- Provide support and maintenance for implemented solutions.
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.
- Knowledge of relational data modeling, SQL functions, stored procedures, query optimization, and database permissions and roles.
- Experience designing and developing data integration pipelines, ETL/ELT processes, data quality pipelines, and data transformations.
- Experience monitoring, validating, debugging, and troubleshooting data processes in production environments.
- Knowledge of GCP-based data solution design, Workflows, data security, cloud data handling, and integration projects.
- Experience with Git, version control, technical documentation, and code-quality practices.
- Ability to convert functional requirements into technical solutions and work with multidisciplinary teams.
- Preferred experience with Python, process automation, BigQuery, Cloud Functions, Cloud Storage, Secret Manager, Cloud Logging, and Cloud Monitoring.
- Preferred knowledge of event-driven architectures, cloud service integration, data platform modernization, and analytics or reporting on GCP.
- Strategic technical leadership, architectural thinking, business perspective, stakeholder influence and negotiation, effective communication, and complex problem-solving skills.
Benefits
- On-site work in Mexico City or Estado de México.
- Capgemini offers competitive compensation and benefits above those required by law.
- Collaborative and inclusive work environment with recruitment and onboarding support.
- Opportunities to develop professional skills and plan a career within Capgemini.
- Work with functional, technical, and business specialists on client technology solutions.
- Exposure to Capgemini's global methodologies and international presence.
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.
