Sr SQL/Azure Data Developer

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 participate in ambitious projects with a top client from 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:

• Bachelor’s degree in Computer Sciences or equivalent and 5+ years of working experience

• Advanced Microsoft SQL and Azure Data Factory skills, including proficiency with: 

• Experience integrating Azure Data Factory patterns, processes, components, security, linked services, datasets, activities and pipelines, and integration runtimes. 

• Experience loading the transformed data into a target database, data warehouse, or data lake, making it accessible for querying and analysis. 

• Experience transforming 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 extracting data from heterogeneous sources, including databases, CRM systems, flat file, web services, etc. 

• Expertise in ETL principles 

• Experience developing system health monitoring solutions with industry standard tools (Spotfire, Power BI, etc.) 

• Capable of constructing resilient data integration processes with an emphasis on data quality management and failure-response planning. 

• Stored procedure and trigger development, schema management, and execution plan optimization 

• Conversational English

Nice to have (extra skills):
-Test automation experience

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

· Remote job 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.

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.