Upload Button Icon Add office photos

Accenture

Compare button icon Compare button icon Compare

Filter interviews by

Accenture Gcp Data Engineer Interview Questions, Process, and Tips

Updated 21 Mar 2025

Top Accenture Gcp Data Engineer Interview Questions and Answers

  • 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 terr ...read more
  • Q2. Can you explain the pipeline you have worked on?
  • Q3. What is mean by Partitioning and clustering? Types of partitioning

Accenture Gcp Data Engineer Interview Experiences

4 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
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I appeared for an interview in Sep 2024, where I was asked the following questions.

  • Q1. What is a materialized view?
  • Ans. 

    A materialized view is a database object that stores the result of a query physically, improving performance for complex queries.

    • Materialized views store data physically, unlike regular views which are virtual.

    • They can improve query performance by pre-computing expensive joins and aggregations.

    • Materialized views can be refreshed periodically or on-demand to reflect changes in the underlying data.

    • Example: A materialized...

  • Answered by AI
  • Q2. Can you explain the pipeline you have worked on?
  • Q3. What is time travel
  • Ans. 

    Time travel in data engineering allows querying historical data at specific points in time.

    • Enables querying data as it existed at a previous timestamp.

    • Useful for auditing, debugging, and recovering from errors.

    • Example: In BigQuery, you can use the 'FOR SYSTEM_TIME AS OF' clause.

    • Allows comparison of data changes over time.

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

Accenture interview questions for designations

 Data Engineer

 (78)

 Senior Data Engineer

 (14)

 Azure Data Engineer

 (8)

 Big Data Engineer

 (3)

 Data Engineer 1

 (3)

 Associate Data Engineer

 (3)

 Data Science Engineer

 (2)

 AWS Data Engineer

 (1)

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 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
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(6 Questions)

  • Q1. What are the GCP services used in your project
  • Ans. 

    The GCP services used in our project include BigQuery, Dataflow, Pub/Sub, and Cloud Storage.

    • BigQuery for data warehousing and analytics

    • Dataflow for real-time data processing

    • Pub/Sub for messaging and event ingestion

    • Cloud Storage for storing data and files

  • Answered by AI
  • Q2. What is cloud function
  • Ans. 

    Cloud Functions are event-driven functions that run in response to cloud events.

    • Serverless functions that automatically scale based on demand

    • Can be triggered by events from various cloud services

    • Supports multiple programming languages like Node.js, Python, etc.

  • Answered by AI
  • Q3. How to shedule job to trigger every hr in Airflow
  • Ans. 

    To schedule a job to trigger every hour in Airflow, you can use the Cron schedule interval

    • Define a DAG (Directed Acyclic Graph) in Airflow

    • Set the schedule_interval parameter to '0 * * * *' to trigger the job every hour

    • Example: schedule_interval='0 * * * *'

  • Answered by AI
  • Q4. Bigquey architecture
  • Q5. How display string in reverse using python
  • Ans. 

    Use Python's slicing feature to display a string in reverse order.

    • Use string slicing with a step of -1 to reverse the string.

    • Example: 'hello'[::-1] will output 'olleh'.

  • Answered by AI
  • Q6. What is pub sub and where are you getting used in your project.
  • Ans. 

    Pub/Sub is a messaging service that allows communication between independent applications.

    • Pub/Sub is used for real-time messaging and event-driven systems.

    • It is commonly used for data ingestion, streaming analytics, and event-driven architectures.

    • Examples of Pub/Sub services include Google Cloud Pub/Sub, Apache Kafka, and Amazon SNS/SQS.

  • Answered by AI

I applied via Walk-in and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is big query, topics on python

Interview Preparation Tips

Interview preparation tips for other job seekers - GCP, python, big query airflow and also using python scripting

I applied via Naukri.com and was interviewed before Nov 2021. There were 2 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 tips
Round 2 - Technical 

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

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

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Capgemini Gcp Data Engineer interview:
  • Bigquery
  • Python
  • SQL
  • Terraform
  • SDLC
Interview preparation tips for other job seekers - Prepare well for SQL, Python and GCP Bigquery best practices in detail

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(7 Questions)

  • Q1. Explain your project
  • Ans. 

    Developed a data pipeline to ingest, process, and analyze customer feedback data for a retail company.

    • Used Google Cloud Platform services like BigQuery, Dataflow, and Pub/Sub for data processing.

    • Implemented data cleansing and transformation techniques to ensure data quality.

    • Created visualizations and dashboards using tools like Data Studio for stakeholders to easily interpret the data.

  • Answered by AI
  • Q2. GCP bigquery architecture
  • Q3. Gcp object versioning
  • Q4. Gcp storage class types
  • Ans. 

    GCP offers different storage classes for varying performance and cost requirements.

    • Standard Storage: for frequently accessed data

    • Nearline Storage: for data accessed less frequently

    • Coldline Storage: for data accessed very infrequently

    • Archive Storage: for data stored for long-term retention

  • Answered by AI
  • Q5. Sql optimisation techniques
  • Ans. 

    SQL optimization techniques focus on improving query performance by reducing execution time and resource usage.

    • Use indexes to speed up data retrieval

    • Avoid using SELECT * and instead specify only the columns needed

    • Optimize joins by using appropriate join types and conditions

    • Limit the use of subqueries and instead use JOINs where possible

    • Use EXPLAIN to analyze query execution plans and identify bottlenecks

  • Answered by AI
  • Q6. Sql coding date format and joins related questions
  • Q7. Partitioning and cluster by
Round 2 - One-on-one 

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

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. Can you explain the pipeline you have worked ...read more
  3. What is mean by Partitioning and clustering? Types of partition...read more

Tell us how to improve this page.

Accenture Gcp Data Engineer Interview Process

based on 4 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
5% less than the average Gcp Data Engineer Salary in India
View more details
Application Development Analyst
39k salaries
unlock blur

₹3 L/yr - ₹12 L/yr

Application Development - Senior Analyst
27.4k salaries
unlock blur

₹6.9 L/yr - ₹20.2 L/yr

Team Lead
24.7k salaries
unlock blur

₹7.1 L/yr - ₹26 L/yr

Senior Software Engineer
18.2k salaries
unlock blur

₹6 L/yr - ₹19.1 L/yr

Senior Analyst
17.7k salaries
unlock blur

₹5.5 L/yr - ₹21.3 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