Accenture Interview Questions, Process, and Tips

Q1. Delete, drop, truncate difference, fact, dimension, SCD
Add your answer
Q2. Union & union all difference, rank, dense rank, row_number
Add your answer
Q3. Char index, surrogate key, joins, minus query, test closure, test plan, test summary
Add your answer
Q4. SQL queries for - 2nd highest salary & duplicate record
Add your answer

Easy round, most people qualify this round.

2 questions in 30 min, 1st was super easy and 2nd was easy to medium level.

Q1. Introduce yourself
Ans. 
I am a dedicated and detail-oriented engineering analyst with a strong background in data analysis and problem-solving.
• Bachelor's degree in Engineering

• Proficient in data analysis tools such as Excel and MATLAB

• Experience in conducting engineering research projects

• Strong analytical and problem-solving skills

• Excellent communication and teamwork abilities
Answered by AI
Add your answer
Q2. Explain about your project which you are most proud of.
Ans. 
Designed and implemented a smart irrigation system using IoT technology.
• Researched various IoT sensors and microcontrollers for data collection and control

• Developed a mobile app for users to monitor and control the irrigation system remotely

• Implemented machine learning algorithms to optimize water usage based on weather forecasts

• Reduced water consumption by 30% while maintaining or improving crop yield
Answered by AI
Add your answer
Q3. Where you the leader of the project team?
Ans. 
Yes, I was the leader of the project team.
• Led the project team in planning, organizing, and executing tasks

• Delegated responsibilities and ensured team members were on track

• Facilitated communication and collaboration among team members

• Made decisions and resolved conflicts to keep the project on schedule

• Provided guidance and support to team members
Answered by AI
Add your answer
Q4. What challenge you faced and how you overcame those?
Ans. 
I faced a challenge with a complex data analysis project and overcame it by breaking it down into smaller tasks and seeking help from colleagues.
• Broke down the project into smaller, manageable tasks

• Sought help and guidance from colleagues with expertise in data analysis

• Utilized online resources and tutorials to learn new techniques

• Maintained a positive attitude and persevered through setbacks
Answered by AI
Add your answer
Q5. What was your learning from those challenges?
Ans. 
I learned the importance of perseverance, problem-solving, and teamwork in overcoming challenges.
• Perseverance is key to staying motivated and pushing through difficult situations

• Problem-solving skills are essential for finding creative solutions to obstacles

• Teamwork is crucial for leveraging diverse perspectives and skills to tackle challenges together
Answered by AI
Add your answer
Q6. Which course was the worst course for you in your entire engineering journey?
Ans. 
The worst course in my engineering journey was Advanced Thermodynamics.
• The course material was very complex and difficult to understand

• The professor had a teaching style that didn't align with my learning style

• The assignments and exams were extremely challenging

• I struggled to grasp the concepts and apply them in practical scenarios
Answered by AI
Add your answer
Q7. Any questions you want to ask?
Ans. 
Yes, I would like to know more about the team I will be working with and the projects I will be involved in.
• What is the team structure like?

• Can you provide more details about the current projects the team is working on?

• Are there any upcoming projects that I will be involved in?

• What is the typical workflow for projects in this role?
Answered by AI
Add your answer

Q1. Difference between Inner, outer joins
Ans. 
Inner join returns only the matching rows between two tables, while outer join returns all rows from one table and matching rows from the other.
• Inner join: returns rows that have matching values in both tables

• Outer join: returns all rows from one table and matching rows from the other

• Example: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

• Example: Outer join - SELECT * FROM table1 LEFT OUTE
Answered by AI
Add your answer
Q2. Difference between full join and union
Ans. 
Full join combines rows from both tables, including unmatched rows. Union combines rows from both tables, excluding duplicates.
• Full join includes all rows from both tables, filling in NULL values for unmatched rows.

• Union combines rows from both tables, excluding duplicates.

• Example: SELECT * FROM table1 FULL JOIN table2 ON table1.id = table2.id;

• Example: SELECT * FROM table1 UNION SELECT * FROM table2;
Answered by AI
Add your answer
Q3. About Copy activity
Add your answer
Q4. About select transformation
Add your answer
Q5. About join transformation and scd type 1
Add your answer

Q1. Profiles and PS in salesforce
Add your answer
Q2. Flows, object relationships, Service cloud
Add your answer

Q1. Works done in previous org
Add your answer
Q2. Agile methodology
Add your answer

Q1. Able to relocate?
Add your answer
Q2. Expected and current salary.
Add your answer

Basic aptitude questions will be posed.

There are two straightforward coding problems they will likely ask you to solve. ROUND 3, which is a communication assessment, occurs after you successfully complete the aptitude and coding rounds. During this round, you will be invited for a communication interview, where they will ask you questions, request that you repeat what they say, and ask you to formulate responses. Based on all these results, you will be invited for the final HR interview.

Q1. What should candidates focus on in their responses to convey confidence and fluency during the interview? Additionally, what types of technical questions might the HR ask, and how should candidates prepare...read more
Add your answer

I would say it was good, but one thing to note is that they might ask questions related to Data Structures and Algorithms (DSA) or not totally based on the interviewer, unlike the Infosys interview where questions can be predicted. Additionally, the questions are not particularly difficult; if you have the necessary knowledge, you can easily succeed.