Filter interviews by
Basic research questions. Can check online and provide the answers
Public companies are traded on stock exchanges and have more regulatory requirements, while private companies are not traded publicly and have more flexibility.
Public companies have more regulatory requirements due to SEC regulations
Private companies have more flexibility in decision-making and operations
Public companies have more transparency as they are required to disclose financial information to the public
Private ...
Look for C-level details in company annual reports, press releases, investor presentations, and industry publications.
Company annual reports
Press releases
Investor presentations
Industry publications
I was interviewed before Sep 2019.
Market research and media analytics assignment
I applied via Approached by Company and was interviewed in Jun 2022. There were 5 interview rounds.
The question asks about calculating cumulative sum of an array and frequency of each word in a sentence.
To calculate cumulative sum of an array, we can use a loop and keep adding the current element to a running sum variable.
To calculate frequency of each word in a sentence, we can split the sentence into words and use a dictionary to keep track of the count of each word.
We can use built-in functions in programming lan...
I was interviewed in May 2021.
Round duration - 60 minutes
Round difficulty - Medium
Started with project description, deep dive into project
Questions about ML, Statistics
Coding questions for Python, SQL
You are provided with a list, DICTIONARY[]
, which contains a collection of words, along with a stream of characters (queries). The task is to implement a class Chara...
Implement a class to check if a string formed by the last queried characters exists in a dictionary of words.
Initialize the class with the dictionary of words.
Implement a method to check if the string formed by the last queried characters exists in the dictionary.
Use appropriate data structures to efficiently solve the problem.
Ensure the class handles multiple test cases and character queries.
Example: DICTIONARY[] = ['...
Use a subquery to retrieve the second highest salary from a SQL database.
Use a subquery to select the maximum salary from the table.
Then use another subquery to select the maximum salary that is less than the maximum salary found in the first step.
Combine both subqueries to retrieve the second highest salary.
Round duration - 60 minutes
Round difficulty - Easy
Projects
Machine Learning
Questions about Statistics
Answering aptitude questions related to statistics
Statistics is the study of collecting, analyzing, interpreting, presenting, and organizing data.
Key concepts include mean, median, mode, standard deviation, and probability.
Examples of statistical questions include 'What is the average income of a population?' and 'What is the likelihood of an event occurring?'
Round duration - 60 minutes
Round difficulty - Easy
Behavioral Round
Questions asked about Amazon Leadership Principles
Round duration - 60 minutes
Round difficulty - Easy
Medium Python questions
Medium SQL questions
Calculate the fraction when one integer is divided by another, with repeating decimal parts enclosed in parentheses.
Divide the first integer by the second integer to get the fraction
Identify if the fractional part is repeating and enclose it in parentheses
Return the fraction for each test case
Use SQL query with window functions to find top 2 salaries for each department.
Use PARTITION BY clause to partition the data by department.
Use ORDER BY clause to order the salaries in descending order.
Use ROW_NUMBER() function to assign a rank to each row within the partition.
Filter the results to only include rows with rank 1 and 2.
Tip 1 : Practice String and array based questions for python coding test
Tip 2 : Practice Window Functions, Rank functions for SQL
Tip 3 : Describe the one project that you're confident with and have worked deeply
Tip 1 : Start with projects and then move to skills
Tip 2 : Explain each project in around 3 bullet points
Tip 3 : Include numbers in projects (ex increased x% revenue by applying ... )
I applied via Company Website and was interviewed in Sep 2023. There was 1 interview round.
Medium to Hard 4 DSA questions
I applied via Recruitment Consultant and was interviewed in Aug 2017. There were 4 interview rounds.
I applied via Campus Placement
I am a business analyst with experience in data analysis, process improvement, and project management.
Experienced in data analysis and visualization using tools like Excel, Tableau, and Power BI
Skilled in process improvement and optimization through Lean Six Sigma methodologies
Proficient in project management and agile methodologies
Strong communication and interpersonal skills, able to collaborate with cross-functional...
I grew up in a small town in the countryside, while Surat is a bustling city known for its textile industry.
My hometown is peaceful and quiet, while Surat is always buzzing with activity.
My hometown has a strong sense of community, while Surat is more diverse and cosmopolitan.
My hometown is surrounded by natural beauty, while Surat has a rich cultural heritage and historical landmarks.
Advice for 15 year old and 40 year old Shubham
For 15 year old Shubham: Focus on education and skill development
For 40 year old Shubham: Embrace change and continue learning
Both should prioritize their mental and physical health
15 year old Shubham should explore different interests and hobbies
40 year old Shubham should network and build professional relationships
I believe that working in a non-core company will provide me with a diverse range of experiences and challenges, allowing me to develop a broader skill set.
Non-core companies often have a more dynamic work environment
Opportunities to work on a variety of projects
Chance to learn new skills and gain experience in different areas
Potential for faster career growth
Examples: IT companies, consulting firms, startups
In 3 years, I see myself as a senior business analyst leading a team and contributing to the growth of the company.
Leading a team of business analysts
Contributing to the growth of the company through data-driven insights
Continuing to learn and develop new skills
Building strong relationships with stakeholders
Exploring opportunities for process improvement
Yes, I have some doubts about the company.
I am not sure about the company's long-term growth strategy.
I have concerns about the company's financial stability.
I am unsure about the company's approach to employee development and retention.
I want to join Accenture because of its reputation as a leading consulting firm and its focus on innovation and technology.
Accenture's reputation as a leading consulting firm is unmatched in the industry.
I am impressed by Accenture's focus on innovation and technology, which aligns with my own interests and skills.
I believe that Accenture's collaborative and diverse culture will provide me with opportunities to learn a...
I developed a software tool to automate the testing process of a complex system.
Identified the need for automation due to the complexity of the system
Researched and learned new programming languages and tools
Designed and developed the software tool using Python and Selenium
Collaborated with the testing team to ensure the tool met their needs
Reduced testing time by 50% and improved accuracy of test results
Yes, I know programming languages.
I am proficient in Java and Python.
I have experience in using SQL for database management.
I have also worked with HTML, CSS, and JavaScript for web development.
I am familiar with Agile methodology and have used JIRA for project management.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Software Engineer
18
salaries
| ₹0 L/yr - ₹0 L/yr |
Research Analyst
15
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
12
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Developer
11
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Adobe
Salesforce
Oracle
SAP