Company Name: EY
Position: Senior Consultant
Location: Not specified
Application Process: I applied via a referral and was interviewed in October 2021.
Interview Rounds:
Preparation Tips:
- Brush up on SQL, PL/SQL, ODI, and ETL concepts.
- Practice scenario-based questions for data modeling and warehousing.
- Be ready to discuss your experience with large file operations and database optimization.
- Prepare for salary negotiations by researching industry standards.
Conclusion:
The interview process was challenging but very engaging. The technical rounds tested my practical knowledge, and the HR round was smooth. I’d advise future candidates to focus on real-world applications of their skills and be confident during negotiations.
Company Name: EY
Position: Senior Consultant
Application Process: I applied via LinkedIn and was interviewed before September 2022.
Interview Rounds:
-
Round 1 - Resume Shortlist Round:
- Questions Asked: Basic questions to verify the details mentioned in the resume.
- Your Approach: Ensured all details in my resume were accurate and prepared to discuss any point in detail.
- Outcome: Passed this round successfully.
-
Round 2 - Technical Round:
- Questions Asked: Questions related to the PP cycle.
- Your Approach: Focused on explaining the PP cycle clearly and concisely, highlighting my experience and understanding of the topic.
- Outcome: Cleared the technical round.
-
Round 3 - One-on-one Round:
- Questions Asked: Common questions like how soon I could join and discussions about the CTC.
- Your Approach: Answered honestly about my availability and negotiated the CTC professionally.
- Outcome: Successfully cleared this round.
Preparation Tips:
- Be confident during the interview.
- Ensure your resume is truthful and you can back up every detail mentioned.
Conclusion:
Overall, the interview process was smooth, and I felt well-prepared. Being honest and confident in my responses helped me clear all the rounds. For future candidates, I’d recommend thoroughly reviewing your resume and being prepared to discuss any technical topics relevant to the role.
Company Name: EY
Position: Senior Consultant
Location: [Location not specified]
Application Process: [Application process details not provided]
Interview Rounds:
- Round 1 - One-on-One Round:
- Questions Asked:
- The interviewer emphasized not worrying too much about specific questions but focusing on basics and confidence.
- Your Approach:
- I prepared the basics thoroughly and ensured I was confident during the interview. I also tried to establish a good connection with the interviewer.
- Outcome:
- The interview went quite well.
Preparation Tips:
- Have confidence and always ask questions from your interviewer after the interview concludes.
Conclusion:
- The interview was a positive experience. Confidence and a good rapport with the interviewer played a key role. For future candidates, I’d advise focusing on the basics and maintaining a confident demeanor.
Company Name: EY
Position: Senior Consultant
Application Process: I applied via a referral and was interviewed before March 2022.
Interview Rounds:
-
Round 1 - Resume Shortlist:
-
Pro Tip: Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, so make sure to leave the best impression.
-
Outcome: My resume was shortlisted for the next round.
-
Round 2 - Technical Round:
-
Questions Asked:
- “Tell me about yourself.”
- Questions from my CV, such as:
- What is the 5-step model of Ind AS 115?
- Which is the first note in notes to accounts?
- What are auditing assertions?
- What is the audit procedure for debtors?
- Define materiality.
- Difference between AS and Ind AS.
-
Your Approach: I answered confidently, focusing on my experience and knowledge of auditing standards and procedures. I also ensured I was clear and concise in my responses.
-
Outcome: The round went well, and I was able to demonstrate my technical expertise.
Preparation Tips:
- Prepare thoroughly for questions from your resume.
- Focus on auditing assertions, auditing procedures, and major observations during audits.
- Brush up on key differences between AS and Ind AS.
Conclusion:
Overall, the interview process was smooth, and I felt well-prepared. I would advise future candidates to thoroughly review their resumes and be ready to answer technical questions related to auditing standards and procedures. Confidence and clarity in responses are key!
Company Name: EY
Position: Senior Consultant
Location: [Not specified]
Application Process: Applied via a job portal before April 2022.
Interview Rounds:
-
Round 1 - Resume Shortlist:
-
Questions Asked: N/A (Resume screening round)
-
Your Approach: Ensured my resume was concise and highlighted relevant skills and experiences.
-
Outcome: Successfully shortlisted for the next round.
-
Round 2 - One-on-one Round (Technical):
-
Questions Asked: Coding questions, AWS and Cloud-related questions, and Java questions.
-
Your Approach: Focused on explaining my thought process clearly and demonstrated hands-on experience with AWS and Java.
-
Outcome: Advanced to the next round.
-
Round 3 - One-on-one Round (Technical):
-
Questions Asked: Functional programming, database concepts, design patterns, and SQL queries.
-
Your Approach: Prepared by revising core concepts and practiced writing efficient SQL queries.
-
Outcome: Cleared the round successfully.
Preparation Tips:
- Strengthen your technical skills, especially for tech consulting roles. Focus on coding, cloud technologies, and database concepts.
Conclusion:
The interview process was thorough and primarily technical. Preparing well for coding and cloud-related topics helped me perform better. For future candidates, I’d recommend revising core technical concepts and practicing problem-solving.
Company Name: EY
Position: Senior Consultant
Location: [Location not specified]
Application Process: [Application process details not provided]
Interview Rounds:
- Round 1 - Technical/Behavioral Interview:
- Questions Asked:
- Why do we perform KYC and due diligence on customers?
- What is conflict management? Provide examples.
- Explain your job end-to-end.
- Your Approach:
- For KYC and due diligence, I focused on the importance of regulatory compliance and risk mitigation.
- For conflict management, I shared real-life examples of resolving workplace conflicts.
- For the end-to-end job explanation, I walked through my responsibilities and deliverables clearly.
- Outcome: [Outcome not specified]
Preparation Tips:
- Have in-depth knowledge of your current role and past experiences.
- Avoid fabricating stories; interviewers can often spot inconsistencies.
Conclusion:
The interview was insightful, and I realized the importance of being thorough and honest in my responses. For future candidates, I recommend focusing on clarity and authenticity in your answers.
Company Name: EY
Position: Senior Consultant
Location: [Location not specified]
Application Process: [Details not provided]
Interview Rounds:
- Round 1 - Technical Round:
- Questions Asked:
- Query Optimization Technique
- Partition Table
- Your Approach: [Details not provided]
- Outcome: [Result not specified]
Preparation Tips:
- Focus on technical skills related to query optimization and partitioning in databases.
- Review indirect taxation, internal audit, and other relevant domains mentioned in the insights.
Conclusion:
- The interview was technical, focusing on database optimization and partitioning. Preparing thoroughly for these topics would be beneficial for future candidates.
Company Name: EY
Position: Senior Consultant
Location: Not specified
Application Process: Applied via a recruitment consultant before March 2022.
Interview Rounds:
-
Round 1 - Resume Shortlist Round:
- Questions Asked: None (resume screening).
- Your Approach: Ensured my resume was error-free and highlighted relevant experience.
- Outcome: Passed to the next round.
-
Round 2 - HR Round:
- Questions Asked: Basic questions about myself and previous experience.
- Your Approach: Answered honestly and confidently, focusing on my skills and achievements.
- Outcome: Advanced to the next round.
-
Round 3 - Technical Round:
- Questions Asked: Manager round focused on accounting standards.
- Your Approach: Prepared thoroughly by revising key accounting standards and applying them to practical scenarios.
- Outcome: Successfully cleared the round.
-
Round 4 - One-on-one Round:
- Questions Asked: Partner round—questions about myself.
- Your Approach: Kept my answers concise and professional, aligning my experience with the role.
- Outcome: Cleared the final round.
Preparation Tips:
- Be calm and confident during the interview.
- Brush up on accounting standards, including IFRS and IndAS.
Conclusion:
Overall, the interview process was smooth and well-structured. Being well-prepared and confident helped me navigate each round successfully. For future candidates, I’d recommend focusing on both technical knowledge and soft skills to make a strong impression.
Company Name: EY
Position: Senior Consultant
Location: Not specified
Application Process: Applied via LinkedIn in September 2021.
Interview Rounds:
-
Round 1 - One-on-one Round:
-
Questions Asked: Technical and related to the job.
-
Your Approach: Focused on aligning my technical skills with the job requirements.
-
Outcome: Advanced to the next round.
-
Round 2 - One-on-one Round:
-
Questions Asked: Technical and related to the job.
-
Your Approach: Emphasized real-world applications of my skills and experience.
-
Outcome: Successfully cleared the round.
Preparation Tips:
- Just focus on your job and try to get through the interview by aligning your skills with the role.
Conclusion:
The interview process was straightforward, with a strong emphasis on technical skills relevant to the job. Staying focused and confident helped me navigate the rounds successfully.
Company Name: EY
Position: Senior Consultant
Application Process: I applied via a referral and was interviewed in April 2024.
Interview Rounds:
-
Round 1 - Coding Test:
- Questions Asked: Questions on Python and SQL.
- Your Approach: I focused on solving the problems efficiently, ensuring my code was clean and optimized.
- Outcome: Passed this round.
-
Round 2 - Coding Test:
- Questions Asked: Detailed questions on PySpark and SQL.
- Your Approach: I reviewed PySpark concepts beforehand and practiced writing queries to handle complex scenarios.
- Outcome: Passed this round.
-
Round 3 - HR Round:
- Questions Asked: Basic discussion on salary expectations.
- Your Approach: I was honest about my expectations and aligned them with industry standards.
- Outcome: Cleared the HR round successfully.
Preparation Tips:
- Focus on basic Python and SQL as the problems are not overly tough.
- Brush up on PySpark if the role involves data processing.
Conclusion:
The interview process was smooth, and the questions were fair. I would advise future candidates to prepare thoroughly for coding tests and be clear about their salary expectations during the HR round.
Company Name: EY
Position: Senior Consultant
Location: Not specified
Application Process: Applied via Naukri.com and was interviewed before April 2022.
Interview Rounds:
-
Round 1 - Resume Shortlist Round:
- Questions Asked: Proper alignment and formatting of the resume were emphasized.
- Your Approach: Ensured the resume was well-structured and highlighted relevant skills and experiences.
- Outcome: Successfully shortlisted for the next round.
-
Round 2 - Case Study Round:
- Questions Asked: Questions about skills related to the BFSI domain, Agile, Waterfall methodologies, projects worked on, changes implemented, and project execution complexities.
- Your Approach: Focused on detailing past projects, methodologies used, and the impact of changes made.
- Outcome: Advanced to the next round.
-
Round 3 - Technical Round:
- Questions Asked: Questions about technical areas mentioned in the resume, such as PL/SQL.
- Your Approach: Prepared thoroughly on the technical skills listed in the resume and explained them clearly.
- Outcome: Progressed to the final round.
-
Round 4 - HR Round:
- Questions Asked: Salary negotiation and joining dates.
- Your Approach: Discussed salary expectations and availability honestly.
- Outcome: Awaiting final decision.
Preparation Tips:
- EY is a service-based organization, so focus on showcasing your domain expertise, especially in BFSI, Agile, and Waterfall methodologies.
- Be prepared to discuss your projects in detail, including challenges and solutions.
- Brush up on technical skills mentioned in your resume, such as PL/SQL.
Conclusion:
The interview process was thorough, covering both technical and behavioral aspects. Proper resume formatting and clear communication about past experiences were key. For future candidates, ensure your resume is well-structured and be ready to discuss your projects and technical skills in detail.
Company Name: EY
Position: Senior Consultant
Location: [Location not specified]
Application Process: [Application process details not provided]
Interview Rounds:
- Round 1 - Technical Round:
- Questions Asked:
- Introduction was asked.
- Explain your automation framework.
- Your Approach:
- For the introduction, I kept it concise, highlighting my relevant experience and skills.
- For the automation framework question, I explained the structure, tools used, and how it improved efficiency in my previous projects.
- Outcome: [Result of this round not provided]
Preparation Tips:
- Brush up on your automation framework knowledge, including tools and methodologies.
- Be ready to discuss your past projects in detail, especially those involving automation.
Conclusion:
The interview was straightforward, focusing on technical expertise. I felt confident in my responses, but I could have prepared more examples to showcase my experience. Future candidates should ensure they can articulate their technical contributions clearly.
Company Name: EY
Position: Senior Consultant
Application Process: Approached by the company and interviewed in April 2023.
Interview Rounds:
-
Round 1 - Resume Shortlist:
- Questions Asked: N/A (Resume screening)
- Your Approach: Ensured my resume was crisp and highlighted key projects and skills relevant to the role.
- Outcome: Successfully shortlisted for the next round.
-
Round 2 - One-on-one Interview:
- Questions Asked:
- Walkthrough of any one project.
- Managerial questions.
- Your Approach: Focused on clearly explaining the project, my role, challenges faced, and outcomes. For managerial questions, I emphasized leadership experiences and problem-solving skills.
- Outcome: Advanced to the next round.
-
Round 3 - One-on-one Interview:
- Questions Asked:
- Walkthrough of any one project.
- Managerial questions.
- Your Approach: Chose a different project to showcase versatility and reiterated my managerial capabilities with examples.
- Outcome: Successful selection for the role.
Preparation Tips:
- Confidence and a strong grasp of the assignments mentioned on your resume are crucial.
- Real-world work knowledge and the ability to articulate it clearly are highly valued.
Conclusion:
The interview process was smooth and focused on both technical and managerial aspects. Being well-prepared with project details and leadership examples helped me perform well. For future candidates, I’d recommend practicing clear communication and ensuring you can discuss any project on your resume in depth.
Company Name: EY
Position: Senior Consultant
Application Process: Applied via LinkedIn and was interviewed before January 2022.
Interview Rounds:
-
Round 1 - Resume Shortlist:
- Pro Tip: Avoid using unprofessional email addresses (e.g., cool_boy@email.com) as it reflects poorly on your professionalism.
- Outcome: Passed this round.
-
Round 2 - Aptitude Test:
- Questions Asked: General aptitude and Java basics.
- Your Approach: Prepared by revising basic aptitude concepts and Java fundamentals.
- Outcome: Found the test easy and cleared it.
-
Round 3 - One-on-One Round (Technical):
- Questions Asked: Basic Java, data structures, Spring Boot, and databases.
- Your Approach: Focused on explaining concepts clearly and providing practical examples.
- Outcome: Successfully answered the questions and moved to the next round.
-
Round 4 - One-on-One Round (Coding):
- Questions Asked: Coding round focused on Java.
- Your Approach: Solved the problem methodically, ensuring clean and efficient code.
- Outcome: Cleared the round with a good performance.
Preparation Tips:
- Be honest and well-prepared about the interview topics and technologies.
- Revise core Java, data structures, and frameworks like Spring Boot.
- Practice coding problems to improve problem-solving speed and accuracy.
Conclusion:
The interview process was smooth, and the questions were aligned with the role’s requirements. Being thorough with the basics and staying calm during the rounds helped me perform well. For future candidates, focus on clarity in explanations and practice coding regularly.
Company Name: EY
Position: Senior Consultant
Location: [Not specified]
Application Process: Applied via Naukri.com and was interviewed in March 2023.
Interview Rounds:
-
Round 1 - Resume Shortlist:
-
Questions Asked: No specific questions were asked in this round.
-
Your Approach: Ensured my resume was error-free and highlighted relevant skills and experience.
-
Outcome: Successfully shortlisted for the next round.
-
Round 2 - One-on-one Round:
-
Questions Asked:
- Basic Java questions.
- Questions on Hashmap, collections, and Stream API.
-
Your Approach: Prepared thoroughly by revising core Java concepts and practicing coding problems related to collections and Stream API.
-
Outcome: [Outcome not specified]
Preparation Tips:
- Focus on core Java topics, especially collections, Hashmap, and Stream API.
- Ensure your resume is accurate and free of errors.
- Never lie during the interview process.
Conclusion:
The interview process was straightforward, with a focus on technical skills in Java. Preparing well for core concepts and being honest during the interview are key takeaways for future candidates.
Company Name: EY
Position: Senior Consultant
Location: Not specified
Application Process: Applied via Naukri.com and was interviewed in April 2023.
Interview Rounds:
-
Round 1 - Resume Shortlist:
-
Questions Asked: No specific questions; resume was reviewed for suitability.
-
Your Approach: Ensured my resume was concise and highlighted relevant skills and experience.
-
Outcome: Passed to the next round.
-
Round 2 - Technical Round:
-
Questions Asked: “If user A is doing some insert/updates in a database, can User B see the effect of these changes?”
-
Your Approach: Explained the concept of database transactions, isolation levels, and how visibility of changes depends on the isolation level set.
-
Outcome: Successfully answered and moved to the next round.
-
Round 3 - Client Interview Round:
-
Questions Asked: “What happens if the base table of a Materialized View is dropped? Will it drop the Materialized View also?”
-
Your Approach: Clarified that dropping the base table would invalidate the Materialized View, but it wouldn’t be automatically dropped unless explicitly specified.
-
Outcome: Answered correctly and proceeded to the final round.
-
Round 4 - HR Round:
-
Questions Asked: “Salary expectations?”
-
Your Approach: Provided a range based on industry standards and my experience level.
-
Outcome: Awaiting final decision.
Preparation Tips:
- Focus on database concepts, especially transactions and Materialized Views.
- Be clear about your salary expectations and justify them with market research.
Conclusion:
The interview process was smooth and well-structured. I felt prepared for the technical rounds but could have researched more about EY’s specific projects to align my answers better. For future candidates, I recommend brushing up on database fundamentals and being confident in discussing your expectations during the HR round.
Company Name: EY
Position: Senior Consultant
Location: Not specified
Application Process: The application process involved a resume shortlist followed by a technical round.
Interview Rounds:
Preparation Tips:
- Be confident in your responses.
- If you know the answer, articulate it clearly; if not, it’s better to admit it rather than bluff.
- Stay truthful throughout the interview process.
Conclusion:
The interview experience was smooth, and the questions were aligned with the role’s requirements. Being honest and confident helped in navigating the technical round effectively. For future candidates, focusing on core technical skills and maintaining clarity in communication is key.
Company Name: EY
Position: Senior Consultant
Location: [Not specified]
Application Process: I applied via a referral.
Interview Rounds:
-
Round 1 - Resume Shortlist Round:
-
Questions Asked: N/A (Resume screening)
-
Your Approach: Ensured my resume was well-formatted and clearly highlighted my skills and experiences.
-
Outcome: Shortlisted for the next round.
-
Round 2 - Technical Round:
-
Questions Asked:
- Basics of the project I was working on and my roles and responsibilities.
- Some technical questions regarding data services.
-
Your Approach: Focused on explaining my project clearly and answered technical questions based on my hands-on experience.
-
Outcome: Advanced to the next round.
-
Round 3 - One-on-one Round:
-
Questions Asked:
- Deep dive into the tools and technologies used.
- Managerial discussion and roles and responsibilities in the project.
-
Your Approach: Provided detailed explanations about the tools I used and discussed my managerial experience and contributions to the project.
-
Outcome: Progressed to the HR round.
-
Round 4 - HR Round:
-
Questions Asked:
- Tell me about yourself.
- Salary negotiation and expectations.
-
Your Approach: Kept my introduction concise and professional, and discussed salary expectations transparently.
-
Outcome: Successfully cleared the HR round.
Preparation Tips:
- Keep it simple and be confident while answering. The questions are designed to check your basic understanding. Avoid faking answers to impress the interviewer.
Conclusion:
Overall, the interview process was smooth and well-structured. Being honest and confident in my responses helped me perform well. My advice to future candidates is to thoroughly prepare for technical and managerial discussions and to be clear about your salary expectations during the HR round.
Company Name: EY
Position: Senior Consultant
Location: [Not specified]
Application Process: Applied via Naukri.com and was interviewed before August 2023.
Interview Rounds:
- Round 1 - Technical Round:
- Questions Asked:
- Based on our experience.
- Some questions regarding technology.
- Your Approach:
- For the first question, I discussed my relevant work experience and how it aligns with the role.
- For the second question, I answered based on my knowledge of the specific technologies mentioned.
- Outcome: [Not specified]
Preparation Tips:
- Focus on understanding the key skills required for the role, such as Direct Tax, Taxation, Compliance, and Project Management.
- Brush up on technology-related topics relevant to the position.
Conclusion:
The interview was a good opportunity to showcase my experience and skills. I would recommend future candidates to thoroughly prepare for both technical and experience-based questions.
Company Name: EY
Position: Senior Consultant
Location: Not specified
Application Process: I applied via Naukri.com and was interviewed before September 2023.
Interview Rounds:
Preparation Tips:
- EY is a consulting firm, and in the IT service line, there are no in-house projects. You will be deployed at the client site, so focus on making the client happy to avoid being benched.
- No layoffs, but performance is key.
- Brush up on technical skills like SAS, SOX, Service Tax, Central Excise, Cenvat, Finance, ISO 27001, and MA.
Conclusion:
The interview process was thorough, with a strong emphasis on technical knowledge. While the client round was challenging, being well-prepared helped me succeed. For future candidates, focus on both technical depth and consulting skills to excel in the process.