Teikametrics is hiring Product Analyst 🚀

Experience : 2 Years
Location : Remote

Apply link : https://jobs.lever.co/teikametrics/082aa946-14f2-4a43-bc76-3989988ccc09/apply?source=LinkedIn

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

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

Like for more ❤️

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: You have 2 minutes to solve this SQL query.
Retrieve the department name and the highest salary in each department from the employees table, but only for departments where the highest salary is greater than $70,000.

𝗠𝗲: Challenge accepted!

SELECT department, MAX(salary) AS highest_salary
FROM employees
GROUP BY department
HAVING MAX(salary) > 70000;

I used GROUP BY to group employees by department, MAX() to get the highest salary, and HAVING to filter the result based on the condition that the highest salary exceeds $70,000. This solution effectively shows my understanding of aggregation functions and how to apply conditions on the result of those aggregations.

𝗧𝗶𝗽 𝗳𝗼𝗿 𝗦𝗤𝗟 𝗝𝗼𝗯 𝗦𝗲𝗲𝗸𝗲𝗿𝘀:
It's not about writing complex queries; it's about writing clean, efficient, and scalable code. Focus on mastering subqueries, joins, and aggregation functions to stand out!

Like this post if you need more 👍❤️

Hope it helps :)

HSBC is hiring!
Position: Associate Business Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 7 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India (Hybrid)

📌Apply Now: https://mycareer.hsbc.com/en_GB/external/PipelineDetail/Associate-Business-Analyst/254863?src=JB-257546

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

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

Like for more ❤️

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

📌Apply Link: https://careers.unitedhealthgroup.com/job/21554559/data-analyst-hyderabad-in/

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

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

Like for more ❤️

L&T Technology is hiring!
Position: Data Scientist
Qualification: Bachelor’s/ Master’s/ MBA
Salary: 6 - 14 LPA (Expected)
Experience: Freshers (0 - 1 Years)
Location: India

📌Apply Now: https://larsentoubrocareers.peoplestrong.com/job/detail/LNT_DS_1216153

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

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

Like for more ❤️

NORSTELLA is Hiring for DATA ENGINEER

Role:- DATA ENGINEER

Experience:- Fresher's and Experienced

Apply Now:- https://careers.norstella.com/jobs/15286767-data-engineer

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

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

Like for more ❤️

HSBC is Hiring for ASSOCIATE - BUSINESS ANALYST

Role: ASSOCIATE - BUSINESS ANALYST

Experience: Fresher's and Experienced

Apply Now: https://mycareer.hsbc.com/en_GB/external/PipelineDetail/Associate-Business-Analyst/254863?src=JB-257546

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

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

Like for more ❤️

𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐈𝐧𝐭𝐞𝐫𝐧𝐬𝐡𝐢𝐩 - 𝗪𝗼𝗿𝗸 𝗙𝗿𝗼𝗺 𝗛𝗼𝗺𝗲!
Company: 𝗔𝗯𝗵𝘆𝗮𝘇
Position: Data Analyst Intern
Qualifications: Any Graduate or Engineer
Salary: 25K - 40K Per Month (Expected)
Batch: 2022/ 2023/ 2024/ 2025
Experience: Freshers (0 - 1 Years)
Location: Work From Home (Remote)

📌Apply Link: https://mtabtechnology.zohorecruit.com/recruit/ViewJob.na?digest=5Jviu40PLY9qPOL6tvG%40kpqycUg55IdhHoMhlcOY6rM-&embedsource=LinkedIn%2BLimited%2BListings

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

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

Like for more ❤️

HP is hiring Financial Analyst!
Qualification: Bachelor's/ Master's Degree
Salary: 7.2 LPA (Expected)
Experience: Freshers (0 - 2 Years)
Location: Bangalore, India (Hybrid)

📌Apply Now: https://hp.wd5.myworkdayjobs.com/ExternalCareerSite/job/Bangalore-Karnataka-India/Financial-Analyst_3146606-1

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

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

Like for more ❤️

Cognizant is hiring!
Position: Programmer Analyst
Qualifications: BE/ B.Tech/ B.Sc/ BCA/ ME/ M.Tech/ MCA
Salary: 4.5 - 5 - LPA (Expected)
Experience: Freshers (0 - 2 Years)
Location: Hyderabad; Chennai, India (Hybrid)

📌Apply Now: https://careers.cognizant.com/india-en/jobs/00062428289/programmer-analyst/

https://careers.cognizant.com/india-en/jobs/00061709975/programmer-analyst/

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

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

Like for more ❤️

Wipro is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 5 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Hyderabad/ Bengaluru

📌Apply Now: https://careers.wipro.com/job/Bengaluru-Data-Analyst-L4-560035/1142026355/

https://careers.wipro.com/job/Hyderabad-Data-Analyst-500032/1140132855/

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

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

Like for more ❤️

Pay-U is Hiring for BUSINESS ANALYST

Role:- BUSINESS ANALYST

Experience:- Fresher's and Experienced

Apply Now:- https://jobs.eu.lever.co/payu/5f31bbc2-9a5e-4ab0-b132-ce770c256b7d

🚀 Join the WhatsApp TV Group for more job updates and pass this information with your friends and groups🚨

Join Now:- https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

Capgemini is hiring!
Position: Business Analyst
Qualifications: Bachelor’s/ Master’s Degree
Salary: 4.8 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

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

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

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

Like for more ❤️

Data Play is hiring Data Analyst Intern 🚀

Qualification : Recent Graduates
Experience : Freshers
Location : Remote

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

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

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

Like for more ❤️

Recent Interview Question for Data Analyst Role

Question 1) You have two tables:

Employee:-
Columns: EID (Employee ID), ESalary (Employee Salary)

empdetails:-
Columns: EID (Employee ID), EDOB (Employee Date of Birth)

Your task is to:
1) Identify all employees whose salary (ESalary) is an odd number?
2) Retrieve the date of birth (EDOB) for these employees from the empdetails table.

How would you write a SQL query to achieve this?

SELECT e.EID, ed.EDOB
FROM (
SELECT EID
FROM Employee
WHERE ESalary % 2 <> 0
) e
JOIN empdetails ed ON e.EID = ed.EID;

Explanation of the query :-

Filter Employees with Odd Salaries:

The subquery SELECT EID FROM Employee WHERE ESalary % 2 <> 0 filters out Employee IDs (EID) where the salary (ESalary) is an odd number. The modulo operator % checks if ESalary divided by 2 leaves a remainder (<>0).

Merge with empdetails:

The main query then takes the filtered Employee IDs from the subquery and performs a join with the empdetails table using the EID column. This retrieves the date of birth (EDOB) for these employees.

Join this channel to learn everything about Data Analytics 👇
https://t.me/sqlspecialist

Hope this helps you 😊

TCS is hiring!
Position: Power BI Developer
Qualification: Bachelor’s/ Master's Degree
Salary: 4 - 8 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bengaluru, India

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

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

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

Like for more ❤️

Barclays is hiring!
Position: Business Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 8 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Mumbai/ Pune/ (Hybrid)

📌Apply Now: https://search.jobs.barclays/job/pune/business-analyst/13015/75304821184

https://search.jobs.barclays/job/mumbai/business-analyst/13015/69816232512

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

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

Like for more ❤️

Capgemini is hiring!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 5 - 8 LPA (Expected)
Experience: Freshers/ Experienced
Location: Hyderabad, India

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

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

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

Like for more ❤️

Dentsu is hiring Research Analyst 🚀

Qualification : Any Graduate
Experience : 0-1 Year
Location : Mumbai / Delhi

Apply link : https://dentsuaegis.wd3.myworkdayjobs.com/DAN_GLOBAL/job/Mumbai/Research-Analyst_R1082970

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

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

Like for more ❤️

Cognizant is hiring!
Position: Associate - Projects
Qualification: Bachelor’s/ Master’s Degree
Salary: 5.2 - 8 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore; Chennai; Bhubaneswar, India (Hybrid)

📌Apply Now: https://careers.cognizant.com/india-en/jobs/00062489372/associate-projects/

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

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

Like for more ❤️

Company : Deloitte
Role : Associate Analyst
Eligible Batches : 2021, 2022, 2023, 2024 Graduates
Location : Hyderabad

Apply Link : https://usijobs.deloitte.com/careersUSI/JobDetail/USI-EH25-CMG-CoAE-Account-Services-Professional-DAS-Associate-Analyst/207434

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

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

Like for more ❤️