PhonePe is hiring!
Position: Business Operations Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 7 - 14 LPA (Expected)
Experience: 1 - 4 (Years)
Location: Bengaluru, India

📌Apply Now: https://job-boards.greenhouse.io/phonepe/jobs/6616277003

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

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

All the best! 👍👍

📘 SQL Challenges for Data Analytics – With Explanation 🧠

(Beginner ➡️ Advanced)

1️⃣ Select Specific Columns

SELECT name, email FROM users;

This fetches only the name and email columns from the users table.

✔️ Used when you don’t want all columns from a table.


2️⃣ Filter Records with WHERE

SELECT * FROM users WHERE age > 30;

The WHERE clause filters rows where age is greater than 30.

✔️ Used for applying conditions on data.


3️⃣ ORDER BY Clause

SELECT * FROM users ORDER BY registered_at DESC;

Sorts all users based on registered_at in descending order.
✔️ Helpful to get latest data first.


4️⃣ Aggregate Functions (COUNT, AVG)

SELECT COUNT(*) AS total_users, AVG(age) AS avg_age FROM users;

Explanation:
- COUNT(*) counts total rows (users).
- AVG(age) calculates the average age.
✔️ Used for quick stats from tables.


5️⃣ GROUP BY Usage

SELECT city, COUNT(*) AS user_count FROM users GROUP BY city;

Groups data by city and counts users in each group.

✔️ Use when you want grouped summaries.


6️⃣ JOIN Tables

SELECT users.name, orders.amount  
FROM users  
JOIN orders ON users.id = orders.user_id;

Fetches user names along with order amounts by joining users and orders on matching IDs.
✔️ Essential when combining data from multiple tables.


7️⃣ Use of HAVING

SELECT city, COUNT(*) AS total  
FROM users  
GROUP BY city  
HAVING COUNT(*) > 5;

Like WHERE, but used with aggregates. This filters cities with more than 5 users.
✔️ **Use HAVING after GROUP BY.**


8️⃣ Subqueries

SELECT * FROM users  
WHERE salary > (SELECT AVG(salary) FROM users);

Finds users whose salary is above the average. The subquery calculates the average salary first.

✔️ Nested queries for dynamic filtering9️⃣ CASE Statementnt**

SELECT name,  
  CASE  
    WHEN age < 18 THEN 'Teen'  
    WHEN age <= 40 THEN 'Adult'  
    ELSE 'Senior'  
  END AS age_group  
FROM users;

Adds a new column that classifies users into categories based on age.
✔️ Powerful for conditional logic.

🔟 Window Functions (Advanced)

SELECT name, city, score,  
  RANK() OVER (PARTITION BY city ORDER BY score DESC) AS rank  
FROM users;

Ranks users by each city.

SQL Learning Series: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v/1075

JPMorgan is hiring!
Position: Quant Analytics - Associate
Qualification: Bachelor’s/ Master’s Degree
Salary: 7 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: India

📌Apply Now: https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/job/210601325?keyword=Quantitative+Analytics+Associate&mode=location

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

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

All the best! 👍👍

PhonePE is hiring Business Operations Analyst 🚀

Min. Experience : 1 Year
Location : Bangalore

Apply link : https://app.greenhouse.io/embed/job_app?token=6616277003&gh_src=961e65dc3us

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

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

All the best! 👍👍

Tata Consultancy Services hiring Data Analyst

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

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

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

All the best! 👍👍

JLL is hiring Freshers!
Position: Apprentice/ Trainee
Qualification: Bachelor's/ Master’s Degree
Salary: 5 - 6 LPA (Expected)
Experience: Freshers
Location: Hyderabad; Chennai; Mumbai; Gurugram, India

📌Apply Now: https://jll.wd1.myworkdayjobs.com/en-US/jllcareers/job/Apprentice-India_REQ436933

https://jll.wd1.myworkdayjobs.com/en-US/jllcareers/job/Apprentice-India_REQ437532

https://jll.wd1.myworkdayjobs.com/en-US/jllcareers/job/Apprentice-India_REQ437526

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

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

All the best! 👍👍

Accenture hiring Business Advisory New Associate

Experience: 0-2 years

Apply link: https://www.accenture.com/in-en/careers/jobdetails?id=AIOC-S01587171_en

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

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

All the best! 👍👍

PwC is hiring!
Position: Data Analytics - Associate
Qualifications: Bachelor’s/ Master's/ MBA
Salary: 6 - 12 (Expected)
Experience: Freshers/ Experienced
Location: Bangalore; Hyderabad; Mumbai; Kolkata, India

📌Apply Now: https://jobs-ta.pwc.com/global/en/job/632753WD/Cyber-R-R-ER-CS-Data-Analytics-Associate-HYD-BLR-KOL-MUM

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

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

All the best! 👍👍

𝐆𝐄 𝐇𝐞𝐚𝐥𝐭𝐡𝐂𝐚𝐫𝐞 - 𝐈𝐧𝐭𝐞𝐫𝐧𝐬𝐡𝐢𝐩!
Position: Intern
Qualifications: Bachelor’s/ Master’s Degree
Batch: 2024/ 2025/ 2026/ 2027
Salary: 5.5 LPA (Expected)
Experience: Freshers
Location: Bengaluru, India

📌Apply Now: https://careers.gehealthcare.com/global/en/job/R4025656/Interns

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

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

All the best! 👍👍

ShareChat is hiring Data Analyst 🚀

Experience : 1 Year
Location : Remote ( India )

Apply link : https://sharechat.mynexthire.com/employer/jobs?p=eyJwYWdlVHlwZSI6ImpkIiwiY3ZTb3VyY2UiOiJsaW5rZWRpbiIsInJlcUlkIjoyMDc5LCJyZXF1ZXN0ZXIiOnsiaWQiOiIiLCJjb2RlIjoiIiwibmFtZSI6IiJ9LCJwYWdlIjoiY2FyZWVycyIsImJ1ZmlsdGVyIjotMX0

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

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

All the best! 👍👍

American Express is hiring!
Position: Financial Analyst
Qualification: Bachelor's/ Master’s Degree
Salary: 5 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: India (Hybrid)

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

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

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

All the best! 👍👍

American Express is hiring Analyst 🚀

Qualification : Post Graduation
Experience : 0-2 Years
Location : Bangalore / Gurugram

Apply link : https://aexp.eightfold.ai/careers/job/29724854?hl=en&utm_source=linkedin&domain=aexp.com

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

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

All the best! 👍👍

Yoga Bar is hiring Business Analyst Intern 🚀

Experience : Freshers
Skills : Excel , SQL & Python
Location : Bangalore

Apply link : https://yogabars.freshteam.com/jobs/JZmPmcACLPGI/business-analyst-intern?ft_source=5000058466&ft_medium=5000061141

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

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

All the best! 👍👍

NTT DATA is hiring!
Position: Senior PowerBI Developer
Qualifications: Bachelor’s/ Master’s degree
Salary: 5 - 13 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://nttdata.eightfold.ai/careers/job/563327923580371?domain=nttdata.com&hl=en

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

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

All the best! 👍👍

ShareChat - Work From Home!
Position: Data Analyst
Qualifications: Bachelor’s Degree
Salary: 6.5 - 22 LPA (Expected)
Experience: Freshers/ Experienced
Location: India (Hybrid)

📌Apply Now: https://sharechat.mynexthire.com/employer/jobs?src=careers&p=eyJwYWdlVHlwZSI6ImpkIiwiY3ZTb3VyY2UiOiJjYXJlZXJzIiwicmVxSWQiOjIwNzksInJlcXVlc3RlciI6eyJpZCI6IiIsImNvZGUiOiIiLCJuYW1lIjoiIn0sInBhZ2UiOiJjYXJlZXJzIiwiYnVmaWx0ZXIiOi0xLCJjdXN0b21GaWVsZHMiOnt9fQ

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

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

All the best! 👍👍

𝐄𝐘 𝐎𝐟𝐟 𝐂𝐚𝐦𝐩𝐮𝐬 𝐑𝐞𝐜𝐫𝐮𝐢𝐭𝐦𝐞𝐧𝐭 𝐃𝐫𝐢𝐯𝐞!
Position: Associate Analyst
Qualification: Bachelor’s/ Master's Degree
Salary: 4.6 - 8 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bengaluru; New Delhi, India

📌Apply Link: https://careers.ey.com/ey/job/New-Delhi-Associate-Analyst-Tax-National-TAX-PAS-Mobility-Core-New-Delhi-Nati-110037/1213573801

https://careers.ey.com/ey/job/Bengaluru-Associate-Analyst-Tax-National-TAX-PAS-Mobility-Core-Bangalore-KA-560001/1213190601

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

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

All the best! 👍👍

American Express is hiring!
Position: Analyst - Data Science
Qualifications: Graduate / Post Graduate
Salary: 7 - 10 LPA (Expected)
Experience: Freshers (0 to 2 Years)
Location: Bengaluru; Gurgaon, India (Hybrid)

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

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

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

All the best! 👍👍

𝐒𝐰𝐢𝐠𝐠𝐲 - 𝐖𝐨𝐫𝐤 𝐅𝐫𝐨𝐦 𝐇𝐨𝐦𝐞!
Position: Business Analyst
Qualifications: Bachelor’s degree
Salary: 6 - 14.1 LPA (Expected)
Experience: Freshers/ Experienced
Location: Work From Home (Remote)

📌Apply Now: https://www.linkedin.com/jobs/view/4255540217

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

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

All the best! 👍👍

Lead India hiring Data Analytics Intern

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

Stipend: Rs 25K/ month

KPMG is hiring!
Position: Associate
Qualification: BE/B.Tech, B.Com, BCA, B.Sc, MBA, M.Sc, MCA, M.Tech, CA
Salary: 6 - 9 LPA (Expected)
Experience: 1 - 4 (Years)
Location: Bangalore; Hyderabad; Kochi, India

📌Apply Now: https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_3/job/30028590?keyword=Associate+2+GTA&mode=location

https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_3/job/30028588?keyword=Associate+2+GTA&mode=location

https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_3/job/30028589?keyword=Associate+2+GTA&mode=location

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

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

All the best! 👍👍

IBM is hiring!
Position: Data Engineer, Data & Analytics
Qualifications: Bachelor’s/ Master’s Degree
Salary: 6.8 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: Pune, India

📌Apply Now: https://ibmglobal.avature.net/en_US/careers/JobDetail?jobId=32574&source=WEB_Search_INDIA

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

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

All the best! 👍👍