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.”
This is about my previous company role.
The following metrics were computed from 1 interview experience for the Chegg Data Engineer role in Noida, India.
Chegg's interview process for their Data Engineer roles in Noida, India is incredibly easy as the vast majority of engineers get an offer after going through it.
Candidates reported having very good feelings for Chegg's Data Engineer interview process in Noida, India.