AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Capgemini
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini Gcp Data Engineer Interview Questions, Process, and Tips
Top Capgemini Gcp Data Engineer Interview Questions and Answers
- Q1. Explain Google cloud bigquery architecture?
- Q2. Python: list and Tupple differences
- Q3. Write code to find max number of product by customer
Capgemini Gcp Data Engineer Interview Experiences
5 interviews found
Anonymous
I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Questions on SQL Joins and Window Functions
- Q2. GCP Big query and Cloud Storage qs
(2 Questions)
- Q1. About overall IT experience
- Q2. Project experience and services used
- Ans.
I have experience working on projects involving data processing, transformation, and analysis using GCP services like BigQuery, Dataflow, and Dataproc.
Utilized BigQuery for storing and querying large datasets
Implemented data pipelines using Dataflow for real-time data processing
Utilized Dataproc for running Apache Spark and Hadoop clusters for data processing
Worked on data ingestion and transformation using Cloud Stora
Kiran Gurbani
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(10 Questions)
- Q1. Tools and Technology used in current project
- Q2. What is Managed Table, external table, Materialised view
- Q3. What is data flow? Working of data flow
- Q4. Clusters in data proc, Types of clusters, Machine type used in cluster
- Q5. Airflow - how to add email in airflow job - how to monitor jobs in airflow -Python Operator in airflow
- Q6. Narrow , wide and broadcast transformation
- Q7. Window functions
- Q8. What is shuffle partition
- Q9. How to identify file size in python
- Q10. Which languages can be used in data flow
Bhau Rakhapasare
(5 Questions)
- Q1. What is windows function bigquery
- Ans.
Window functions in BigQuery are used to perform calculations across a set of table rows related to the current row.
Window functions allow you to perform calculations on a set of rows related to the current row
They are used with the OVER() clause in SQL queries
Common window functions include ROW_NUMBER(), RANK(), and NTILE()
They can be used to calculate moving averages, cumulative sums, and more
- Q2. What types on nosql databases in gcp
- Ans.
Types of NoSQL databases in GCP include Firestore, Bigtable, and Datastore.
Firestore is a flexible, scalable database for mobile, web, and server development.
Bigtable is a high-performance NoSQL database service for large analytical and operational workloads.
Datastore is a highly scalable NoSQL database for web and mobile applications.
- Q3. Write code to find max number of product by customer
- Ans.
Code to find max number of product by customer
Iterate through each customer's purchases
Keep track of the count of each product for each customer
Find the product with the maximum count for each customer
- Q4. Read dataframe python and pyspark
- Q5. Create dataframe
- Ans.
Creating a dataframe in GCP Data Engineer
Use the pandas library to create a dataframe
Provide data in the form of a dictionary or list of lists
Specify column names if needed
Skills evaluated in this interview
What people are saying about Capgemini
(2 Questions)
- Q1. Questions on BigQuery, SQL, GCP data services which you have worked on
- Q2. Python small coding question and one SQL query
Capgemini interview questions for designations
I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Explain Google cloud bigquery architecture?
- Ans.
Google Cloud BigQuery is a fully-managed, serverless data warehouse that uses a distributed architecture for processing and analyzing large datasets.
BigQuery uses a distributed storage system called Capacitor for storing and managing data.
It uses a distributed query engine called Dremel for executing SQL-like queries on large datasets.
BigQuery separates storage and compute, allowing users to scale compute resources ind...
- Q2. Python: list and Tupple differences
- Ans.
List and tuple are both used to store collections of data, but they have some differences.
Lists are mutable while tuples are immutable
Lists use square brackets [] while tuples use parentheses ()
Lists are typically used for collections of homogeneous data while tuples are used for heterogeneous data
Lists have more built-in methods than tuples
Interview Preparation Tips
- Bigquery
- Python
- SQL
- Terraform
- SDLC
Skills evaluated in this interview
Get interview-ready with Top Capgemini Interview Questions
Interview questions from similar companies
I was interviewed in Jan 2025.
(8 Questions)
- Q1. Self intro and project architecture
- Q2. What are the data sources used?
- Q3. Bigquery architecture
- Q4. Partition vs clustering
- Q5. Bq commands on create table and load csv file
- Q6. Bq commands on show the schema of the table
- Q7. Explain about leaf nodes and columnar storage.
- Q8. How many slots are there in bigquery?
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
(7 Questions)
- Q1. Explain your project
- Q2. GCP bigquery architecture
- Q3. Gcp object versioning
- Q4. Gcp storage class types
- Q5. Sql optimisation techniques
- Q6. Sql coding date format and joins related questions
- Q7. Partitioning and cluster by
(2 Questions)
- Q1. Advanced sql recursive cte and python code using lambda function to explode the list
- Q2. Project explanation and daily activity and challenge faced in project
Interview Preparation Tips
- SQL
- PYSPARK
- GCP
- PYTHON
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(1 Question)
- Q1. What is Iam what is sa what is bigquery various optimisations joins sql complex query what is qliksense GIThub schema routines schedules delete drop truncate GUI and terraform related spark basics file fo...
- Ans.
IAM is Identity and Access Management, SA is Service Account, BigQuery is a data warehouse, QlikSense is a data visualization tool, GitHub is a version control system, Spark is a distributed computing framework, Airflow is a workflow automation tool, Bigtable is a NoSQL database, Cloud Composer is a managed workflow orchestration service, Pub/Sub is a messaging service.
IAM is used to manage access to resources in Googl...
Interview Preparation Tips
- SQL
- Python
- pyspark
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(3 Questions)
- Q1. String is palindrome or not
- Ans.
Check if a string is a palindrome or not
Compare the string with its reverse to check for palindrome
Ignore spaces and punctuation marks when comparing
Examples: 'racecar' is a palindrome, 'hello' is not
- Q2. Create gcs bucket using python
- Ans.
Use Python to create a GCS bucket
Import the necessary libraries like google.cloud.storage
Authenticate using service account credentials
Use the library functions to create a new bucket
- Q3. Write a python code to trigger a dataflow job in cloud function
- Ans.
Python code to trigger a dataflow job in cloud function
Use the googleapiclient library to interact with the Dataflow API
Authenticate using service account credentials
Submit a job to Dataflow using the projects.locations.templates.launch endpoint
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Sep 2023. There were 3 interview rounds.
(1 Question)
- Q1. Bigquery architecture, Advanced SQL question scenario based, cloud storage questions,pubsub,dataflow
(1 Question)
- Q1. Used cases on bigquery and sql
- Ans.
BigQuery is used for analyzing large datasets and running complex queries, while SQL is used for querying databases.
BigQuery is used for analyzing large datasets quickly and efficiently
SQL is used for querying databases to retrieve specific data
BigQuery can handle petabytes of data, making it ideal for big data analysis
SQL can be used to perform operations like filtering, sorting, and aggregating data
(1 Question)
- Q1. Salary discussion and location discussion
Skills evaluated in this interview
Capgemini Interview FAQs
Tell us how to improve this page.
Capgemini Interviews By Designations
- Capgemini Analyst Interview Questions
- Capgemini Consultant Interview Questions
- Capgemini Software Engineer Interview Questions
- Capgemini Senior Consultant Interview Questions
- Capgemini Associate Consultant Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Analyst Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Show more
Capgemini Gcp Data Engineer Interview Process
based on 5 interviews
1 Interview rounds
- Technical Round
Gcp Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Capgemini Gcp Data Engineer Reviews and Ratings
based on 8 reviews
Rating in categories
|
Consultant
55.2k
salaries
|  ₹5.2 L/yr - ₹17.5 L/yr |
|
Associate Consultant
50.8k
salaries
| ₹3 L/yr - ₹10 L/yr |
|
Senior Consultant
46.1k
salaries
| ₹7.5 L/yr - ₹24.5 L/yr |
|
Senior Analyst
20.6k
salaries
| ₹2 L/yr - ₹7.5 L/yr |
|
Senior Software Engineer
20.2k
salaries
| ₹3.5 L/yr - ₹12.1 L/yr |
Wipro
Accenture
Cognizant
TCS
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Gcp Data Engineer Interview Questions
