How to Get Data Analyst Fresher Jobs in Delhi NCR, Bangalore & Pune (Salary: ₹3.5L - ₹7.0L)
Data Analyst is currently one of the fastest-growing entry-level roles in India. With companies in fintech, e-commerce, healthcare, and SaaS generating massive volumes of data, businesses are urgently hiring freshers who can clean, analyze, and visualize data into actionable business decisions.
According to hiring trends on Pagaar India, freshers with core SQL, Excel, and PowerBI skills can land starter salary packages between ₹3,50,000 to ₹7,00,000 per annum (₹25,000 - ₹55,000/month) in major tech hubs like Delhi NCR (Noida/Gurugram), Bengaluru, and Pune.
Essential Technical Skills Required for Data Analyst Freshers
- Advanced Microsoft Excel: Pivot Tables, VLOOKUP/XLOOKUP, INDEX-MATCH, conditional formatting, and summary dashboards.
- SQL (Structured Query Language): JOINs (INNER, LEFT, RIGHT), GROUP BY, HAVING, subqueries, Aggregate functions, and Window functions (ROW_NUMBER, RANK).
- BI Tools (Power BI or Tableau): Creating interactive KPI dashboards, DAX formulas in Power BI, data modeling, and automated report publishing.
- Python Basics (Pandas & NumPy): Data manipulation, handling null values, and basic data cleaning pipelines.
Top Hiring Cities for Data Analysts in India
1. Delhi NCR (Gurugram & Noida Sector 62/63)
Hub for e-commerce, logistics, and fintech companies offering ₹3.6L - ₹6.5L for graduates with strong SQL and business reporting acumen.
2. Bengaluru (Whitefield, Koramangala & Electronic City)
Product startups and IT giants hiring junior data analysts and BI engineers with packages up to ₹7.5 LPA.
3. Pune (Hinjewadi & Magarpatta)
Automotive, manufacturing, and analytics shared services centers with regular day-shift requirements.
Sample Technical Interview Questions for Data Analysts
- What is the difference between WHERE and HAVING clause in SQL?
Answer: WHERE filters rows before aggregation, whereas HAVING filters groups after GROUP BY aggregation is applied. - Explain the difference between UNION and UNION ALL.
Answer: UNION removes duplicate records while UNION ALL includes all duplicate records and executes faster. - How do you handle missing or NULL values in a dataset?
Answer: Depending on data integrity, either impute with mean/median/mode, categorize as 'Unknown', or drop rows if missingness is critical.
Need to Hire Staff?
Post your job openings on Pagaar India for 100% free and recruit verified local talent instantly.
Create Recruiter AccountLooking for a Job?
Create your profile, upload your resume, and let verified employers contact you directly.
Register as Candidate