KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
REQUIREMENT_ID_178 โ€ข 3-DAY_ACTIVE_POLICY

Associate Analyst

Company
Company EY (Ernst & Young)
Type
Opportunity Type Internship
Salary
Stipend / Salary โ‚น6 LPA - โ‚น9 LPA
Location
Location Mumbai, Maharashtra
Posted Date
Posted Date Yesterday
Python SQL Databricks Azure Data Engineering ETL Data Modeling Risk Management Analytical Thinking Communication
๐Ÿ“–
Aptitude Practice Questions Open Resource โ†—
Curated quantitative and logical reasoning problems to help you ace the online assessment for EY.
๐Ÿ“–
Risk Consulting Interview Prep Open Resource โ†—
Targeted interview questions and concepts related to EY's risk consulting practice.
๐Ÿ“–
General Preparation Resources Open Resource โ†—
Comprehensive guides covering resume building, interview etiquette and case study basics for consulting roles.
๐Ÿ“–
Coding Practice Problems Open Resource โ†—
A wide range of algorithmic challenges to sharpen your Python and SQL coding skills for technical rounds.

Bachelor of Technology (B.Tech) in Computer Science or equivalent. Minimum 60% aggregate in graduation (or CGPA 6.5/10). No active backlogs at the time of joining. Fresher โ€“ no prior work experience required.

1
Round 1: Online Aptitude & Logical Reasoning Test
2
Round 2: Technical Interview (Python, SQL, Data Engineering concepts)
3
Round 3: HR Interview (behavioural fit, motivations)
Ernst & Young (EY) is one of the worldโ€™s leading professional services firms, offering assurance, tax, transaction and advisory services to a diverse portfolio of clients across industries. With a presence in more than 150 countries, EY combines deep industry knowledge with cuttingโ€‘edge technology to help organisations navigate complex challenges and create sustainable value. The firmโ€™s culture is built around its purpose โ€“ "building a better working world" โ€“ and it invests heavily in learning, mentorship and career development for its people. The Business Consulting Risk practice at EY focuses on helping clients identify, assess and mitigate a wide spectrum of risks, ranging from enterpriseโ€‘wide strategic risks to technologyโ€‘driven vulnerabilities. Within this practice, the National team works across sectors, giving consultants exposure to varied business environments and the opportunity to develop a holistic riskโ€‘management skill set. As an Associate Consultant, you will be part of a collaborative team that delivers dataโ€‘driven insights and robust risk frameworks to Fortuneโ€‘500 companies and emerging businesses alike. **Key Responsibilities** 1. Design, develop and maintain endโ€‘toโ€‘end data pipelines using Python, SQL and Databricks to support riskโ€‘analytics engagements. 2. Extract, transform and load (ETL) structured and semiโ€‘structured data from multiple sources, ensuring data quality and consistency. 3. Write optimized SQL queries and scripts for adโ€‘hoc analysis and reporting. 4. Assist senior consultants in building riskโ€‘assessment models, dashboards and visualisations for client presentations. 5. Participate in client workshops to understand business requirements and translate them into technical specifications. 6. Conduct data validation, testing and documentation to ensure productionโ€‘ready deliverables. 7. Stay updated with Azureโ€‘based data platforms and recommend cloudโ€‘enabled solutions where appropriate. 8. Contribute to knowledgeโ€‘sharing sessions within the team and help build reusable assets. 9. Support compliance and internalโ€‘control reviews by providing accurate data extracts and analytical support. 10. Collaborate with crossโ€‘functional teams, including technology and people advisory services, to deliver integrated risk solutions. **Tech Stack**: Python, SQL, Databricks, Azure Data Lake/SQL, Power BI/Tableau for visualisation, Git for version control. **Growth Path**: Starting as an Associate Consultant, you can progress to Senior Consultant, Manager, Senior Manager and eventually Director or Partner, with regular performance reviews, formal training programmes and opportunities for international assignments. **Why Join EY**: EY offers a globally recognised brand, exposure to highโ€‘impact projects, a structured learning ecosystem (EYU โ€“ EY University), and a culture that values diversity, inclusion and wellbeing. Fresh graduates get handsโ€‘on experience with cuttingโ€‘edge technologies, mentorship from industry leaders and a clear roadmap for career advancement.

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 (Python, SQL, Databricks, Azure, Data Engineering, ETL, Data Modeling, Risk Management, Analytical Thinking, Communication) & 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 Analyst?
Preparation Tip: Highlight EY (Ernst & Young)'s market reputation, recent tech innovations, and how your skills in Python 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 & Tech

View Category Feed โ†—
EY (Ernst & Young)
Associate Analyst
Apply Apply Now โ†—
Chat Chat with Kashii