KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
REQUIREMENT_ID_1692 β€’ 3-DAY_ACTIVE_POLICY

Associate Consultant - Business Consulting Risk - AMI - CNS - Risk - Process & Controls - Ahmedabad

Company
Company EY (Ernst & Young)
Type
Opportunity Type Internship
Salary
Stipend / Salary 6-8 LPA
Location
Location Ahmedabad
Posted Date
Posted Date Yesterday
Internal audit Risk assessment Process mapping Data analysis Excel PowerPoint Communication Problem solving Teamwork Attention to detail
πŸ“–
Aptitude Practice Questions Open Resource β†—
Curated quantitative and logical reasoning problems to help you ace the online assessment for EY roles.
πŸ“–
Risk & Consulting Interview Guides Open Resource β†—
Targeted interview preparation material covering audit, risk consulting concepts and typical EY case scenarios.
πŸ“–
Comprehensive Preparation Portal Open Resource β†—
A one‑stop resource for interview experiences, resume tips and industry insights relevant to EY consulting positions.
πŸ“–
Algorithm & Data Structure Problem Set Open Resource β†—
Practice coding and data‑analysis problems to sharpen analytical skills often tested in technical rounds.

Bachelor of Commerce, Master of Commerce, B.Tech in Computer Science, B.Tech in Mechanical Engineering, M.Tech in Civil Engineering; Minimum 60% aggregate (or CGPA equivalent); No active backlogs; Fresh graduates or candidates with up to 2 years of relevant experience in Governance, Risk & Compliance, Internal Audit; Open to candidates from the 2024, 2025 or 2026 batch.

1
Round 1: Online aptitude test (numerical, logical reasoning, verbal)
2
Round 2: Technical/Case study interview focusing on audit methodology and risk concepts
3
Round 3: HR interview assessing cultural fit and career aspirations
Ernst & Young (EY) is one of the world’s leading professional services firms, offering assurance, tax, transaction and advisory services to a diverse client base. With a presence in more than 150 countries, EY helps organisations navigate complex business challenges, drive innovation and build sustainable growth. The firm’s culture is built around continuous learning, inclusivity and a commitment to delivering high‑impact solutions that shape the future of work. EY’s Indian operations are known for their robust training programmes, global mobility opportunities and a collaborative environment that encourages fresh talent to thrive. The Advanced Manufacturing, Mobility & Infrastructure (AMI) practice focuses on sectors such as aerospace, chemicals, automotive, industrial products and transportation. By pooling expertise across these industries, AMI helps clients redesign value chains, adopt emerging technologies and respond swiftly to market disruptions. Within AMI, the CNS – Risk – Process & Controls team assists organisations in identifying, assessing and mitigating risks that could impede strategic objectives. The team works across enterprise risk, technology risk and financial services risk, delivering audit, compliance and advisory services that enhance resilience and governance. As an Associate Consultant in this team, you will be the first line of execution for internal audit and risk advisory engagements. You will develop a deep understanding of client business processes, support walkthroughs, document controls, and perform testing to validate effectiveness. Your analytical skills will be applied to financial and operational data to spot trends, exceptions and potential risk hotspots. You will prepare working papers, risk‑control matrices, process flow diagrams and contribute to the preparation of client‑facing reports. The role offers exposure to a variety of industries, hands‑on experience with leading audit tools, and mentorship from senior consultants. Key responsibilities include: 1. Assisting senior team members in planning and executing internal audit and risk advisory engagements. 2. Conducting process walkthroughs and documenting business processes. 3. Performing control testing and evaluating control design effectiveness. 4. Analyzing financial, operational and transactional data to identify anomalies. 5. Preparing risk and control matrices, process flowcharts and working papers. 6. Supporting the review of client policies against regulatory and best‑practice standards. 7. Drafting preliminary findings and recommendations for senior review. 8. Collaborating with cross‑functional teams to gather evidence and insights. 9. Maintaining engagement documentation in line with EY methodology. 10. Continuously upskilling through EY’s learning platforms and certifications. Tech stack commonly used includes Microsoft Office (Excel, PowerPoint, Word), data analytics tools such as Tableau or Powerβ€―BI, audit software like ACL, and basic SQL for data extraction. The growth path typically moves from Analyst to Senior Consultant, then Manager, Senior Manager and eventually Director, with clear milestones for skill development and leadership exposure. Joining EY means access to world‑class training, a global network of professionals, and the chance to work on high‑impact projects that shape industries. Why join EY? You will be part of a prestigious brand that invests heavily in your professional development, offers a supportive and inclusive culture, and provides a clear career trajectory. The firm’s emphasis on mentorship, continuous learning and exposure to diverse clients makes it an ideal launchpad for a long‑term consulting career.

EY (Ernst & Young) β€” Data Analytics & SQL Interview Guide

Previously asked questions, exam syllabus, coding benchmarks & round strategy.

APTITUDE & LOGIC πŸ“–
Aptitude Practice Questions & Online Mock Tests

Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test.

Open Resource β†—
COMPANY GUIDE 🎯
EY (Ernst & Young) Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for EY (Ernst & Young) and off-campus tech roles.

Open Resource β†—
MOCK TESTS & PAPERS πŸ“
Comprehensive Interview Prep Resources & Syllabus

Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds.

Open Resource β†—
CODING PRACTICE πŸ’»
Algorithm and Data Structure Problem Set

Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Open Resource β†—
Round 1: Online Assessment (OA)
Aptitude, Quantitative Logic & 2 Coding Problems
Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1
Core Tech Stack (Internal audit, Risk assessment, Process mapping, Data analysis, Excel, PowerPoint, Communication, Problem solving, Teamwork, Attention to detail) & Live Code Tracing
Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving
Database Schemas, APIs & Architecture Basics
Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion
EY (Ernst & Young) Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between WHERE and HAVING clauses in SQL? Answer β–Ό
Model Answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer β–Ό
Model Answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer β–Ό
Model Answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer β–Ό
Model Answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer β–Ό
Model Answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Why do you want to join EY (Ernst & Young) as a Associate Consultant - Business Consulting Risk - AMI - CNS - Risk - Process & Controls - Ahmedabad?
Preparation Tip: Highlight EY (Ernst & Young)'s market reputation, recent tech innovations, and how your skills in Internal audit directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Preparation Tip: Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Preparation Tip: Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More Fresh Requirements in Software Engineering

View Category Feed β†—
EY (Ernst & Young)
Associate Consultant - Business Consulting Risk - AMI - CNS - Risk - Process & Controls - Ahmedabad
Apply Apply Now β†—
Chat Chat with Kashii