Upload Button Icon Add office photos

Filter interviews by

66degrees Gcp Data Engineer Interview Questions and Answers

Updated 6 Apr 2023

1 interview found

Sort by: Popular

Gcp Data Engineer Interview Questions

user image Anonymous

posted on 6 Apr 2023

Interview experience
1
 Bad
Difficulty level
 -
Duration
 -
Result
 -

2 Interview Rounds

1

Resume Shortlist Round

Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2

Technical Round (3 Questions)

  • Q1. What services in gcp u have used
  • Q2. How to create data pipeline in gcp
  • Q3. How to migrate the datawarehouse with gcp services using real time data services

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with hands on on google cloud platform and sql.
Because they want you to write query infront of them

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via Naukri.com and was interviewed in Nov 2024.

2 Interview Rounds

1

One-on-one Round (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

One-on-one Round (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

Topics to prepare for Tech Mahindra Gcp Data Engineer interview:
  • SQL
  • PYSPARK
  • GCP
  • PYTHON
Interview preparation tips for other job seekers - Practice SQL and Python coding extensively; they are evaluating our problem-solving approach and logic, as well as the depth of knowledge we possess.
Interview experience
1
 Bad
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

Technical Round (6 Questions)

  • Q1. What are the GCP services used in your project
  • Q2. What is cloud function
  • Q3. How to shedule job to trigger every hr in Airflow
  • Q4. Bigquey architecture
  • Q5. How display string in reverse using python
  • Q6. What is pub sub and where are you getting used in your project.
Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 -

I applied via Naukri.com and was interviewed in Oct 2024.

2 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Topics asked Advanced SQL spark dataproc Bigquery Qliksense Git Hub Any innovations or process optimised or not Google Cloud
2

Behavioral Round (1 Question)

  • Q1. Bigquery spark hadoop hive questions asked on above topics Why are you changing? what extra can you bring with you? whats motivating you to join Deloitte?

Interview Preparation Tips

Topics to prepare for Deloitte Gcp Data Engineer interview:
  • sql
  • bigquery
  • Spark
  • Hadoop
  • dataproc
  • GCP
Interview preparation tips for other job seekers - prepare well
Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 Less than 2 weeks
Result
 No response

I applied via LinkedIn and was interviewed in Oct 2024.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. Questions on SQL Joins and Window Functions
  • Q2. GCP Big query and Cloud Storage qs
2

HR Round (2 Questions)

  • Q1. About overall IT experience
  • Q2. Project experience and services used
Interview experience
5
 Excellent
Difficulty level
 Hard
Duration
 Less than 2 weeks
Result
 -

I applied via Naukri.com and was interviewed in Oct 2024.

1 Interview Round

1

Technical 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 GU...read more

Interview Preparation Tips

Topics to prepare for Accenture Gcp Data Engineer interview:
  • SQL
  • Python
  • pyspark

Skills evaluated in this interview

Gcp Data Engineer Interview Questions

TCS user image Anonymous

posted on 17 Jul 2024

Interview experience
4
 Good
Difficulty level
 Easy
Duration
 2-4 weeks
Result
Selected  Selected

I applied via Naukri.com and was interviewed in Jun 2024.

1 Interview Round

1

Technical Round (3 Questions)

  • Q1. String is palindrome or not
  • Q2. Create gcs bucket using python
  • Q3. Write a python code to trigger a dataflow job in cloud function

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 -
Duration
 -
Result
 -

1 Interview Round

1

One-on-one Round (6 Questions)

  • Q1. SQL: Find keys present in table A but not in B(B is old copy of A)
  • Q2. SQL: 4th highest salary
  • Q3. Case Study: Using GCP's tool make a pipeline to transfer file from one GCS bucket to another
  • Q4. Case Study: A new joiner in IT, how will you explain flow of project and ownership of work. Considering my YOE 3 years
  • Q5. Explain your project, and reasons behind why did you choose airflow over other orchestration tool.
  • Q6. Discuss other orchestration tool in GCP

Skills evaluated in this interview

Interview experience
4
 Good
Difficulty level
 Moderate
Duration
 6-8 weeks
Result
Selected  Selected

I applied via Company Website and was interviewed in Sep 2023.

3 Interview Rounds

1

Technical Round (1 Question)

  • Q1. Bigquery architecture, Advanced SQL question scenario based, cloud storage questions,pubsub,dataflow
2

Technical Round (1 Question)

  • Q1. Used cases on bigquery and sql
3

HR Round (1 Question)

  • Q1. Salary discussion and location discussion

Skills evaluated in this interview

Interview experience
5
 Excellent
Difficulty level
 Moderate
Duration
 2-4 weeks
Result
 Not Selected

I applied via Company Website and was interviewed before Mar 2023.

2 Interview Rounds

1

Technical Round (2 Questions)

  • Q1. What are sql joins explain About bigquery related
  • Q2. Bigquery, GCS related
2

One-on-one Round (1 Question)

  • Q1. About project related questions

Skills evaluated in this interview

66degrees Interview FAQs

How many rounds are there in 66degrees Gcp Data Engineer interview?
66degrees interview process usually has 2 rounds. The most common rounds in the 66degrees interview process are Resume Shortlist and Technical.
What are the top questions asked in 66degrees Gcp Data Engineer interview?

Some of the top questions asked at the 66degrees Gcp Data Engineer interview -

  1. How to migrate the datawarehouse with gcp services using real time data servi...read more
  2. How to create data pipeline in ...read more
  3. What services in gcp u have u...read more

Tell us how to improve this page.

QA Engineer
5 salaries
unlock blur

₹9 L/yr - ₹16.5 L/yr

Senior Cloud Engineer
5 salaries
unlock blur

₹15.1 L/yr - ₹38 L/yr

Engineering Manager
4 salaries
unlock blur

₹42 L/yr - ₹42 L/yr

Senior Software Engineer
4 salaries
unlock blur

₹19 L/yr - ₹30 L/yr

Data Engineer
4 salaries
unlock blur

₹15.2 L/yr - ₹30 L/yr

Explore more salaries
Compare 66degrees with

MakeMyTrip

3.7
Compare

Yatra

3.4
Compare

Cleartrip

3.4
Compare

Goibibo

4.3
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview