Question 8 of 15
Describe your experience with databases
💡 How to answer: Cover: SQL vs NoSQL tradeoffs, specific databases used (PostgreSQL, MongoDB, Redis), indexing, query optimization, connection pooling.
Question 1 of 15
Walk me through a data analysis project you did end-to-end
💡 How to answer: Cover: business problem → data collection → cleaning → analysis → insights → action taken. Quantify impact.
Question 2 of 15
What tools and languages do you use for data analysis?
💡 How to answer: Name SQL (mandatory), Python/pandas, Excel, visualization tools (Tableau, Power BI, Google Data Studio). Match to job description.
Question 3 of 15
How do you handle missing or dirty data?
💡 How to answer: Describe: identifying patterns in missingness, imputation strategies (mean, median, mode, forward fill), dropping vs keeping rows, documenting decisions.
Question 4 of 15
Explain the difference between correlation and causation
💡 How to answer: Clear definition of each. Example: ice cream sales and drowning rates correlate but neither causes the other. How you test for causation (A/B test, controlled experiment).
Question 5 of 15
What is a cohort analysis? Have you done one?
💡 How to answer: Cohort = group sharing a characteristic at a point in time. Used to track retention, LTV, churn. Walk through a real example if you have one.
Question 6 of 15
How would you present data insights to a non-technical audience?
💡 How to answer: Lead with the business impact, not the methodology. Use simple visualizations. Avoid jargon. Tell a story: problem → finding → recommendation → expected outcome.
Question 7 of 15
What is your experience with SQL? Give an example of a complex query
💡 How to answer: Demonstrate: JOINs, subqueries, CTEs, window functions. Describe a real analytical query you wrote and what it solved.
Question 8 of 15
How do you validate that your analysis is correct?
💡 How to answer: Cross-check with different methods, sanity check with business logic, peer review, test on subset before full run, compare with historical baselines.
Question 9 of 15
What is A/B testing and how would you design one?
💡 How to answer: Hypothesis → control/treatment groups → randomization → sample size calculation → run for statistical significance → interpret with p-value and confidence interval.
Question 10 of 15
What is the most important metric for a business you've worked on?
💡 How to answer: Show you understand business context. North Star Metric concept. Why you chose it and how it connects to revenue or retention.
Question 11 of 15
How do you prioritize when you have multiple data requests?
💡 How to answer: Impact × urgency framework. Alignment with business priorities. Communication with stakeholders about timelines.
Question 12 of 15
What is your experience with Python for data analysis?
💡 How to answer: Pandas, NumPy, Matplotlib/Seaborn, Jupyter notebooks. Describe a specific analysis you did — data size, transformations, visualizations produced.
Question 13 of 15
Explain regression analysis in simple terms
💡 How to answer: Regression finds the relationship between variables. Linear regression predicts a continuous value. Used to understand what drives a metric. Give a business example.
Question 14 of 15
What do you do when your data contradicts a stakeholder's assumption?
💡 How to answer: Present data transparently, verify your analysis first, show multiple cuts of data. Be diplomatic but stand behind evidence-based findings.
Question 15 of 15
Do you have any questions for us?
💡 How to answer: Ask about: data stack used, team size and structure, what a typical analyst project looks like, how data influences decisions at leadership level.
Question 1 of 15
Tell me about yourself
💡 How to answer: For HR: emphasize people skills, experience with HR processes, empathy and conflict resolution. Keep professional and focused.
Question 2 of 15
What is your experience with talent acquisition?
💡 How to answer: Full cycle recruiting: JD creation, sourcing, screening, interviews, offers. Mention ATS tools used and your hiring metrics (time-to-fill, offer acceptance rate).
Question 3 of 15
How do you handle a conflict between two employees?
💡 How to answer: Listen to both sides separately, understand facts vs perceptions, facilitate a joint meeting, focus on resolution not blame, document outcome.
Question 4 of 15
What is your experience with payroll and compliance?
💡 How to answer: Cover: payroll processing, PF, ESI, TDS, gratuity. Mention tools used (Darwinbox, Keka, GreytHR). Knowledge of labour laws — Industrial Disputes Act, Shops Act.
Question 5 of 15
How do you measure employee engagement?
💡 How to answer: Pulse surveys, eNPS, attrition rate, absenteeism, performance review completion rates. Describe how you acted on data.
Question 6 of 15
What is your approach to performance management?
💡 How to answer: Goal setting (OKRs/KRAs), mid-year check-ins, year-end reviews, calibration, dealing with underperformance (PIPs). Balance process with genuine development.
Question 7 of 15
How do you handle a difficult manager relationship?
💡 How to answer: Empathy first. Understand their pressures. Communicate clearly, document agreements, escalate only when necessary. Shows maturity.
Question 8 of 15
What is your experience with HR policies?
💡 How to answer: Policy creation (leave policy, POSH, code of conduct), communication, enforcement, handling exceptions.
Question 9 of 15
How do you stay updated with labour laws?
💡 How to answer: Ministry of Labour website, HR associations (NHRD, SHRM India), legal advisors, industry newsletters.
Question 10 of 15
Describe a time you handled a sensitive employee exit
💡 How to answer: Maintain dignity, clear communication of process, full and final settlement accuracy, exit interview learnings fed back to management.
Question 11 of 15
What HR tools and software are you proficient in?
💡 How to answer: ATS (Naukri RMS, iCIMS), HRMS (Darwinbox, SAP SuccessFactors, Keka), payroll tools, Excel for HR analytics.
Question 12 of 15
How do you handle POSH complaints?
💡 How to answer: Acknowledge immediately, maintain confidentiality, constitute ICC committee, follow defined inquiry process, time-bound resolution, document throughout.
Question 13 of 15
What metrics do you track as an HR professional?
💡 How to answer: Attrition rate, time-to-hire, cost-per-hire, training completion rate, eNPS, headcount, offer acceptance rate, internal mobility rate.
Question 14 of 15
How do you build trust with employees?
💡 How to answer: Confidentiality, consistency, follow-through on commitments, being accessible, not being seen as purely a management tool.
Question 15 of 15
Do you have any questions for us?
💡 How to answer: Ask about: HR team size, biggest people challenges currently, how HR is perceived by business leaders, technology roadmap for HR.
Interview Preparation FAQs
How many rounds are typical in Indian companies?
Startups: 2-4 rounds (screening + 1-2 technical + HR). MNCs: 4-6 rounds (online test + technical interviews + managerial + HR). FAANG companies: 5-7 rounds including system design and behavioral panels.
How early should I prepare for interviews?
Start preparation 2-3 weeks before applying. For senior roles or FAANG-type companies, 2-3 months of structured preparation is standard. Use this time to solve DSA problems, revise system design and prepare STAR stories.
How do I handle a question I don't know the answer to?
Be honest — "I haven't worked with that specifically, but here's how I'd approach learning it..." or walk through your logical thinking process. Lying or bluffing is always detected and always disqualifies you.