Data Engineer

**Sr Data Engineer**:(México GDL, 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**- Build reusable code and libraries for future use- Accurately translate user and business needs into functional frontend code- Advanced English**YOUR PROFILE**- 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- 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.- Strong SQL knowledge with ability to write complex queries (example Left, right joins etc..)- Strong knowledge in SQL server, MSSQL, Microsoft Azure, ADF and synapse for nata base 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- Test planning & Execution: Defining testing scope, Prepares test cases and test conditions, Test Data preparation- Executes Test Cases and Test Scripts, Maintains test execution logs, Logs incidents, Bugs, Reports- Coordinating test activities with Dev, BA & DBA and conduct 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, test deliverables document such as QA Estimates, RTM (requirement traceability matrix, Peer reviews, QA sign-off documents.- Hands experience working on ADO/JIRA for test management, reporting defects and Dashboards creation.Ability to Identify and report the risks and provide the mitigation plans. Coordinate with internal and external teams for completion of activities.**What You’ll Love About Working Here**- At Capgemini Engineering, 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.- 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 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.**Get the future you want