Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
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...
I was interviewed in Feb 2025.
I'm interested fresher HR manager
I'm interested fresher HR manager best performance
I'm interested fresher HR manager best conference
I was interviewed in Feb 2025.
What people are saying about Accenture
I was interviewed in Sep 2024.
Accenture interview questions for popular designations
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
The number of variances in SAP can vary depending on the specific processes and transactions being analyzed.
The number of variances in SAP can be influenced by factors such as data entry errors, system glitches, or discrepancies in invoice processing.
Variances in SAP may be identified through reconciliation processes, exception reports, or manual reviews of accounts payable transactions.
Examples of variances in SAP inc...
Accounts receivable and accounts payable are two important aspects of a company's financial operations.
Accounts receivable refers to money owed to a company by its customers for goods or services provided.
Accounts payable refers to money owed by a company to its suppliers or vendors for goods or services received.
Accounts receivable is an asset on the balance sheet, while accounts payable is a liability.
Managing accoun...
Cost element and cost center are key concepts in accounting for tracking and allocating costs within an organization.
Cost element refers to the specific types of costs incurred by an organization, such as materials, labor, or overhead.
Cost center is a specific department, team, or function within an organization that is responsible for incurring costs.
Cost elements are assigned to cost centers to track and allocate cos...
SAP supports over 160 currencies worldwide.
SAP supports over 160 currencies for global transactions.
Currencies can be configured in SAP using transaction code OB22.
Each currency is assigned a unique currency code (e.g. USD for US Dollar, EUR for Euro).
There are various types of projects, including internal projects, external projects, research projects, and development projects.
Internal projects focus on improving processes within the organization.
External projects involve working with external partners or clients.
Research projects aim to gather data and analyze findings.
Development projects focus on creating new products or services.
Examples: IT system implementati...
Get interview-ready with Top Accenture Interview Questions
Aptitude test consists 2 section first section is of of Logical reasoning , Verbal reasoning and Analytical Reasoning
and next section is of technical mcqs MS office , cloud , networking and security , Pseudo code related mcqs
After that there were
Data Structures and Algorithms was the most difficult subject for me in my curriculum.
I struggled with understanding complex data structures like graphs and trees.
I overcame this by seeking help from professors, classmates, and online resources.
I practiced solving problems regularly on platforms like LeetCode and HackerRank.
I also joined study groups to discuss and work on challenging problems together.
Developed a web application for managing student records using HTML, CSS, JavaScript, and PHP
Used HTML for structuring the web pages
Utilized CSS for styling the pages and making them visually appealing
Implemented client-side functionality using JavaScript
Backend logic and database management done with PHP
Included features like student registration, course enrollment, and grade tracking
I was interviewed in Dec 2024.
-Basic Accounting questions like simple journals , Accounting principles and concepts.
-Basic Excel tasks like questions (commonly used simple formulas ,chart preparation, pivot tables
etc,)
-Email writing.
-Simple Aptitude and Logical Reasoning questions.
Prepare well and try to attend maximum questions with better accuracy. Overall aptitude test is simple.
I am a detail-oriented professional with experience in R2R processes and a strong focus on accuracy and efficiency.
Experienced in reconciling accounts and preparing financial statements
Proficient in using accounting software such as SAP and Oracle
Strong analytical skills and ability to identify and resolve discrepancies
Excellent communication skills and ability to work effectively in a team
Bachelor's degree in Accounti
Accrual concept refers to recognizing revenues and expenses when they are incurred, regardless of when cash is exchanged.
Accrual concept is a fundamental accounting principle that states that revenues and expenses should be recognized when they are incurred, not when cash is exchanged.
This concept helps in providing a more accurate representation of a company's financial position and performance.
For example, if a compa...
Deferral accounting recognizes revenue or expenses when they are earned or incurred, while accrual accounting recognizes revenue or expenses when they are realized or incurred.
Deferral accounting involves postponing the recognition of revenue or expenses until a later period.
Accrual accounting involves recognizing revenue or expenses when they are incurred, regardless of when cash is exchanged.
Deferral accounting is co...
Accrual and deferral transactions involve recording revenues or expenses before or after they are actually earned or incurred.
Accrual transactions involve recording revenues or expenses before they are actually earned or incurred
Deferral transactions involve recording revenues or expenses after they are actually earned or incurred
Examples of accrual transactions include recognizing revenue for services provided but not...
Bank reconciliation is the process of comparing a company's records with those of the bank to ensure they match.
Gather bank statements and company records
Compare deposits, withdrawals, and fees on both sets of records
Identify and resolve any discrepancies
Adjust the company's records to match the bank's records
Prepare a bank reconciliation statement to document the process
Example: If the company recorded a deposit of $5...
Depreciation is the allocation of the cost of tangible assets over their useful life, while amortization is the allocation of the cost of intangible assets over their useful life.
Depreciation applies to tangible assets like buildings, machinery, and vehicles, while amortization applies to intangible assets like patents, copyrights, and trademarks.
Depreciation is usually calculated using methods like straight-line, doub...
Provisions are liabilities that are certain to occur, while contingencies are potential liabilities that may or may not occur.
Provisions are recognized when the amount is known with reasonable certainty, while contingencies are disclosed in the financial statements as a footnote.
Provisions are measured at the best estimate of the amount required to settle the obligation, while contingencies are disclosed if the outcome...
I am a detail-oriented Sourcing Analyst with a strong background in procurement and vendor management.
Over 5 years of experience in strategic sourcing and contract negotiation
Proficient in analyzing market trends and supplier performance
Skilled in cost reduction strategies and supplier relationship management
I have 5 years of experience as a Sourcing Analyst in the retail industry.
Managed vendor relationships and negotiated contracts
Analyzed market trends and pricing to make strategic sourcing decisions
Implemented cost-saving initiatives resulting in a 10% reduction in procurement costs
Collaborated with cross-functional teams to ensure supply chain efficiency
The P2P cycle refers to the process of procuring goods or services, receiving them, and paying for them.
The cycle starts with identifying the need for a product or service and creating a purchase requisition.
Next, the purchase requisition is approved and converted into a purchase order.
The supplier delivers the goods or services, which are then received and inspected by the buyer.
Once the goods/services are accepted, a...
I am a detail-oriented Sourcing Analyst with a strong background in procurement and supplier management.
Experienced in analyzing supplier performance and negotiating contracts
Skilled in identifying cost-saving opportunities and improving supply chain efficiency
Proficient in using sourcing tools and software such as SAP Ariba
Strong communication and interpersonal skills for building relationships with suppliers
I was interviewed in Jan 2025.
Debit note is a document issued by a buyer to a seller to request a credit for overpayment or return of goods. Credit note is a document issued by a seller to a buyer to reduce the amount owed due to overpayment or return of goods.
Debit note is issued by the buyer to request a credit from the seller.
Credit note is issued by the seller to reduce the amount owed by the buyer.
Debit note is used when there is an overpaymen...
Matching principle is an accounting concept that requires expenses to be matched with revenues in the period they are incurred.
Expenses should be recorded in the same period as the revenues they helped generate.
It ensures accurate financial reporting by showing the true cost of generating revenue.
Example: If a company sells products in January, the cost of goods sold for those products should also be recorded in Januar...
A subledger is a detailed record of transactions that feed into the general ledger.
Subledgers provide more detailed information on specific accounts or categories.
They help in tracking individual transactions before they are summarized in the general ledger.
Examples include accounts receivable subledger, accounts payable subledger, and inventory subledger.
Bank reconciliation statement is a document that compares the bank's records with the company's records of its bank account.
It is used to ensure the accuracy of the company's financial records.
It lists out any discrepancies between the two sets of records, such as outstanding checks or deposits in transit.
The goal is to reconcile the balance per the company's records with the balance per the bank's records.
It helps in ...
I was interviewed in Jan 2025.
Polymorphism is the ability of a single function or method to operate on different data types.
Allows objects of different classes to be treated as objects of a common superclass.
Can be achieved through method overloading or method overriding.
Example: Animal class with methods eat() and sleep(), and subclasses like Dog and Cat that override these methods.
The == operator checks for equality of values, while the equals() method checks for equality of objects.
The == operator compares the values of two objects, while the equals() method compares the objects themselves.
The == operator is used for primitive data types, while the equals() method is used for objects.
Example: int a = 5; int b = 5; a == b will return true, but a.equals(b) will not work as int is a primitive data
Dependency inversion is a design principle where high-level modules should not depend on low-level modules, but both should depend on abstractions.
High-level modules should not depend on low-level modules, both should depend on abstractions
Abstractions should not depend on details, details should depend on abstractions
Inversion of control containers like Spring Framework in Java implement dependency inversion
ACID is a set of properties that guarantee database transactions are processed reliably.
ACID stands for Atomicity, Consistency, Isolation, Durability
Atomicity ensures that all operations in a transaction are completed successfully or none at all
Consistency ensures that the database remains in a valid state before and after the transaction
Isolation ensures that multiple transactions can occur concurrently without affect...
Isolation levels in databases determine how transactions interact with each other.
Isolation levels define the degree to which one transaction must be isolated from the effects of other transactions.
Common isolation levels include READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.
Higher isolation levels provide more data consistency but may impact performance.
For example, in READ COMMITTED isolation le...
The duration of Accenture interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 6.8k interviews
Interview experience
based on 56.6k reviews
Rating in categories
Application Development Analyst
38.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Application Development - Senior Analyst
26.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
Team Lead
24.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
18.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
17.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Cognizant
Capgemini
Infosys