GCP Data Engineer

Other Jobs To Apply

<span class="jobdescription"><div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><h2 style="font-size:1.0em;margin:0.0px">Job Description</h2> </div><div><p><strong>REQUIREMENTS</strong></p> <p> </p> <ul> <li>3+YOE in Data Engineering and working with GCP, GCP Big Query </li> <li>Knowledge on Data warehouse </li> <li>Experienc working with Data forms </li> <li>Excellent data engineering skills including expert SQL, data modeling, and query optimization </li> <li>Strong experience with big data stack (Spark, PySpark, Hadoop, HIVE, BigQuery, Pub/Sub) in building scalable ETL pipelines </li> <li>Excellent programming skills (Python) including production level coding techniques (testing, OOP structures, optimization, etc) </li> <li>Data visualization and dashboarding experience </li> <li>Great at debugging, troubleshooting, designing, and implementing solutions to complex technical issues </li> <li>Aptitude to independently learn new technologies, prototype, and propose solutions </li> <li>Advanced English level</li> </ul> <p> </p> <p><strong>RESPONSIBILITIES</strong></p> <p> </p> <ul> <li>Design a cloud-based data warehouse using BigQuery to support analytical workloads. Define fact and dimension tables, apply appropriate partitioning and clustering strategies, and document the data model.</li> <li>Build a scalable ETL pipeline using PySpark on GCP that ingests raw data, applies transformations, and writes curated data to BigQuery. Implement error handling, logging, unit tests, and modular OOP-based code.</li> <li> <div>Design and implement a real-time data ingestion solution using Pub/Sub and Dataflow to process streaming events and store aggregated results in BigQuery.</div> </li> <li> <div>Use Dataform to build, version, and manage SQL-based transformations in BigQuery. Define dependencies, apply data quality assertions, and automate pipeline execution.</div> </li> <li> <div>Create a dashboard using BigQuery as the data source (e.g., Looker or Looker Studio). Optimize queries for performance and explain metrics, KPIs, and design decisions to stakeholders.</div> </li> </ul></div></div><div style="padding:10.0px 0.0px;border:1.0px solid transparent"><div style="font-size:16.0px;word-wrap:break-word"><h2 style="font-size:1.0em;margin:0.0px">About Capgemini Group</h2> </div><div><p>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.</p> <p> </p> <p><strong>What you will love about working with us:</strong></p> <ul> <li>At Capgemini we’re always looking ahead.</li> <li>We reimagine possibilities, and we innovate with technology to bring ideas to life.</li> <li>We encourage flexibility in how, when, and where people get their work done, allowing a better work-life balance, and greater empowerment.</li> <li>They partner with their managers to find an arrangement that works best for their role and their circumstances.</li> <li>We offer game-changing programs to accelerate the growth of our people and the development of their expertise.</li> </ul> <p> </p> <p><strong>What you need to know about what we offer:</strong></p> <ul> <li>Excellent compensation and benefits</li> <li>Career path, trainings and real growth opportunities</li> <li>Engaging and challenging projects.</li> <li>Excellent work environment and culture.</li> <li>Open and Effective management.</li> <li>Highly professional and collaborative teams.</li> </ul> <p> </p> <p>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.</p></div></div></div> </span>

Back to blog
Ads

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...