KPMG is hiring Data Analyst ๐
Experience : 1 Year
Location : Gurgaon
Apply link : https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/job/INTG10026369/?utm_medium=jobshare
Experience : 1 Year
Location : Gurgaon
Apply link : https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/job/INTG10026369/?utm_medium=jobshare
KPMG India
Analyst - Data Analytics
About KPMG in India KPMG entities in India are professional services firm(s). These Indian member firms are affiliated with KPMG International Limited. KPMG was established in India in August 1993. Our professionals leverage the global network of firms, andโฆ
โค4๐1
๐๐จ๐ ๐ง๐ข๐ณ๐๐ง๐ญ - ๐๐จ๐ซ๐ค ๐๐ซ๐จ๐ฆ ๐๐จ๐ฆ๐ (๐๐ฒ๐๐ซ๐ข๐)
Position: Trainee - Junior Data Analyst
Qualification: Bachelorโs/ Masterโs Degree
Salary: 4.8 - 7.3 LPA (Expected)
Experienc๏ปฟe: Freshers (0 - 3 Years)
Location: Work From Home/ Office
๐Apply Now: https://careers.cognizant.com/india-en/jobs/00061975521/trainee-junior-data-analyst/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Position: Trainee - Junior Data Analyst
Qualification: Bachelorโs/ Masterโs Degree
Salary: 4.8 - 7.3 LPA (Expected)
Experienc๏ปฟe: Freshers (0 - 3 Years)
Location: Work From Home/ Office
๐Apply Now: https://careers.cognizant.com/india-en/jobs/00061975521/trainee-junior-data-analyst/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐4โค1
Capgemini is hiring!
Position: PL/SQL Developer
Qualification: Bachelorโs/ Masterโs Degree
Salary: 4 - 9 LPA (Expected)
Experienc๏ปฟe: Freshers/ Experienced
Location: Bangalore, India
๐Apply Link: https://www.capgemini.com/in-en/jobs/86636-en_GB+sap_btp/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Position: PL/SQL Developer
Qualification: Bachelorโs/ Masterโs Degree
Salary: 4 - 9 LPA (Expected)
Experienc๏ปฟe: Freshers/ Experienced
Location: Bangalore, India
๐Apply Link: https://www.capgemini.com/in-en/jobs/86636-en_GB+sap_btp/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐1
๐ Planning to study abroad in 2025?
Join this free webinar session to get a complete roadmapโapplications, scholarships, and more!
Interested?
Register now!๐๐
https://gfgcdn.com/tu/U8n/
Join this free webinar session to get a complete roadmapโapplications, scholarships, and more!
Interested?
Register now!๐๐
https://gfgcdn.com/tu/U8n/
www.geeksforgeeks.org
Practice | GeeksforGeeks | A computer science portal for geeks
Platform to practice programming problems. Solve company interview questions and improve your coding intellect
๐2โค1
๐๐ ๐๐๐ซ๐จ๐ฌ๐ฉ๐๐๐ ๐๐ง๐ญ๐๐ซ๐ง๐ฌ๐ก๐ข๐ฉ, ๐๐๐๐!
Positio: Analytics - Intern
Qualification: Bachelorโs/ Masterโs Degree
Salary: โน 30,000 - โน 50,000 Per Month (Expected)
Batch: 2024/ 2025/ 2026/ 2027
Experienc: Freshers
Locatio: Bengaluru, India
๐Apply Now: https://careers.geaerospace.com/global/en/job/R5002156/Analytics-Intern
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Positio: Analytics - Intern
Qualification: Bachelorโs/ Masterโs Degree
Salary: โน 30,000 - โน 50,000 Per Month (Expected)
Batch: 2024/ 2025/ 2026/ 2027
Experienc: Freshers
Locatio: Bengaluru, India
๐Apply Now: https://careers.geaerospace.com/global/en/job/R5002156/Analytics-Intern
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐2
JLL is hiring Research Analyst ๐
Qualification : Bachelor's degree
Freshers are eligible โ
Location : Gurugram
Apply link : https://jll.wd1.myworkdayjobs.com/jllcareers/job/Gurugram-HR/Analyst---Research_REQ396454
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Qualification : Bachelor's degree
Freshers are eligible โ
Location : Gurugram
Apply link : https://jll.wd1.myworkdayjobs.com/jllcareers/job/Gurugram-HR/Analyst---Research_REQ396454
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐5
Strive Health is hiring Data Analyst ๐
Qualification : Bachelor's degree
Freshers are eligible โ
Location : Remote ( USA )
Apply link : https://www.linkedin.com/jobs/view/4142392676
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Qualification : Bachelor's degree
Freshers are eligible โ
Location : Remote ( USA )
Apply link : https://www.linkedin.com/jobs/view/4142392676
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐6โค1
Want to become a Data Analyst?
Hereโs a roadmap with essential skills, tools & concepts youโll need to master:
1. Data Fundamentals
Statistics: Learn descriptive statistics (mean, median, mode), distributions, hypothesis testing, and correlation.
Probability: Understand basic probability theory, including conditional probability, Bayesโ theorem, and probability distributions.
2. Data Cleaning
Data Cleaning Techniques: Handling missing values, removing duplicates, and outlier detection.
Data Transformation: Data type conversions, feature engineering, and handling categorical variables.
Pandas: Master data manipulation with Pandas (merge, join, group, pivot).
3. Data Visualization
Data Visualization Libraries: Master Matplotlib, Seaborn, or Plotly for Python-based visualizations.
Power BI / Tableau: Get hands-on with BI tools to create interactive dashboards and visual reports.
Design Principles: Learn best practices for designing clear, effective visualizations.
4. SQL for Data Analysis
Basic SQL: SELECT, WHERE, ORDER BY, GROUP BY, JOINs.
Advanced SQL: Window functions, Common Table Expressions (CTEs), subqueries.
Aggregation Functions: SUM, AVG, MIN, MAX, COUNT.
Data Cleaning with SQL: Filtering, transforming, and merging data in SQL databases.
5. Excel for Data Analysis
Data Cleaning in Excel: Use functions like TRIM, CLEAN, SUBSTITUTE.
Advanced Functions: VLOOKUP, HLOOKUP, INDEX-MATCH, IF, SUMIF, COUNTIF.
Data Visualization in Excel: Create pivot tables, charts, and dashboards.
6. Programming for Data Analysis (Python or R)
Python: Learn data handling and manipulation with Pandas and NumPy.
R: Basic syntax, data manipulation with dplyr, and data visualization with ggplot2.
Data Analysis Libraries: Pandas, NumPy, SciPy for Python or Tidyverse for R.
7. Exploratory Data Analysis (EDA)
Pattern Recognition: Use EDA to identify patterns, trends, and correlations in data.
Visual EDA: Use pair plots, heatmaps, and distribution plots for insights.
Summary Statistics: Understand distributions, variance, and central tendencies of variables.
8. Business Acumen
Domain Knowledge: Understand the industry-specific metrics relevant to your target job (e.g., finance, marketing, e-commerce).
Data Storytelling: Learn to communicate findings clearly and effectively, connecting insights to business goals.
KPI Analysis: Identify and measure key performance indicators for informed decision-making.
9. Data Collection & Sourcing
APIs: Learn to pull data from APIs (e.g., REST APIs) using tools like Pythonโs Requests library.
Web Scraping: Use tools like BeautifulSoup and Scrapy (be mindful of ethics and legality).
Database Connections: Query databases and integrate SQL with Python or R for more extensive analyses.
10. Dashboarding and Reporting
Power BI / Tableau: Master the basics of dashboard design, interactivity, and sharing insights with stakeholders.
Reporting Best Practices: Design reports that are clear, actionable, and easy for non-technical stakeholders to interpret.
11. Soft Skills
Communication: Clearly present data insights and recommendations to stakeholders.
Critical Thinking: Approach problems analytically to uncover insights.
Collaboration: Learn how to work effectively within cross-functional teams, especially with non-technical colleagues.
Top-notch Data Analytics Resources
How to become a Data Analyst in 2025
Free Resources to learn Data Analytics
Data Analyst Learning Plan
Join @free4unow_backup for more free courses
Like for more data analytics resources โค๏ธ
ENJOY LEARNING๐๐
Hereโs a roadmap with essential skills, tools & concepts youโll need to master:
1. Data Fundamentals
Statistics: Learn descriptive statistics (mean, median, mode), distributions, hypothesis testing, and correlation.
Probability: Understand basic probability theory, including conditional probability, Bayesโ theorem, and probability distributions.
2. Data Cleaning
Data Cleaning Techniques: Handling missing values, removing duplicates, and outlier detection.
Data Transformation: Data type conversions, feature engineering, and handling categorical variables.
Pandas: Master data manipulation with Pandas (merge, join, group, pivot).
3. Data Visualization
Data Visualization Libraries: Master Matplotlib, Seaborn, or Plotly for Python-based visualizations.
Power BI / Tableau: Get hands-on with BI tools to create interactive dashboards and visual reports.
Design Principles: Learn best practices for designing clear, effective visualizations.
4. SQL for Data Analysis
Basic SQL: SELECT, WHERE, ORDER BY, GROUP BY, JOINs.
Advanced SQL: Window functions, Common Table Expressions (CTEs), subqueries.
Aggregation Functions: SUM, AVG, MIN, MAX, COUNT.
Data Cleaning with SQL: Filtering, transforming, and merging data in SQL databases.
5. Excel for Data Analysis
Data Cleaning in Excel: Use functions like TRIM, CLEAN, SUBSTITUTE.
Advanced Functions: VLOOKUP, HLOOKUP, INDEX-MATCH, IF, SUMIF, COUNTIF.
Data Visualization in Excel: Create pivot tables, charts, and dashboards.
6. Programming for Data Analysis (Python or R)
Python: Learn data handling and manipulation with Pandas and NumPy.
R: Basic syntax, data manipulation with dplyr, and data visualization with ggplot2.
Data Analysis Libraries: Pandas, NumPy, SciPy for Python or Tidyverse for R.
7. Exploratory Data Analysis (EDA)
Pattern Recognition: Use EDA to identify patterns, trends, and correlations in data.
Visual EDA: Use pair plots, heatmaps, and distribution plots for insights.
Summary Statistics: Understand distributions, variance, and central tendencies of variables.
8. Business Acumen
Domain Knowledge: Understand the industry-specific metrics relevant to your target job (e.g., finance, marketing, e-commerce).
Data Storytelling: Learn to communicate findings clearly and effectively, connecting insights to business goals.
KPI Analysis: Identify and measure key performance indicators for informed decision-making.
9. Data Collection & Sourcing
APIs: Learn to pull data from APIs (e.g., REST APIs) using tools like Pythonโs Requests library.
Web Scraping: Use tools like BeautifulSoup and Scrapy (be mindful of ethics and legality).
Database Connections: Query databases and integrate SQL with Python or R for more extensive analyses.
10. Dashboarding and Reporting
Power BI / Tableau: Master the basics of dashboard design, interactivity, and sharing insights with stakeholders.
Reporting Best Practices: Design reports that are clear, actionable, and easy for non-technical stakeholders to interpret.
11. Soft Skills
Communication: Clearly present data insights and recommendations to stakeholders.
Critical Thinking: Approach problems analytically to uncover insights.
Collaboration: Learn how to work effectively within cross-functional teams, especially with non-technical colleagues.
Top-notch Data Analytics Resources
How to become a Data Analyst in 2025
Free Resources to learn Data Analytics
Data Analyst Learning Plan
Join @free4unow_backup for more free courses
Like for more data analytics resources โค๏ธ
ENJOY LEARNING๐๐
๐15โค3
KPMG is hiring!
Position: Analyst- Data Analytics
Qualification: Bachelorโs/ Master's Degree
Salary: 5 - 9 LPA (Expected)
Location: Gurgaon, India
๐Apply Now: https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/INTG10026369?utm_medium=jobshare
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Position: Analyst- Data Analytics
Qualification: Bachelorโs/ Master's Degree
Salary: 5 - 9 LPA (Expected)
Location: Gurgaon, India
๐Apply Now: https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/INTG10026369?utm_medium=jobshare
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐6
WIPRO is Hiring for DATA ANALYST
Role:- DATA ANALYST
Experience:- Fresher's and Experienced
Apply Now:- 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 โค๏ธ
Role:- DATA ANALYST
Experience:- Fresher's and Experienced
Apply Now:- 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 โค๏ธ
โค1๐1
United Airlines Internship, 2025!
Position: Data Science Intern
Qualifications: Bachelor's degree
Salary: 30,000 Per Month (Expected)
Batch: 2023/ 2024/ 2025/ 2026
Experience: Freshers
Location: Gurugram, India
๐Apply Now: https://careers.united.com/us/en/job/GGN00001860/Data-Science-Intern
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Position: Data Science Intern
Qualifications: Bachelor's degree
Salary: 30,000 Per Month (Expected)
Batch: 2023/ 2024/ 2025/ 2026
Experience: Freshers
Location: Gurugram, India
๐Apply Now: https://careers.united.com/us/en/job/GGN00001860/Data-Science-Intern
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐2
๐๐๐ฏ๐จ๐ฅ๐ฎ๐ญ - ๐๐จ๐ซ๐ค ๐
๐ซ๐จ๐ฆ ๐๐จ๐ฆ๐
Position: Data Scientist
Qualifications: Bachelor's/ Master's/ PhD Degree
Salary: 7 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Work From Home (Remote)
๐Apply Now: https://www.revolut.com/careers/position/5bfed8c7-9f9d-48e2-8e28-7ecf00ac17a8/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Position: Data Scientist
Qualifications: Bachelor's/ Master's/ PhD Degree
Salary: 7 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Work From Home (Remote)
๐Apply Now: https://www.revolut.com/careers/position/5bfed8c7-9f9d-48e2-8e28-7ecf00ac17a8/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
โค3๐2
Company Name: Pinkerton
Role: Data Analyst
Qualification: Any Graduate
Experience: Freshers
Salary: Upto 5 LPA
Apply Link - https://pinkerton.com/job/PINKERTONR5471/data-analyst
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Role: Data Analyst
Qualification: Any Graduate
Experience: Freshers
Salary: Upto 5 LPA
Apply Link - https://pinkerton.com/job/PINKERTONR5471/data-analyst
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
โค2
SPORTSKEEDA is Hiring for DATA ANALYST
Role:- DATA ANALYST
Experience:- Fresher's and Experienced
Apply Now:- https://sportskeeda.zohorecruit.in/jobs/Careers/59509000034512547/Data-Analyst?source=CareerSite
๐ Join the WhatsApp TV Group for more job updates and pass this information with your friends and groups ๐จ
Join Now:- https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J
Role:- DATA ANALYST
Experience:- Fresher's and Experienced
Apply Now:- https://sportskeeda.zohorecruit.in/jobs/Careers/59509000034512547/Data-Analyst?source=CareerSite
๐ Join the WhatsApp TV Group for more job updates and pass this information with your friends and groups ๐จ
Join Now:- https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J
๐3
Wells Fargo is hiring!
Position: Business Execution Associate/ Data Analysis, Power BI
Qualifications: Bachelorโs/ Masterโs Degree
Salary: 6 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India
๐Apply Link: https://www.wellsfargojobs.com/en/jobs/r-407415/business-execution-associate-data-analysis-power-bi/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Position: Business Execution Associate/ Data Analysis, Power BI
Qualifications: Bachelorโs/ Masterโs Degree
Salary: 6 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India
๐Apply Link: https://www.wellsfargojobs.com/en/jobs/r-407415/business-execution-associate-data-analysis-power-bi/
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
โค3๐1
KPMG hiring for - Data Analytics
Apply Link: https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/INTG10026369
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Apply Link: https://ejgk.fa.em2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1/job/INTG10026369
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐1
Analog Devices Internship, 2025!
Position: Data Analyst/ Data Scientist - Intern
Qualification: Bachelor's/ Masterโs degree
Salary: 30K - 40K Per Month (Expected)
Experience: Freshers
Location: Bangalore, India
๐Apply Now: https://analogdevices.wd1.myworkdayjobs.com/External/job/India-Bangalore-Mantri/Data-Analyst-Data-Scientist---Intern_R243836
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Position: Data Analyst/ Data Scientist - Intern
Qualification: Bachelor's/ Masterโs degree
Salary: 30K - 40K Per Month (Expected)
Experience: Freshers
Location: Bangalore, India
๐Apply Now: https://analogdevices.wd1.myworkdayjobs.com/External/job/India-Bangalore-Mantri/Data-Analyst-Data-Scientist---Intern_R243836
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐1
Jefferies is hiring Business Data Analyst ๐
Qualification : Any Graduate
Experience : 0-3 Years
Location : Mumbai
Apply link : https://careers.jefferies.com/#en/job/2290/?utm_medium=jobshare
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
Qualification : Any Graduate
Experience : 0-3 Years
Location : Mumbai
Apply link : https://careers.jefferies.com/#en/job/2290/?utm_medium=jobshare
๐WhatsApp Channel: https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226
๐Telegram Link: https://t.me/addlist/4q2PYC0pH_VjZDk5
Like for more โค๏ธ
๐2
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 โค๏ธ
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 โค๏ธ
๐2
๐๐ป๐๐ฒ๐ฟ๐๐ถ๐ฒ๐๐ฒ๐ฟ: You have 2 minutes to solve this SQL query.
Retrieve the department name and the highest salary in each department from the
๐ ๐ฒ: Challenge accepted!
SELECT department, MAX(salary) AS highest_salary
FROM employees
GROUP BY department
HAVING MAX(salary) > 70000;
I used
๐ง๐ถ๐ฝ ๐ณ๐ผ๐ฟ ๐ฆ๐ค๐ ๐๐ผ๐ฏ ๐ฆ๐ฒ๐ฒ๐ธ๐ฒ๐ฟ๐:
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 :)
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 :)
๐60โค5
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 โค๏ธ
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 โค๏ธ
โค4๐4