21 days ago
Remote, MexicoSenior
Responsibilities
- Lead migration of critical banking data assets from SQL Server to Snowflake, Databricks, and Hive.
- Design, optimize, and support scalable ETL and data processing pipelines.
- Investigate complex systems, troubleshoot data issues, and independently drive resolutions.
- Partner with architects, product teams, and business stakeholders to define data requirements and improve data models.
- Establish best practices for SQL development, Airflow orchestration, data quality, and performance optimization.
Requirements
- 5+ years of experience designing, developing, and supporting enterprise-scale data solutions.
- Advanced SQL skills, including complex query development, optimization, troubleshooting, and high-volume data transformations.
- Proven experience designing, developing, and supporting enterprise ETL/ELT pipelines.
- Hands-on Snowflake experience and exposure to Databricks, including performance optimization and large-scale data processing.
- Strong knowledge of Airflow and data modeling, including schema design, partitioning, and query performance tuning.
- Ability to analyze, debug, and resolve complex data pipeline issues independently.
- Fluent English.
Benefits
- Meaningful projects using technology to solve real-world challenges.
- Work in an organization committed to sustainability, inclusion, and digital equity.
- Remote work from any 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.