Chegg India

It was quite easy. First round: HR round Second round: Two team leads of the department Third round: Manager round. All rounds were super easy since this was for beginners. They didn't grill much. Asked basic questions like what are future goals, why this company, etc.

It was easy and good only assesment given for my subject. I give this interview virtually and then my work start after verification of my result and documents. The test related to our expertise and need to complete within time.

The process was smooth and efficient, wrapping up within two weeks. It included an assignment followed by two interview rounds, so it felt quick and straightforward. The panel came across as kind and genuinely curious rather than interrogative.

1️⃣ Application & Shortlisting ✔️ What happens: You apply on LinkedIn / Naukri. Recruiter screens your resume for: SQL skills Data cleaning + reporting Excel, Power BI Past projects Communication ✔️ If shortlisted: Recruiter calls you and says: “Hi Amit, this is ___ from ___. I saw your profile and wanted to schedule an interview for the Data Analyst/SQL Developer role.” 2️⃣ HR Screening Call (10–15 minutes) This call only checks: Can you communicate properly? Are you stable? Are you genuine? Salary & notice period? ✔️ Typical questions: Tell me about yourself. Tell me about your experience at your previous company. What database technologies have you used? Why are you looking for a change? What is your current CTC, expected CTC? Notice period? Are you comfortable with office timing/location/WFH? If you clear, HR books Technical Round 1. 3️⃣ Technical Round 1 (45–60 minutes) This round is mostly SQL + basic data analytics + scenario-based questions. ✔️ They check: SQL Joins GROUP BY, HAVING Window Functions Query Optimization Stored Procedures Indexing Data Cleaning logic Excel → VLOOKUP, Pivot Power BI basics ✔️ Example Questions: Write a query to find second highest salary. Difference between WHERE and HAVING. Use window function to calculate running total. How to optimize a slow query? What is normalization? What are clustered & non-clustered indexes? If this is cleared → You move to Technical Round 2. 4️⃣ Technical Round 2 (Case Study Round) (45–60 minutes) This is more practical. ✔️ They give tasks like: Analyze a dataset Create SQL queries Explain how you’ll build a report Write an end-to-end data cleaning pipeline Debug SQL queries ✔️ They may ask: “You have 3 tables: orders, customers, payments…write a SQL to find top 5 customers by revenue.” “How will you calculate retention rate?” “Explain a complex project you did.” If cleared → Managerial Round. 5️⃣ Managerial / Hiring Manager Round (30–40 minutes) This round checks: How you work with teams Ownership Real project experience How you handle deadlines Communication & attitude Problem-solving approach ✔️ Typical questions: “Explain your role in your previous company.” “How do you deal with pressure?” “Tell me about a challenge you solved.” “If we assign you a difficult dataset, how will you approach it?” “What value can you add to our team?” “Tell me about a time you optimized a query in real project.”

There was no interview process for this role, I applied through naukri.com and few days later i got an e-mail saying my resume was shortlisted then i had to sign up on NATS website, share the documents and the process was completed.