PM
Priya Mehta✓ Completed"Got my HDFC interview call within 3 weeks. Cleared the SQL round first attempt — window functions practice was the game changer."
💼 Hired at HDFC Bank · ₹7.2 LPA · Bengaluru
📖 About This Step
This step walks you through a complete 30-day preparation plan to crack the HDFC Data Analyst interview — built from Arjun's own hiring experience. It covers every stage from understanding the role and mastering SQL to mock interviews, offer negotiation and follow-up. Whether you're a fresher or making a lateral move, this guide gives you the exact roadmap, resources and daily schedule to go from zero to interview-ready in one month.
🎯 Expected Outcome
Land a Data Analyst interview at HDFC or similar bank within 30–45 days
Clear the SQL round confidently — the most common rejection point
Crack case studies with a structured banking analytics framework
Negotiate salary above ₹6 LPA with a data-backed counter-offer script
💡 What You Will Gain
Advanced SQL Skills
JOINs, window functions, CTEs — interview-ready
Banking Analytics Thinking
SCQA framework for case studies
Excel + Tableau Proficiency
Pivot tables, dashboards, data viz
Interview Confidence
Technical + HR rounds preparation
A Job Offer
41% of completers got hired
Salary Negotiation Skills
Data-backed counter-offer script
📋 Prerequisites
Basic SQL knowledge
Excel / Google Sheets
Graduation completed
Resume ready
3–4 hours/day available
🗺️ Route Overview · 5 stops
Open in Explore →
✓
Canggu
📍
Seminyak
🔒
Ubud
🔒
Kintamani
🎯
Nusa Penida
~180 km total · 5 days
24 experiences on the route
View Insights for This Step
Food & Local Specialties
What to Buy
Vibe & Experience
Scam Alerts
Safety
Attractions
Tasks (12)
1 of 12 completed
✓
Understand the Role — What Does a Data Analyst Do at HDFC?
Start by understanding exactly what HDFC expects from a Data Analyst. Read their job description carefully — note keywords like SQL, Python, Excel, Tableau. Visit LinkedIn to see what current HDFC analysts post about their day-to-day work.
Sub-tasks
Read 5 HDFC Data Analyst JDs on LinkedIn
Search "Data Analyst HDFC" on LinkedIn Jobs. Open the top 5 listings. Create a Google Sheet noting every skill, tool and responsibility mentioned. Highlight ones appearing 3+ times.
📍 Canggu, Bali — surf cafes & co-working
Connect with 3 current HDFC Analysts on LinkedIn
Search "Data Analyst HDFC Bank" on LinkedIn People. Send connection requests with a personal note asking about their typical day and what they'd tell someone preparing for the interview.
Resume Review by Arjun (StepUpiq)External linkVisit→
SQL Practice Workbook — AmazonBook · AmazonRecommended resource→
📍 Seminyak, Bali — beach clubs & restaurants
2
Build Your SQL Foundation — The Most Important Skill
HDFC interviews almost always start with SQL. Focus on: JOINs (inner, left, right), window functions (ROW_NUMBER, RANK, LAG/LEAD), CTEs, subqueries, and aggregation. Practice on HackerRank SQL track — aim for 50 problems minimum.
Sub-tasks
Complete all JOIN types with practice problems
Do 10 JOIN problems on HackerRank. Understand when to use each type. Write your own examples on a test database.
📍 Ubud, Bali — rice terraces & yoga retreats
Master Window Functions — ROW_NUMBER, RANK, LAG, LEAD
Window functions appear in almost every HDFC technical round. Practice PARTITION BY + ORDER BY. Do 15 LeetCode window function problems.
CTEs and Subqueries — WITH clause, correlated queries
CTEs make complex queries readable and are heavily tested. Practice multi-level CTEs. Understand differences between CTEs vs subqueries vs temp tables.
📍 Ubud, Bali — rice fields & quiet co-working
3
Case Study Frameworks for Banking Analytics
Learn the SCQA framework (Situation, Complication, Question, Answer) used in banking analytics interviews. Practice with 5 real HDFC-style case studies covering credit card churn, loan default prediction and branch performance analysis.
Sub-tasks
Learn the SCQA Framework
SCQA = Situation, Complication, Question, Answer. Practice until instinctive. Write out 2 examples from your own experience using this structure.
+ Add Location for this sub-task
Solve 5 Banking Analytics Case Studies
Work through real banking case studies. Time yourself — 20 minutes per case. Focus on structuring your approach before jumping to numbers.
4
Excel + Tableau Crash Course
Master Excel pivot tables, VLOOKUP, INDEX/MATCH and basic Tableau dashboards. These are tested in HDFC's practical assessment round.
Sub-tasks
Excel Pivot Tables + Advanced Functions
Build 3 pivot tables from a sample banking dataset. Practice VLOOKUP + INDEX/MATCH on the same dataset to understand when to use each.
Build a Tableau Dashboard
Use Tableau Public (free). Connect to a sample banking CSV. Build a dashboard with: monthly trend line, regional bar chart, and KPI scorecard. Publish to Tableau Public and add to your resume.
5
Mock Interview Round 1 — Technical
Do 3 full mock technical interviews — SQL questions, case study, and Excel task. Record yourself and review for clarity, speed and structure.
Sub-tasks
SQL Mock — 45-minute timed session
Set a 45-minute timer. Answer 5 SQL questions from the practice sheet without any help. Review mistakes after.
Case Study Mock — SCQA applied
Take one of the 5 case studies from Task 3. Present it out loud using SCQA. Record the video. Review your structure and timing.
6
HR Round Preparation
Prepare STAR-format answers for the 10 most common HDFC HR questions. Practice salary expectation discussion with a data-backed number.
Sub-tasks
Write STAR answers for top 10 HR questions
Use the STAR format: Situation, Task, Action, Result. Write out each answer fully. Keep each under 2 minutes when spoken.
7
Resume Final Polish
Run your resume through Jobscan against HDFC JDs. Fix ATS issues. Quantify every bullet point. Get a peer review from someone in analytics.
Sub-tasks
ATS score check + fix
Upload your resume and the HDFC JD to Jobscan. Fix every flagged issue. Aim for 75%+ match score before applying.
8
Mock Interview Round 2 — Full Simulation
Full interview simulation back to back — technical + HR + case study. Aim for 45 minutes total. Get honest feedback from a peer or mentor.
9
Network + LinkedIn Outreach
Connect with 10 more HDFC employees. Post a learning update on LinkedIn — this signals active job seeking to recruiters in your network.
10
Apply + Track Applications
Apply to HDFC + 4 similar roles (Axis, ICICI, Kotak, Yes Bank). Set up an application tracking sheet. Apply referral links where available.
11
Follow Up + Stay Warm
Send a follow-up email 5 days after applying. Connect with the hiring manager on LinkedIn. Keep practicing SQL daily while waiting.
12
Salary Negotiation Script
Don't accept the first number. Use the data-backed script: "Based on my research, the market rate for this role in Bengaluru is ₹X–Y. Given my [specific skill], I'm targeting ₹Z." HDFC has 15–20% flexibility.
📅 Daily Plan View
Day 1
Task 1
Understand the Role
Read 5 HDFC Data Analyst JDs on LinkedIn45 min
Set up HackerRank + MySQL Workbench30 min
Day 2
Task 1
Understand the Role
Connect with 3 HDFC Analysts on LinkedIn30 min
Write your personal skill gap list20 min
Day 3
Task 2
SQL Deep Dive
JOINs — INNER, LEFT, RIGHT, FULL practice set2 hr
10 HackerRank SQL Easy problems1 hr
Day 4–5
Task 2
SQL Deep Dive
Window functions — ROW_NUMBER, RANK, LAG/LEAD2 hr
CTEs + subqueries with real banking datasets1.5 hr
Day 6+
Premium
Remaining 26 days
🔒 Unlock to see full sub-task daily plan—
🔗 Related Steps
Crack Axis Bank Data Analyst in 30 Days
Data Analyst at a Startup — A Different Playbook
🏆 Success Stories
RS
Rohan Sharma✓ Completed"The SCQA framework completely changed how I structure my answers. Got an offer from Axis Bank within 5 weeks."
💼 Hired at Axis Bank · ₹6.8 LPA · Mumbai
DK
Divya Krishnan✓ Completed"As a non-CS fresher this felt overwhelming. The daily plan made it manageable — just follow Day 1, Day 2. Completed in 28 days."
💼 Hired at ICICI Bank · ₹6.2 LPA · Chennai
💬 Comments (0)
Log in to leave a comment or rate this step.
No comments yet. Be the first to share your experience!