Data Analyst interview questions

1) What joins are mostly used in SQL?
2) Use cases of Cross and Self Joins?
3) Write a query to exclude weekends from a table?
4) What are Window Functions?
5) What is the difference between CTEs and Subqueries?
6) How can you optimize SQL queries?
7) How can you convert data from rows into columns?
8) If there are 10 different KPIs calculated from different tables on a daily basis, how would you compile them into a single report?

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

Hope it helps :)

IQVIA Internship, 2025!
Position: Junior Data Analyst Intern
Qualifications: Bachelor’s/ Master’s Degree
Salary: 35K Per Month (Expected)
Batch: 2023/ 2024/ 2025/ 2026
Experience: Freshers
Location: Bengaluru, India

📌Apply Now: https://jobs.iqvia.com/en/job/bengaluru/junior-data-analyst-intern-campus/24443/77368563808

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

United Airlines is hiring!
Position: Associate - Data Scientist
Qualifications; Bachelor's degree
Experience: Freshers (0 - 2 Years)
Location: Gurugram, India

📌Apply Now: https://careers.united.com/us/en/job/UAIUADUSGGN00001915EXTERNALENUSTALEO/Associate-Data-Scientist

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Volvo is hiring!
Position: Data Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 8 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: India

📌Apply Now: https://jobs.volvocars.com/job/Bengaluru-Data-Analyst-KA-562122/1177535301/

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Unisys is hiring Junior Analyst 🚀

Qualification : Bachelor's degree
Experience : 0-2 Years
Location : Bangalore

Apply link : https://unisys.wd5.myworkdayjobs.com/External/job/Bangalore-KA-India/Jr-Analyst---Business-Operations_REQ563883?source=LinkedIn

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Rapido is hiring Data Analyst Intern 🚀

Qualification : Bachelor's degree
Experience : Freshers
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4173386007

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Stop obsessing over Python and SQL skills.

Here are 5 non-technical skills that make exceptional data analysts:

- Business Acumen
Understand the industry you're in. Know your company's goals, challenges, and KPIs. Your analyses should drive business decisions, not just process data.

- Storytelling
Data without context is just noise. Learn to craft compelling narratives around your insights. Use analogies, visuals, and clear language to make complex data accessible.

- Stakeholder Management
Navigate office politics and build relationships. Know how to manage expectations, handle difficult personalities, and align your work with stakeholders' priorities.

- Problem-Solving
Develop ability for identifying the real problem behind the data request. Often, the question asked isn’t the one that truly needs solving. It’s your job as a data analyst to dig deeper, challenge assumptions, and uncover the actual business challenge.

Technical skills may get you started, but it’s the soft skills that truly advance your career. These are the skills that turn a good analyst into an essential part of the team.

The best data analysts aren't just number crunchers - they guide the strategy that drives the business forward.

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02

Hope this helps you 😊

Volvo is hiring!
Position: Data Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 8 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: India

📌Apply Now: https://jobs.volvocars.com/job/Bengaluru-Data-Analyst-KA-562122/1177535301/

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Carrier Internship, 2025!
Position: Intern, Data Science & Analytics
Qualifications: Bachelor’s/ Master’s Degree
Salary: Company Standard
Batch: 2024/ 2025/ 2026/ 2027
Experience: Freshers
Location: India

📌Apply Now: https://carrier.wd5.myworkdayjobs.com/jobs/job/Capital-Cyberscape-2nd-Floor-Ullahwas-Sector-59-Gurugram-Haryana-122102/Intern--Data-Science-and-Analytics_30175474/

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

American Express is hiring!
Position: Business Analyst/ Data Analytics
Qualification: Bachelor’s/ Master’s/ MBA
Salary: 6.5 - 13 LPA (Expected)
Experience: Freshers & Experienced
Location: Work From Home/ Office

📌Apply Now: https://aexp.eightfold.ai/careers/job/27369235?hl=en

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

𝐂𝐨𝐠𝐧𝐢𝐳𝐚𝐧𝐭 - 𝐖𝐨𝐫𝐤 𝐟𝐫𝐨𝐦 𝐇𝐨𝐦𝐞!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 4.8 - 7.3 LPA (Expected)
Experience: Freshers/ Experienced
Location: Work From Home

📌Apply Now: https://careers.cognizant.com/india-en/jobs/00061457401/data-analyst/

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Data Analyst Jobs

Pinkerton is hiring Data Analyst
https://pinkerton.com/job/PINKERTONR5471/data-analyst

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Ericsson is hiring Data Analyst
https://jobs.ericsson.com/careers/job/563121762631654-data-analyst-noida-uttar-pradesh-india?domain=ericsson.com

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

United Airlines hiring Associate Analyst
https://www.linkedin.com/jobs/view/4137554324

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Zynga hiring Data Analyst
http://job-boards.greenhouse.io/zyngacareers/jobs/5382154004

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

PayPal hiring Machine Learning Engineer
https://paypal.eightfold.ai/careers/job/274904930119-machine-learning-engineer-3-chennai-tamil-nadu-india?domain=paypal.com

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Persistent Systems hiring Business Analyst
https://www.linkedin.com/jobs/view/4159893392/

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Postman is hiring Applied AI Engineer
https://job-boards.greenhouse.io/postman/jobs/6083517003?gh_src=7ad26f843us

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Figma is hiring Data Scientist
https://job-boards.greenhouse.io/figma/jobs/5227981004?gh_jid=5227981004&gh_src=feb3e0b14us

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Qualcomm is hiring Data Analyst
https://careers.qualcomm.com/careers/job/446702858394

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Capgemini is hiring Data Analyst

https://www.capgemini.com/in-en/jobs/10365-en_US+sap_btp

https://www.capgemini.com/in-en/jobs/25846-en_US+sap_btp

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Deloitte is hiring!
Position: Analyst - Learning Delivery
Salary: 4 - 7 LPA (Expected)
Qualifications: Bachelor’s/ Master’s/ MBA
Experience: Freshers/ Experienced
Location: Hyderabad; Gurugram, India

📌Apply Now: https://usijobs.deloitte.com/careersUSI/JobDetail/USI-EH25-EA-Talent-Services-Learning-Delivery-Analyst/205997

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Paytm Payments Bank is hiring HR Data Analyst 🚀

Experience : 1+ Year
Location : Noida

Apply link : https://jobs.lever.co/paytmbank/5cc11899-e816-47f6-b500-18d481bd525b/apply?lever-source=LinkedIn

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Data Analytics Jobs 👇👇

United Airlines is hiring Associate - Data Scientist 🚀
Experience : 0-2 Years
Location : Gurugram

Apply link : https://careers.united.com/us/en/job/UAIUADUSGGN00001915EXTERNALENUSTALEO/Associate-Data-Scientist?utm_source=linkedin&utm_medium=phenom-feeds

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

NatWest Group is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 6.5 - 10 LPA (Expected)
Location: Chennai, India (Hybrid)

📌Apply Now: https://jobs.natwestgroup.com/jobs/15724653-data-analyst?tm_job=R-00252166-OTHLOC-IND-5FCHE051&tm_event=view&tm_company=861

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

United Airlines is hiring!
Position: Associate - Data Scientist
Qualifications; Bachelor's degree
Experience: Freshers (0 - 2 Years)
Location: Gurugram, India

📌Apply Now: https://careers.united.com/us/en/job/UAIUADUSGGN00001915EXTERNALENUSTALEO/Associate-Data-Scientist

➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

Cartwheel is hiring Business Operations Analyst 🚀
Experience : 0-2 Years
Location : Remote ( USA )

Apply link : https://grnh.se/1129cfe37us?gh_src=linkedin
➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️➖️

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

📌NielsenIQ is hiring for Data Processing Analyst
Experience: 0 - 2 year's
Salary: 3-4 LPA
Apply here: https://jobs.smartrecruiters.com/NielsenIQ/744000045863751-data-processing-analyst

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

JPMorgan is hiring!
Position: Business Management - Associate
Qualification: Bachelor’s Degree
Salary: 7 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Mumbai, India

📌Apply Now: https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/requisitions/preview/210598590/?keyword=210598590&mode=location

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

IQVIA is hiring Freshers!
Position: Trainee
Qualifications: Bachelor’s/ Master’s Degree
Salary: 4.5 LPA (Expected)
Experience: Freshers
Location: Across India

📌Apply Now: https://jobs.iqvia.com/en/job/kochi/trainee-cdc/24443/77598029568

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

Koch is hiring Junior Associate Analyst 🚀

Qualification : Any Graduate
Experience : 0-3 Years
Location : Bangalore

Apply link : https://koch.avature.net/en_US/careers/JobDetail/165893

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships

🎯 𝐄𝐬𝐬𝐞𝐧𝐭𝐢𝐚𝐥 𝐃𝐀𝐓𝐀 𝐀𝐍𝐀𝐋𝐘𝐒𝐓 𝐒𝐊𝐈𝐋𝐋𝐒 𝐓𝐡𝐚𝐭 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐞𝐫𝐬 𝐋𝐨𝐨𝐤 𝐅𝐨𝐫 🎯

If you're applying for Data Analyst roles, having technical skills like SQL and Power BI is important—but recruiters look for more than just tools!

🔹 1️⃣ 𝐒𝐐𝐋 𝐢𝐬 𝐊𝐈𝐍𝐆 👑—𝐌𝐚𝐬𝐭𝐞𝐫 𝐈𝐭
✅ Know how to write optimized queries (not just SELECT * from everywhere!)
✅ Be comfortable with JOINS, CTEs, Window Functions & Performance Optimization
✅ Practice solving real-world business scenarios using SQL
💡 Example Question: How would you find the top 5 best-selling products in each category using SQL?

🔹 2️⃣ 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐀𝐜𝐮𝐦𝐞𝐧: 𝐓𝐡𝐢𝐧𝐤 𝐋𝐢𝐤𝐞 𝐚 𝐃𝐞𝐜𝐢𝐬𝐢𝐨𝐧-𝐌𝐚𝐤𝐞𝐫
✅ Understand the why behind the data—not just the numbers
✅ Learn how to frame insights for different stakeholders (Tech & Non-Tech)
✅ Use data storytelling—simplify complex findings into actionable takeaways
💡 Example: Instead of saying, "Revenue increased by 12%," say "Revenue increased 12% after launching a targeted discount campaign, driving a 20% increase in repeat purchases."

🔹 3️⃣ 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 / 𝐓𝐚𝐛𝐥𝐞𝐚𝐮—𝐌𝐚𝐤𝐞 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝𝐬 𝐓𝐡𝐚𝐭 𝐒𝐩𝐞𝐚𝐤!
✅ Avoid overloading dashboards with too many visuals—focus on key KPIs
✅ Use interactive elements (filters, drill-throughs) for better usability
✅ Keep visuals simple & clear—bar charts are better than complex pie charts!
💡 Tip: Before creating a dashboard, ask: "What business problem does this solve?"

🔹 4️⃣ 𝐏𝐲𝐭𝐡𝐨𝐧 & 𝐄𝐱𝐜𝐞𝐥—𝐇𝐚𝐧𝐝𝐥𝐞 𝐃𝐚𝐭𝐚 𝐄𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭𝐥𝐲
✅ Python for data wrangling, EDA & automation (Pandas, NumPy, Seaborn)
✅ Excel for quick analysis, PivotTables, VLOOKUP/XLOOKUP, Power Query
✅ Know when to use Excel vs. Python (hint: small vs. large datasets)

Being a Data Analyst is more than just running queries—it’s about understanding the business, making insights actionable, and communicating effectively!

Free Resources: https://t.me/sqlspecialist

Optum is hiring!
Position: Data Analyst – SQL, Azure Data Bricks, Python
Qualification: Bachelor’s Degree
Salary: 6 - 14 LPA (Expected)
Experience: Freshers/ Experienced
Location: Hyderabad, India

📌Apply Link: https://careers.unitedhealthgroup.com/job/21508127/data-analyst-power-bi-sql-alteryx-hyderabad-in/

👉WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

👉Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5

Like for more ❤️

All the best 👍 👍

#jobs #internships