SQL Developer - Remoto

DATA TEST ENGINEER (Guadalajara, On-site)

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 experts think outside the box as they provide unique R&D and engineering services across all industries. Join us for a career full of opportunities. Where you can make a difference. Where no two days are the same.

YOUR ROLE

• Extracting the data from various data sources into the Power BI desktop and transforming the data in Power Query Editor to generate Reports and Dashboards.
• Utilized Power Query in Power BI to Pivot and Un-Pivot the Data Model for Data Cleansing and Data messaging.
• Data validation: Validating Data sources, Extracting data, and applying transformation logic.
• Test planning & Execution: Defining testing scope, preparing test cases and test conditions, and test data preparation.
• Executing Test Cases and Test Scripts, maintaining test execution logs, logging incidents, bugs, and reports.
• Coordinating test activities with Dev, BA & DBA and conducting defect triage for resolution of issues.
• Test quality: Ensuring the quality of their work and the work of the development team.
• QA Test documentation: Creating and maintaining documentation of test plans and test deliverables documents such as QA Estimates, RTM (requirement traceability matrix), peer reviews, and QA sign-off documents.

YOUR PROFILE

• Good conversational English (C1, C2).
• 6+ years of professional experience relevant to the role.
• Experience in working and testing with BI Reports and DAX/MDX queries (Data analysis language).
• BI Tools like Power BI, Tableau, OBIEE, Excel, and SQL servers.
• Working experience in Power Query, Power Pivot, and Power View for creating effective reports and dashboards in Power BI.
• Strong SQL knowledge with the ability to write complex queries (e.g., Left, right joins).
• Strong knowledge in SQL server, MSSQL, Microsoft Azure, ADF and Synapse for data validation.
• Intermediate knowledge on ETL transformations, workflows, STTM mappings (source to target data mappings).
• Ability to test data validation and data transformation from source to target.
• Hands-on experience working on ADO/JIRA for test management, reporting defects, and dashboards creation.
• Ability to identify and report risks and provide mitigation plans.

WHAT YOU'LL LOVE ABOUT WORKING HERE

• At Capgemini Engineering, we encourage flexibility in how, when, and where people get their work done, allowing for 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.
• If you join us, you’ll find we’ll support your career at every stage. We’ll connect you with diverse, worldwide networks and help you take your skills to the next level.
• At Capgemini Engineering, team spirit is very strong, and people feel supported. I’m not just part of a team – I’m part of a community. A friendly, can-do group of people for whom collective effort comes naturally.
  

ABOUT CAPGEMINI

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 every day 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.

Get the future you want!

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 are welcome and will be considered based on merit against the job and/or experience for the position.