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

Analyst - Data & Analytics

Company
Company JP Morgan
Type
Opportunity Type Internship
Salary
Stipend / Salary β‚Ή12 LPA - β‚Ή15 LPA
Location
Location Bengaluru, Karnataka
Posted Date
Posted Date Today
Data Analytics Alteryx Tableau SQL Excel SAP Hyperion Essbase Financial Analysis Regulatory Reporting Machine Learning Problem Solving Communication
πŸ“–
Aptitude Practice Questions Open Resource β†—
Curated quantitative and logical reasoning problems to sharpen the analytical skills needed for the online assessment.
πŸ“–
JP Morgan Recruitment Process Insights Open Resource β†—
First‑hand experiences and tips from candidates who have cleared JP Morgan interviews, helping you prepare for each round.
πŸ“–
Interview Preparation Guide for JP Morgan Open Resource β†—
Comprehensive guide covering typical interview questions, case studies, and preparation strategies specific to JP Morgan roles.
πŸ“–
Algorithm & Data Structure Problem Set Open Resource β†—
Extensive collection of coding problems to practice algorithmic thinking, useful for technical interviews involving data manipulation.

Graduates with a Bachelor's degree (B.Tech/B.E., B.Sc., B.Com, BBA) in Computer Science, Information Technology, Statistics, Finance, Economics or related fields. Minimum 60% aggregate (or CGPA 6.0/10). Pass out batch 2024‑2026 (or equivalent). No active backlogs at the time of joining. 2‑4 years of relevant experience in product control, financial control, accounting, data analytics or related domains is preferred. Strong communication skills in English, both written and verbal, are essential.

1
Round 1: Online Assessment (aptitude & logical reasoning)
2
Round 2: Technical Interview (data transformation, finance concepts, case studies)
3
Round 3: HR Interview (behavioral fit, motivation)
J.P. Morgan, a cornerstone of global finance for over two centuries, has evolved from a traditional banking house into a technology‑driven financial services powerhouse. In India, the firm operates across investment banking, consumer banking, asset management and payments, serving millions of customers and thousands of corporate clients. The organization’s culture blends rigorous risk discipline with an entrepreneurial spirit, encouraging employees to innovate while upholding the highest standards of integrity and compliance. With a strong focus on diversity and inclusion, JP Morgan offers a collaborative environment where talent from varied backgrounds can thrive and shape the future of finance. The Consumer & Community Banking (CCB) division, where this role sits, powers everyday banking experiences for millions of consumers through credit cards, mortgages, auto loans and digital payments. The CCB Data & Analytics team acts as the analytical engine, turning massive data streams into actionable insights that drive product strategy, risk mitigation and regulatory compliance. As an Analyst – Data & Analytics, you will be at the intersection of finance, technology and business, partnering with finance controllers, product owners, risk teams and senior leadership to ensure data‑driven decision making. Key responsibilities include: 1. Conduct month‑end analytical reviews to verify completeness and accuracy of financial statements. 2. Develop and document process flows, embedding internal controls to reduce financial and operational risk. 3. Prepare regulatory reports in line with US Fed and SEC requirements. 4. Create Management Information Summary decks that translate financial performance into strategic recommendations for senior leaders. 5. Identify, design and implement automation opportunities using Alteryx, deploying workflows to Alteryx Server. 6. Build, maintain, and enhance interactive Tableau dashboards for real‑time business monitoring. 7. Expand the data analytics framework by onboarding new data sources and supporting emerging user groups. 8. Proactively surface and resolve bottlenecks in product development lifecycles. 9. Cultivate strong relationships with cross‑functional partners, including technology, design, operations and control functions. 10. Contribute to strategic projects that align with the firm’s long‑term priorities. The technical stack revolves around Alteryx for data transformation, Tableau for visualization, and supporting tools such as Excel, SAP, Hyperion Essbase, SQL and Python for advanced analytics. A basic understanding of machine‑learning concepts is advantageous as the team increasingly incorporates predictive models into its workflow. Career growth is well‑defined: analysts can progress to senior analyst, associate manager, and eventually to managerial or specialist roles within the analytics or finance domains. JP Morgan’s global mobility programs also enable exposure to other markets and business lines. Why join JP Morgan? The firm offers a competitive compensation package, world‑class learning resources, mentorship from industry veterans, and the chance to work on high‑impact projects that shape the financial lives of millions. The blend of rigorous finance exposure and cutting‑edge analytics makes this role a launchpad for a rewarding career in data‑driven finance.

JP Morgan β€” 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 🎯
JP Morgan Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for JP Morgan 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 (Data Analytics, Alteryx, Tableau, SQL, Excel, SAP, Hyperion Essbase, Financial Analysis, Regulatory Reporting, Machine Learning, Problem Solving, 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
JP Morgan 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 JP Morgan as a Analyst - Data & Analytics?
Preparation Tip: Highlight JP Morgan's market reputation, recent tech innovations, and how your skills in Data Analytics 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 β†—
JP Morgan
Analyst - Data & Analytics
Apply Apply Now β†—
Chat Chat with Kashii