SQL Applications Developer

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.
• Troublshoot data quality issues across 3rd party and custom applications.

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:

• Prior work experience with large scale data management applications
• 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.
  

At Capgemini Mexico, we aim to attract the best talent and are committed to creating a diverse and inclusive work environment, so there is no discrimination based on race, sex, sexual orientation, gender identity or expression, or any other characteristic of a person. All applications welcome and will be considered based on merit against the job and/or experience for the position.

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.