American Express is hiring Business Analyst 🚀

Experience : 0-2 Years
Location : Gurugram

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

PhonePE is hiring Business Analyst 🚀

Min. Experience : 2 Years
Location : Bangalore

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

Data Engineer at Coditas! 🚀
Coditas is looking for a skilled Data Engineers to join our dynamic team!
🔍 What You’ll Bring:
✅ Expertise in AWS or Azure
✅ Strong skills in Python, PySpark & SQL
✅ Experience in building scalable data pipelines & ETL processes

Experience- 3- 5 Years
Location- Pune(Hybrid)

🌟 Why Join Us?
🌐 Work with cutting-edge tech
📈 Drive impactful data solutions
💼 Competitive benefits

📩 Apply by sharing your resume at pooja.salunkhe@coditas.com

𝐏𝐰𝐂
Position: Intern/Trainee, Data, Analytics & AI
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers
Location: Gurugram; Mumbai, India

📌Apply Link: https://pwc.wd3.myworkdayjobs.com/en-US/Global_Experienced_Careers/job/IN-Intern-Trainee_672539WD-1

https://pwc.wd3.myworkdayjobs.com/en-US/Global_Experienced_Careers/job/IN-Intern-Trainee_672423WD-1

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

NatWest Group is hiring
Position: Data & Analytics Analyst
Qualification: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Bangalore, India (Hybrid)

📌Apply Now: https://jobs.natwestgroup.com/jobs/16889682-data-and-analytics-analyst-da

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Ericsson is hiring
Position: Data Scientist
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://jobs.ericsson.com/careers/job/563121772501040?domain=ericsson.com&hl=en

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Redbus is hiring Product Analyst

For 2021, 2022, 2023 grads
Location: Bangalore

https://www.linkedin.com/jobs/view/4311872177/

Precision is hiring Data Analyst

For 2021, 2022, 2023, 2024 grads
Location: India

https://www.linkedin.com/jobs/view/4311348540/

Have you joined the Whatsapp Channel yet? 😍 Get quick updates :)

https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

Schbang is hiring Junior Business Analyst 🚀

Min. Experience : 1 Year
Location : Mumbai

Apply link : Check out this job at Schbang: https://www.linkedin.com/jobs/view/4311069997

Baker Hughes
Position: Data Engineer
Qualifications: Bachelor’s/ Master’s Degree
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://careers.bakerhughes.com/global/en/job/R156584/Data-Engineer

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

𝐑𝐞𝐯𝐨𝐥𝐮𝐭
Position: Business Analyst
Qualification: Bachelor's/ Master's Degree
Experience: Freshers/ Experienced
Location: Remote

📌Apply Now: https://www.revolut.com/en-IN/careers/position/business-analyst-regulatory-reporting-functional-64014764-d73b-4606-b38c-b24e6a9115fa/

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Lenskart is hiring Data Analyst 🚀

Experience : 2 Year
Location : Gurgaon

Apply link : https://app.turbohire.co/job/publicjobs/JVGSVBtxFHOaeyDTK9qJsNL48piY89taXSliqlMPlO0AUiNJWK8ZhJmanArnVnFX?so=li

Wells Fargo is hiring
Position: Data Management Analyst, Data & Analytics
Qualifications: Bachelor’s/ Master’s Degree
Experience: Experienced
Location: Hyderabad, India

📌Apply Now: https://www.wellsfargojobs.com/en/jobs/r-476410/data-management-analyst/

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Thermo Fisher Scientific
Position: Associate Business Systems Analyst II
Qualifications: Bachelor’s Degree
Experience: Freshers (0 - 2 Years)
Location: Bangalore, India (Hybrid)

📌Apply Now: https://jobs.thermofisher.com/global/en/job/R-01328986/Assoc-Business-Systems-Analyst-II

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Apna is hiring Product Analyst 🚀

Min. Experience : 1 Year
Location : Bangalore

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

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Capgemini
Position: Finance Analyst/ Lead/ Manager
Qualification: Bachelor’s/ Master’s/ MBA
Experience: Freshers/ Experienced
Location: Bangalore; India

📌Apply Now: https://www.capgemini.com/in-en/jobs/237591-en_GB+sap_btp

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

United Airlines is hiring Associate Analyst 🚀

Experience : 0-1 Year
Location : Gurugram

Apply link : https://careers.united.com/us/en/job/UAIUADUSGGN00002218EXTERNALENUSTALEO/Associate-Analyst-Operations-Performance-Analytics?utm_source=linkedin&utm_medium=phenom-feeds

All the best 👍👍

S&P Global
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 5 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Hyderabad; Ahmedabad, India

📌Apply Now: https://careers.spglobal.com/jobs/316925

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

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

🧠 Real-World SQL Practice Questions with Solutions

1. Find duplicate email addresses in the Users table

SELECT email, COUNT(*) AS count  
FROM Users  
GROUP BY email  
HAVING COUNT(*) > 1;

2. Retrieve the highest-paid employee per department

SELECT *  
FROM Employees e  
WHERE salary = (  
  SELECT MAX(salary)  
  FROM Employees  
  WHERE department_id = e.department_id  
);

3. Count the number of orders each customer placed

SELECT c.name, COUNT(o.id) AS total_orders  
FROM Customers c  
LEFT JOIN Orders o ON c.id = o.customer_id  
GROUP BY c.name;

4. Find products never sold

SELECT p.name  
FROM Products p  
LEFT JOIN Sales s ON p.id = s.product_id  
WHERE s.product_id IS NULL;

5. Get the most recent 5 orders

SELECT * FROM Orders  
ORDER BY order_date DESC  
LIMIT 5;

6. Find employees earning above average salary

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

7. Get monthly sales totals

SELECT  
  DATE_FORMAT(sale_date, '%Y-%m') AS month,  
  SUM(amount) AS total  
FROM Sales  
GROUP BY month;

8. Show customers who ordered ‘Laptop’ more than once

SELECT customer_id, COUNT(*) AS count  
FROM Orders  
WHERE product = 'Laptop'  
GROUP BY customer_id  
HAVING COUNT(*) > 1;

💬 Tap ❤️ if this helped you!