Capgemini Engineering is a world leader, we provide innovative and unique R&D and engineering services across all industries. Join us for a career full of opportunities, where you can make a difference.
**About the role**:
You will collaborate in a challenging project with a top client in the Energy Industry developing and supporting data integrations using Oracle and Microsoft SQL leveraging SQL jobs, stored procedures, SSIS packages, Azure Data Factory, Data Bricks, and other industry standard tools
**Main Requirements**:
- **
Advanced Microsoft SQL **skills, including proficiency with: Stored procedure and trigger development, schema management, and execution plan optimization
- Experience in **Azure Data** integrating Factory patterns, processes, components, security, linked services, datasets, activities and pipelines, and integration runtimes.
- Capable of constructing resilient data integration processes with an emphasis on data quality management and failure-response planning.
- Experience developing **system health monitoring** solutions (Spotfire, Power BI, etc.)
- ** Expertise in ETL** principles
- Experience extracting data from heterogeneous sources, inlcuding databases, CRM systems, flat file, web services, etc.
- Experience tranforming the extracted data involving: cleaning, aggregating, mapping, and converting it to ensure it meets the business requirements and is in a suitable format for analysis.
- Experience loading the transformed data into a target database, data warehouse, or data lake, making it accesible for querying and analysis
- Advanced English Communication
**What you will love about working with us**:
- At Capgemini Engineering we're always looking ahead. We reimagine possibilities, and we innovate with technology to bring ideas to life.
- We encourage flexibility in how, when, and where people get their work done, allowing a better work-life balance, and greater empowerment. They partner with their managers to find an arrangement that works best for their role and their circumstances.
- We offer game-changing programs to accelerate the growth of our people and the development of their expertise.
**What you need to know about what we offer**:
- Excellent compensation and benefits
- Home office (Inside México)
- Flexibility and balance with your personal and professional life.
- Career path, trainings and real growth opportunities
- Engaging and challenging projects.
- Excellent work environment and culture.
- Open and Effective management.
- Highly professional and collaborative teams.
**About Capgemini Group**
Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 300,000 team members in nearly 50 countries. With its strong 50-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms.