Upload Button Icon Add office photos

Filter interviews by

Clear (1)

Accenture Gcp Data Engineer Interview Questions and Answers

Updated 11 Dec 2024

Accenture Gcp Data Engineer Interview Experiences

3 interviews found

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(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...

  • Answered by AI

Interview Preparation Tips

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

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is mean by Partitioning and clustering? Types of partitioning
  • Ans. 

    Partitioning is dividing data into smaller, manageable parts. Clustering is grouping similar data together. Types include range, hash, list, and composite partitioning.

    • Partitioning divides large tables into smaller, more manageable parts based on a chosen criteria.

    • Clustering groups together rows with similar values for one or more columns to improve query performance.

    • Types of partitioning include range partitioning, ha...

  • Answered by AI

Gcp Data Engineer Interview Questions Asked at Other Companies

asked in Cognizant
Q1. GCP Services, What is use of Bigquery? What is Pubsub,Dataflow,cl ... read more
asked in Accenture
Q2. what is Iam what is sa what is bigquery various optimisations joi ... read more
asked in 66degrees
Q3. How to migrate the datawarehouse with gcp services using real tim ... read more
asked in Capgemini
Q4. Explain Google cloud bigquery architecture?
asked in Cognizant
Q5. What is GCP Bigquery, Architecture of BQ, Cloud composer, What Is ... read more
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Coding Test 

Linked list using code for the given question

Interview questions from similar companies

I applied via LinkedIn and was interviewed before Nov 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
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 Resume tips
Round 2 - Technical 

(1 Question)

  • Q1. Ask about the GCP Projects we did before
Round 3 - Technical 

(1 Question)

  • Q1. Managerial questions with salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and try to elaborate your projects. Easy to get into IBM.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(6 Questions)

  • Q1. SQL: Find keys present in table A but not in B(B is old copy of A)
  • Ans. 

    Use SQL to find keys present in table A but not in table B (old copy of A).

    • Use a LEFT JOIN to combine tables A and B based on the key column

    • Filter the results where the key column in table B is NULL

    • This will give you the keys present in table A but not in table B

  • Answered by AI
  • Q2. SQL: 4th highest salary
  • Q3. Case Study: Using GCP's tool make a pipeline to transfer file from one GCS bucket to another
  • Ans. 

    Use GCP Dataflow to transfer files between GCS buckets

    • Create a Dataflow pipeline using Apache Beam to read from source bucket and write to destination bucket

    • Use GCS connector to read and write files in Dataflow pipeline

    • Set up appropriate permissions for Dataflow service account to access both buckets

  • Answered by AI
  • 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
  • Ans. 

    Cloud Composer is another orchestration tool in GCP

    • Cloud Composer is a fully managed workflow orchestration service built on Apache Airflow

    • It allows you to author, schedule, and monitor workflows that span across GCP services

    • Cloud Composer provides a rich set of features like DAGs, plugins, and monitoring capabilities

    • It integrates seamlessly with other GCP services like BigQuery, Dataflow, and Dataproc

  • Answered by AI

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

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

(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

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - One-on-one 

(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
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

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

(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

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and location discussion

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is GCP Bigquery, Architecture of BQ, Cloud composer, What Is DAG . Visualization studio like Looker, data studio.
  • Ans. 

    GCP BigQuery is a serverless, highly scalable, and cost-effective data warehouse for analyzing big data sets.

    • BigQuery is a fully managed, petabyte-scale data warehouse that enables super-fast SQL queries using the processing power of Google's infrastructure.

    • BigQuery's architecture includes storage, Dremel execution engine, and SQL layer.

    • Cloud Composer is a managed workflow orchestration service that helps you create, s...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be prepared for How to design and implement data pipeline by using Gcp big data service like Data Flow, Dataproc.
Having good knowledge of GCP Bigquery and Data transfer service for streaming and batch data.

Skills evaluated in this interview

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

I applied via Company Website and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are sql joins explain About bigquery related
  • Ans. 

    SQL joins are used to combine rows from two or more tables based on a related column between them.

    • SQL joins are used to retrieve data from multiple tables based on a related column between them

    • Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • In BigQuery, joins can be performed using standard SQL syntax

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q2. Bigquery, GCS related
Round 2 - One-on-one 

(1 Question)

  • Q1. About project related questions

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Accenture Interview FAQs

How many rounds are there in Accenture Gcp Data Engineer interview?
Accenture interview process usually has 1 rounds. The most common rounds in the Accenture interview process are Technical and Coding Test.
What are the top questions asked in Accenture Gcp Data Engineer interview?

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

  1. what is Iam what is sa what is bigquery various optimisations joins sql complex...read more
  2. What is mean by Partitioning and clustering? Types of partition...read more

Recently Viewed

DESIGNATION

SALARIES

Fractal Analytics

REVIEWS

TCS

No Reviews

INTERVIEWS

Cognizant

No Interviews

SALARIES

HCLTech

JOBS

Tech Mahindra

No Jobs

DESIGNATION

SALARIES

KPI Partners

SALARIES

EPAM Systems

SALARIES

Tech Mahindra

Tell us how to improve this page.

Accenture Gcp Data Engineer Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
Accenture Gcp Data Engineer Salary
based on 43 salaries
₹3.8 L/yr - ₹13.1 L/yr
6% less than the average Gcp Data Engineer Salary in India
View more details
Application Development Analyst
38.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Application Development - Senior Analyst
26.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Team Lead
24.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
18.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
17.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Accenture with

TCS

3.7
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare

Infosys

3.6
Compare
Did you find this page helpful?
Yes No
write
Share an Interview