Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via Naukri.com and was interviewed in Apr 2022. There was 1 interview round.
Use --split-by option in sqoop to import data from RDMS without primary key
Use --split-by option to specify a column to split the import into multiple mappers
Use --boundary-query option to specify a query to determine the range of values for --split-by column
Example: sqoop import --connect jdbc:mysql://localhost/mydb --username root --password password --table mytable --split-by id
Example: sqoop import --connect jdbc:m...
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.
I would rate myself 4 in Pyspark, 5 in Python, and 4 in SQL.
Strong proficiency in Python programming language
Experience in working with Pyspark for big data processing
Proficient in writing complex SQL queries for data manipulation
Familiarity with optimizing queries for performance
Hands-on experience in data engineering projects
Use Python's built-in data structures like sets or dictionaries to handle duplicates.
Use a set to remove duplicates from a list: unique_list = list(set(original_list))
Use a dictionary to remove duplicates from a list while preserving order: unique_list = list(dict.fromkeys(original_list))
Use Databricks provided tools like databricks-connect and databricks-cli to migrate Hive metadata to Unity catalog.
Use databricks-connect to connect to the Databricks workspace from your local development environment.
Use databricks-cli to export the Hive metadata from the existing Hive metastore.
Create a new Unity catalog in Databricks and import the exported metadata using databricks-cli.
Validate the migration by chec...
To read a CSV file from an ADLS path, you can use libraries like pandas or pyspark.
Use pandas library in Python to read a CSV file from ADLS path
Use pyspark library in Python to read a CSV file from ADLS path
Ensure you have the necessary permissions to access the ADLS path
The number of stages created from the code provided depends on the specific code and its functionality.
The number of stages can vary based on the complexity of the code and the specific tasks being performed.
Stages may include data extraction, transformation, loading, and processing.
It is important to analyze the code and identify distinct stages to determine the total number.
Narrow transformation processes one record at a time, while wide transformation processes multiple records at once.
Narrow transformation processes one record at a time, making it easier to parallelize and optimize.
Wide transformation processes multiple records at once, which can lead to shuffling and performance issues.
Examples of narrow transformations include map and filter operations, while examples of wide transfor
Actions and transformations are key concepts in data engineering, involving the manipulation and processing of data.
Actions are operations that trigger the execution of a data transformation job in a distributed computing environment.
Transformations are functions that take an input dataset and produce an output dataset, often involving filtering, aggregating, or joining data.
Examples of actions include 'saveAsTextFile'...
Enforcing the schema ensures data consistency and validation, while manually defining the schema in code allows for more flexibility and customization.
Enforcing the schema ensures that all data conforms to a predefined structure and format, preventing errors and inconsistencies.
Manually defining the schema in code allows for more flexibility in handling different data types and structures.
Enforcing the schema can be do...
Optimizations like partitioning, caching, and using efficient file formats can reduce overhead in reading large datasets in Spark.
Partitioning data based on key can reduce the amount of data shuffled during joins and aggregations
Caching frequently accessed datasets in memory can avoid recomputation
Using efficient file formats like Parquet or ORC can reduce disk I/O and improve read performance
SQL query to find the name of person who logged in last within each country from Person Table
Use a subquery to find the max login time for each country
Join the Person table with the subquery on country and login time to get the name of the person
List is mutable, Tuple is immutable in Python.
List can be modified after creation, Tuple cannot be modified.
List is defined using square brackets [], Tuple is defined using parentheses ().
Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Rank assigns a unique rank to each row, Dense Rank assigns a unique rank to each distinct row, and Row Number assigns a unique number to each row.
Rank assigns the same rank to rows with the same value, leaving gaps in the ranking if there are ties.
Dense Rank assigns a unique rank to each distinct row, leaving no gaps in the ranking.
Row Number assigns a unique number to each row, without any regard for the values in the...
List comprehension is a concise way to create lists in Python by applying an expression to each item in an iterable.
Syntax: [expression for item in iterable]
Can include conditions: [expression for item in iterable if condition]
Example: squares = [x**2 for x in range(10)]
Interactive clusters allow for real-time interaction and exploration, while job clusters are used for running batch jobs.
Interactive clusters are used for real-time data exploration and analysis.
Job clusters are used for running batch jobs and processing large amounts of data.
Interactive clusters are typically smaller in size and have shorter lifespans.
Job clusters are usually larger and more powerful to handle heavy w...
To add a column in a dataframe, use the 'withColumn' method. To rename a column, use the 'withColumnRenamed' method.
To add a column, use the 'withColumn' method with the new column name and the expression to compute the values for that column.
Example: df.withColumn('new_column', df['existing_column'] * 2)
To rename a column, use the 'withColumnRenamed' method with the current column name and the new column name.
Example:...
Coalesce is used to combine multiple small partitions into a larger one, while Repartition is used to increase or decrease the number of partitions in a DataFrame.
Coalesce reduces the number of partitions in a DataFrame by combining small partitions into larger ones.
Repartition increases or decreases the number of partitions in a DataFrame by shuffling the data across partitions.
Coalesce is more efficient than Repartit...
What people are saying about Accenture
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
Union combines and removes duplicates, while union all combines all rows including duplicates.
Union removes duplicates from the result set
Union all includes all rows, even duplicates
Use union when you want to remove duplicates, use union all when duplicates are needed
Rank assigns unique ranks to each distinct value, while dense rank assigns consecutive ranks to each distinct value.
Rank does not skip ranks when there are ties, while dense rank does
Rank may have gaps in the ranking sequence, while dense rank does not
Rank is useful when you want to know the exact position of a value in a sorted list, while dense rank is useful when you want to know the relative position of a value com
Facts tables contain numerical data while dimensions tables contain descriptive attributes.
Facts tables store quantitative data like sales revenue or quantity sold
Dimensions tables store descriptive attributes like product name or customer details
Facts tables are typically used for analysis and reporting, while dimensions tables provide context for the facts
Lambda functions in Python are anonymous functions that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used for small, one-time tasks.
Lambda functions can be used as arguments to higher-order functions like map, filter, and reduce.
Accenture interview questions for designations
Get interview-ready with Top Accenture Interview Questions
I applied via Approached by Company and was interviewed in Oct 2024. There were 2 interview rounds.
It was 60 mins test where there were 11 MCQ 3 SQL and 1 python questions
Use Databricks code to read multiple files from ADLS and write into a single file
Use Databricks File System (DBFS) to access files in ADLS
Read multiple files using Spark's read method
Combine the dataframes using union or merge
Write the combined dataframe to a single file using Spark's write method
Spark architecture is a distributed computing framework that provides high-level APIs for various languages.
Spark architecture consists of a cluster manager, worker nodes, and a driver program.
It uses Resilient Distributed Datasets (RDDs) for fault-tolerant distributed data processing.
Spark applications run as independent sets of processes on a cluster, coordinated by the SparkContext object.
It supports various data so...
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Use set() function to remove duplicates from a list in Python.
Convert the list to a set using set() function
Convert the set back to a list to remove duplicates
Example: list_with_duplicates = ['a', 'b', 'a', 'c']; list_without_duplicates = list(set(list_with_duplicates))
I applied via Job Portal and was interviewed in Sep 2024. There was 1 interview round.
I applied via Company Website and was interviewed in Sep 2024. There were 2 interview rounds.
30 questions were there, Mostly SQL question
Databricks is a unified analytics platform that combines data engineering, data science, and business analytics.
Databricks provides a collaborative workspace for data engineers, data scientists, and business analysts to work together on big data projects.
It integrates with popular tools like Apache Spark for data processing and machine learning.
Databricks offers automated cluster management and scaling to handle large ...
There are two types of clusters in Databricks: Standard and High Concurrency.
Standard clusters are used for single user workloads and are terminated when not in use.
High Concurrency clusters are used for multiple users and remain active even when not in use.
Both types of clusters can be configured with different sizes and auto-scaling options.
Some of the top questions asked at the Accenture Data Engineer interview -
The duration of Accenture Data Engineer interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 85 interviews
3 Interview rounds
based on 205 reviews
Rating in categories
Application Development Analyst
38.9k
salaries
| ₹3 L/yr - ₹12 L/yr |
Application Development - Senior Analyst
27k
salaries
| ₹6.9 L/yr - ₹17.5 L/yr |
Team Lead
24.3k
salaries
| ₹7.1 L/yr - ₹25.6 L/yr |
Senior Software Engineer
18.2k
salaries
| ₹6 L/yr - ₹19.5 L/yr |
Software Engineer
17.4k
salaries
| ₹3.6 L/yr - ₹13.4 L/yr |
TCS
Cognizant
Capgemini
Infosys