Crack the Technical Round: India Data & Tech Jobs with Ayan Sinha

Walk into your data or tech interview already knowing the questions.

Most freshers prepare by memorising hundreds of random questions. Then the interviewer changes one word, and the memorised answer is useless. Crack the Technical Round takes a different approach. Fresher technical rounds at Indian companies reuse a small set of question patterns. Learn the patterns, and every new question is one you’ve already solved in a different form.

Written for India’s job market: IT services, GCCs, product companies, analytics firms, banks and startups.

Inside the 71 pages:

• 17 SQL patterns that cover most SQL interview questions: Nth-highest salary, top-N per group, running totals, month-on-month growth, duplicates, self-joins, streaks, cohorts, funnels, pivots, medians and more. Every query was run on real practice data, and the actual output is printed under it.
• Excel and Power BI: XLOOKUP, SUMIFS, pivots, DAX measures, and how to handle a 30-minute live task.
• Python and pandas: 8 pandas patterns and 6 core-Python classics, all executed.
• Statistics and A/B testing in plain words: p-values, confidence intervals, Bayes and the “peeking” trap.
• Guesstimates and case studies with Indian examples: chai cups sold in Bengaluru, daily food orders in Pune, “why did orders drop 15%?”, and success metrics for UPI AutoPay.
• Tech track: 12 DSA patterns, CS fundamentals and data-engineering basics.
• Online assessments: TCS NQT-style test structure, 12 aptitude shortcuts and a proctoring checklist.
• HR rounds Indian candidates actually face: relocation, night shifts, service bonds, gap years, low CGPA.
• Your offer, decoded: a ₹6 LPA CTC worked down to about ₹45,000 a month in hand under the 2025 labour codes, plus bonds, background verification and fresher negotiation scripts.
• Bonus: a 120-question bank, an SQL cheat sheet, a resume template and a 30-day study plan.

Includes: four practice CSV files, so you can rerun every example yourself.

Ideal for final-year students, recent graduates and career switchers going after their first Data Analyst, Business Analyst, Product Analyst, BI or junior tech role in India.

Know the pattern. Show your thinking. Get the offer.