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 ❤️

Citi is hiring!
Position: Business Analytics Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Freshers (0 - 2 Years)
Location: Bengaluru, India (Hybrid)

📌Apply Now: https://jobs.citi.com/job/-/-/287/77226939200

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

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

Like for more ❤️

𝐒𝐢𝐞𝐦𝐞𝐧𝐬 𝐈𝐧𝐭𝐞𝐫𝐧𝐬𝐡𝐢𝐩, 𝟐𝟎𝟐𝟓!
Position: Business Development Intern
Qualifications: Bachelor’s/ Master’s Degree
Salary: 29K - 40K Per Month (Expected)
Experience: Freshers
Location: Bangalore/ Mumbai

📌Apply Now: https://jobs.siemens.com/careers/job/563156123383825

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

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

Like for more ❤️

Purplle.com is hiring Business Analyst

Min.Experience : 1 Year
Location : Mumbai

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

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

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

Like for more ❤️

Jaipur Rugs is hiring Data Analyst 🚀

Qualification : Bachelor's degree
Experience : Freshers / Experienced
Location : Jaipur

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

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

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

Like for more ❤️

Apna is hiring BI Analyst 🚀

Experience : 1 Year
Location : Bangalore

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

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

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

Like for more ❤️

Almost everyone knows that these are the tools a Data Analyst works with:

➡️ SQL
➡️ Excel
➡️ Power BI/Tableau
➡️ Python

But people getting started with analytics are confused about the preferences of picking these tools.

There are various kinds of data analytics roles available in the market :

➡️ BI + SQL: Will primarily be involved in BI development.

➡️ SQL + Excel: Will primarily work on Excel reporting.

➡️ SQL + Python: Will primarily do data analysis using python.

Now, If you are getting started with learning analytics, choose any one role that interests you the most and focus on completing the primary tools that the role requires. Learn them VERY WELL.

Learn any of the above combinations that interests you first and then start looking out for opportunities which ask for these primary tools and simultaneously start learning the basics of the 3rd tool.

You don't have to focus on being good with each and every tool but being good with any of the above combinations always works.

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

Hope this helps you 😊

LSEG is hiring!
Position: Business Analyst
Qualification: Bachelor’s/ Master’s/ MBA
Salary: 5 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India (Hybrid)

📌Apply Link: https://lseg.wd3.myworkdayjobs.com/en-US/Careers/job/Business-Analyst_R0100083-1

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

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

Like for more ❤️

Data Analysis is not just SQL.
Data Analysis is not just PowerBI/Tableau.
Data Analysis is not just Python.
Data Analysis is not just Excel.


𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐢𝐬 𝐚𝐛𝐨𝐮𝐭:

✅𝐈𝐧𝐬𝐢𝐠𝐡𝐭 𝐃𝐢𝐬𝐜𝐨𝐯𝐞𝐫𝐲: It's about uncovering the stories hidden within the data.

✅𝐃𝐞𝐜𝐢𝐬𝐢𝐨𝐧 𝐌𝐚𝐤𝐢𝐧𝐠: It's about informing business decisions with data-driven insights.

✅ 𝐓𝐫𝐞𝐧𝐝 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬: It's about identifying trends and patterns to forecast future outcomes.

✅ 𝐏𝐫𝐨𝐛𝐥𝐞𝐦-𝐒𝐨𝐥𝐯𝐢𝐧𝐠: It's about addressing business challenges with data-backed solutions.

✅ 𝐂𝐫𝐢𝐭𝐢𝐜𝐚𝐥 𝐓𝐡𝐢𝐧𝐤𝐢𝐧𝐠: It's about evaluating data with an analytical mindset to ensure accurate and reliable conclusions.

✅ 𝐂𝐨𝐧𝐭𝐢𝐧𝐮𝐨𝐮𝐬 𝐈𝐦𝐩𝐫𝐨𝐯𝐞𝐦𝐞𝐧𝐭: It's about iterating and refining processes for better outcomes.

Tools like Power BI, Tableau, Excel, and Python are just that—tools. The real value lies in how we use them to transform data into actionable insights.

Thomson Reuters is hiring!
Position: Data Engineer
Qualifications: Bachelor’s/ Master’s Degree
Salary: 8 - 16 LPA (Expected)
Location: Hyderabad; Bengaluru, India (Hybrid)

📌Apply Now: https://careers.thomsonreuters.com/us/en/job/JREQ184693/Data-Engineer

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

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

Like for more ❤️

Appinventiv is hiring Business Analyst 🚀

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

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

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

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

Like for more ❤️

Frido is hiring Data Analyst Intern 🚀

Qualification : Bachelor's degree
Experience : Freshers / Experienced
Location : Pune

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

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

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

Like for more ❤️

Few ways to increase the chances of getting job interview using LinkedIn

1. Apply for a high volume of jobs (30-40) daily to increase your chances of getting noticed.

2. Don't just use "easy apply"; apply for other types of job postings as well.

3. Apply as soon as a job is posted by turning on job alerts for immediate notifications.

4. For dream companies, immediately seek referrals. Connect with many employees in similar roles and ask for referrals. Approach multiple people since few will respond and even fewer will refer.

5. When asking for referrals, don't start with "Hi" or "Hello." Directly send a message with the job posting link or job ID and attach your CV. Follow up after one day if needed. Repeat with multiple people until you get a referral confirmation.

6. Apply only for jobs where you meet the requirements in terms of experience and skills.

7. Build a strong LinkedIn profile: have over 500 connections, update your latest experiences, relevant projects, education, use a professional photo, and list relevant skills in your bio.

8. If the job poster's or recruiter's ID is in the job posting, connect with them immediately after applying and send your CV with a message.

9. Keep your account visible to people in your field by sending connection requests to relevant people and sharing your learnings on LinkedIn to boost visibility.

10. Personalize your connection requests to explain why you want to connect, increasing the chances of acceptance.

11. Engage with posts from connections and industry leaders by liking, commenting, and sharing to stay visible and build your network.

12. Publish articles or posts about your expertise to demonstrate knowledge and attract employers.

13. Join and participate in LinkedIn groups related to your industry to expand your network and visibility.

14. Ensure your headline and summary reflect your current role, skills, and career aspirations with relevant keywords.

15. Request recommendations from colleagues, managers, and clients to strengthen your profile.

16. Follow companies you're interested in to stay updated on job postings and company news.

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

Hope this helps you 😊