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

Analyst

Company
Company EY (Ernst & Young)
Type
Opportunity Type Full-Time Job
Salary
Stipend / Salary 6.5 LPA (approx.)
Location
Location Bengaluru
Posted Date
Posted Date Yesterday
Alteryx Power BI SQL Python PySpark AI/ML VBA UiPath Power Automate data management communication multitasking analytical thinking
πŸ“–
Aptitude Practice for Technical Roles Open Resource β†—
Provides a wide range of aptitude questions to sharpen quantitative and logical reasoning skills needed for EY’s online tests.
πŸ“–
Technical Interview Preparation Open Resource β†—
Offers resources on data analytics, programming, and audit concepts that are frequently asked in EY technical interviews.
πŸ“–
Coding Practice for Data Analytics Open Resource β†—
Contains coding challenges and solutions that help build proficiency in Python, SQL, and data manipulation for analytics roles.
πŸ“–
Algorithmic Problem Solving Open Resource β†—
Features algorithmic problems to improve problem‑solving speed and logic, useful for technical rounds at EY.

Bachelor of Computer Applications or related field, 0–1 years of experience, strong academic record (minimum 60% in final year), no backlog, good communication and analytical skills.

1
Round 1: Online aptitude and technical test
2
Round 2: Technical interview (case study, coding, analytics)
3
Round 3: HR interview (cultural fit, motivation)
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 is known for its culture of innovation, integrity, and a commitment to building a better working world. In India, EY has grown rapidly, becoming a top employer for fresh graduates and early‑career professionals, thanks to its focus on learning, mentorship, and exposure to high‑impact projects. The Analyst – Assurance – National – ASU – Audit – Standards and Methodologies role is designed for recent graduates who are passionate about data analytics, audit standards, and emerging technologies. Based in Bengaluru, the analyst will work in a sector‑agnostic team that handles multiple engagements across industries, providing audit, financial accounting advisory services, IFRS & US GAAP conversion, IPO support, and treasury services. The role blends client engagement, technical analysis, and continuous improvement, giving you a well‑rounded experience in assurance. Key Responsibilities: 1. Engage with clients to understand business processes and audit requirements. 2. Collaborate with engagement teams to meet deadlines and deliver high‑quality work. 3. Apply audit analytics techniques using Alteryx, Power BI, SQL, and Python. 4. Build and maintain data models, dashboards, and automated reports. 5. Stay updated on industry trends, AI/ML applications, and audit best practices. 6. Develop automation scripts using VBA, UiPath, and Power Automate to streamline repetitive tasks. 7. Participate in cross‑functional discussions to provide insights to audit committees. 8. Maintain strong communication skills and present findings to stakeholders. 9. Demonstrate teamwork, adaptability, and a willingness to travel or work on weekends when required. 10. Contribute to continuous improvement initiatives and share learnings with the team. Tech Stack: Alteryx, Power BI, SQL, Python, PySpark, VBA, UiPath, Power Automate, AI/ML models, data management tools. Growth Path: Starting as an Analyst, you can progress to Senior Analyst, Manager, Senior Manager, and eventually to Director or Partner roles. EY’s structured career framework, mentorship programmes, and global mobility opportunities enable rapid skill development and leadership exposure. Why Join EY: EY offers a collaborative environment, world‑class training, and exposure to cutting‑edge technologies. The firm’s commitment to diversity, inclusion, and work‑life balance, combined with competitive compensation and a strong brand reputation, makes it an attractive destination for fresh graduates looking to build a long‑term career in assurance and analytics.

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 (Alteryx, Power BI, SQL, Python, PySpark, AI/ML, VBA, UiPath, Power Automate, data management, communication, multitasking, analytical thinking) & 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 Analyst?
Preparation Tip: Highlight EY (Ernst & Young)'s market reputation, recent tech innovations, and how your skills in Alteryx 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)
Analyst
Apply Apply Now β†—
Chat Chat with Kashii