At Capgemini Engineering, the world leader in engineering services, we bring together a global team of engineers, scientists, and architects to help the world's most innovative companies unleash their potential. From autonomous cars to life-saving robots, our digital and software technology.
**Your Role**
- Develop and support data integrations using Oracle and Microsoft SQL leveraging SQL jobs, stored procedures, SSIS packages, Azure Data Factory, Data Bricks, and other industry standard tools.
- Provide ongoing innovative improvements to current ETL processes.
**Your Profile**
- Bachelor's Degree in Computer Systems or related Engineering.
- Advanced Microsoft SQL and Azure Data Factory skills, including proficiency with: Stored procedure and trigger development, schema management, and execution plan optimization
- Capable of constructing resilient data integration processes with an emphasis on data quality management and failure-response planning.
- Experience developing system health monitoring solutions with industry standard tools (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.
- Experience integrating Azure Data Factory patterns, processes, components, security, linked services, datasets, activities and pipelines, and integration runtimes.
**Preferred Knowledge/Skills/Abilities**:
- Experience in Process Automation
- Experience with C++ and Python
- Experience/Familiarity with Agile methodologies (ADO, Scrum, Kanban, etc)
- Excellent communication skills (verbal and written)
**WHAT YOU'LL LOVE ABOUT WORKING HERE?**
- Capgemini Employer Promise: Learning + Flexibility + Team Spirit + Inclusion + Innovation.
- Work from home: fully remote position.
- Get competitive benefits above the law.
- Build your future within a worldwide leader in ER&D projects.
- Feel free to grow within different industries and choose your career path.
- Be part of a great family of Engineers, and people all over Mexico and the world.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.
