Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
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...
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...
I appeared for an interview in Sep 2024, where I was asked the following questions.
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...
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.
What people are saying about Accenture
I applied via LinkedIn and was interviewed in Dec 2023. There was 1 interview round.
Linked list using code for the given question
Accenture interview questions for designations
I applied via LinkedIn and was interviewed before Nov 2021. There were 3 interview rounds.
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
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.
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 * * * *'
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'.
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.
I applied via Walk-in and was interviewed in Mar 2022. There was 1 interview round.
I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
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...
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
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
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.
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
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
I applied via Company Website and was interviewed in Sep 2023. There were 3 interview rounds.
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
Some of the top questions asked at the Accenture Gcp Data Engineer interview -
based on 4 interviews
Interview experience
Application Development Analyst
39k
salaries
| ₹3 L/yr - ₹12 L/yr |
Application Development - Senior Analyst
27.4k
salaries
| ₹6.9 L/yr - ₹20.2 L/yr |
Team Lead
24.7k
salaries
| ₹7.1 L/yr - ₹26 L/yr |
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹19.1 L/yr |
Senior Analyst
17.7k
salaries
| ₹5.5 L/yr - ₹21.3 L/yr |
TCS
Cognizant
Capgemini
Infosys