General Interview Questions & Answers 2026
Top data analyst interview questions for freshers and experienced in India. Covers SQL, Python, Excel, statistics, and case studies.
Quick Overview — General Interviews 2026
- Total questions covered: 5+ across all rounds
- Interview rounds: SQL/Python Assessment → Technical Interview → Case Study → HR Interview
- Question types: SQL, Statistics, Technical, Case Study
- Difficulty: Fresher, Mid-level, Senior
General Interview Process
The typical General interview process consists of 4 rounds. Understanding each round helps you prepare strategically.
How to Prepare for General Interview
Follow this structured preparation plan to maximize your chances at General.
Week 1-2: Fundamentals
Review core concepts for your role. For technical roles, practice DSA (LeetCode medium). For non-tech, review domain fundamentals and General's business model.
Week 3: Company Research
Study General's products, recent news, culture values, and competitors. Prepare your "Why General?" answer with specific examples.
Week 4: Mock Practice
Do 3-5 mock interviews using our AI Interview Gyani tool. Practice explaining your projects and past experiences using the STAR method.
Final Days: Review & Rest
Review these 5+ questions and answers. Prepare 5-6 questions to ask the interviewer. Get proper rest the night before.
Top General Interview Questions with Expert Answers
SQL Questions(2 questions)
Q1. Write a SQL query to find the second highest salary
EasyView Expert Answer
SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); Or: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;
Q2. What is the difference between WHERE and HAVING?
EasyView Expert Answer
WHERE filters rows before grouping (used with individual rows). HAVING filters groups after GROUP BY (used with aggregate functions). WHERE cannot use aggregates.
Statistics Questions(1 questions)
Q1. Explain the difference between correlation and causation
MediumView Expert Answer
Correlation: two variables move together (can be positive or negative). Causation: one variable directly causes change in another. Correlation doesn't imply causation - confounding variables may exist.
Technical Questions(1 questions)
Q1. How would you handle missing data?
MediumView Expert Answer
Approaches: deletion (listwise/pairwise), imputation (mean/median/mode, regression, KNN, MICE), or use algorithms that handle missing values (XGBoost). Choice depends on missing data mechanism (MCAR, MAR, MNAR).
Case Study Questions(1 questions)
Q1. Design a dashboard to track e-commerce performance
MediumView Expert Answer
Key metrics: GMV, conversion rate, AOV, DAU/MAU, bounce rate, cart abandonment. Visualizations: time series for trends, funnels for conversion, heatmaps for user behavior, cohort analysis for retention.
Pro Tips from Past General Candidates
Use the STAR method consistently
Structure every behavioral answer as Situation → Task → Action → Result. Interviewers are trained to evaluate STAR responses.
Ask thoughtful questions at the end
Ask about General's upcoming projects, team culture, or growth trajectory. Never ask about salary/benefits in the first round.
Research recent company news
Mention General's recent product launches, earnings, or industry moves in your answers. It shows genuine interest.
Prepare your 'Why this company?' answer
Don't give generic answers. Be specific: 'I admire General's [specific project/initiative] because...' with personal connection.
Follow up with a thank-you email
Send a brief, personalized thank-you within 24 hours referencing specific discussion points. It sets you apart from 90% of candidates.
Common Mistakes to Avoid
Practice These Questions with AI
Get instant feedback on your answers with our AI-powered mock interview tool. Practice General interview questions with real-time evaluation and scoring. Used by 50K+ candidates.
More Interview Preparation Resources
TCS Interview Questions & Answers 2026
8+ questions • IT Services
Infosys Interview Questions & Answers 2026
6+ questions • IT Services
Wipro Interview Questions & Answers 2026
5+ questions • IT Services
Amazon India Interview Questions & Answers 2026
6+ questions • Big Tech
Google India Interview Questions & Answers 2026
5+ questions • Big Tech
Microsoft India Interview Questions & Answers 2026
5+ questions • Big Tech
Flipkart Interview Questions & Answers 2026
4+ questions • E-commerce
SBI PO Interview Questions & Answers 2026
5+ questions • Banking
HDFC Bank Interview Questions & Answers 2026
4+ questions • Banking