KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
REQUIREMENT_ID_332 β€’ 3-DAY_ACTIVE_POLICY

Data Analyst

Company
Company Midtown Software
Type
Opportunity Type Full-Time Job
Salary
Stipend / Salary 3.5 LPA
Location
Location Chandigarh
Posted Date
Posted Date Today
SQL Python Excel Tableau PowerBI Data Visualization Statistical Analysis Problem Solving Communication
πŸ“–
Aptitude Practice Questions Open Resource β†—
Comprehensive set of quantitative and logical problems to sharpen the analytical thinking required for the online test.
πŸ“–
Company Interview Preparation Guide Open Resource β†—
Curated interview questions and strategies that help candidates understand typical corporate interview patterns.
πŸ“–
Midtown Software Data Analyst Interview Guide Open Resource β†—
Specific resources covering the role‑specific topics and sample questions asked by Midtown Software for data analyst positions.
πŸ“–
Algorithm & Data Structure Problem Set Open Resource β†—
Extensive collection of coding problems to practice problem‑solving skills essential for technical interviews.

Graduates (B.Tech/B.E., B.Sc., MCA or related fields) with a minimum of 60% aggregate. Open to 2025, 2026 and 2027 batches. Maximum of 2 active backlogs allowed. Strong analytical mindset, good communication skills, and willingness to learn are essential.

1
Round 1: Online Aptitude Test
2
Round 2: Technical Interview (SQL/Python & case study)
3
Round 3: HR Interview (fitment and motivation)
Midtown Software is a fast‑growing technology solutions provider headquartered in Chandigarh, India. Established in 2015, the company specializes in custom software development, data analytics, and cloud‑based services for clients across banking, retail, and healthcare sectors. With a team of over 300 professionals, Midtown has built a reputation for delivering data‑driven insights that help businesses make informed decisions and improve operational efficiency. The firm prides itself on a collaborative work environment that encourages continuous learning. Employees benefit from regular tech talks, mentorship programs, and a flexible work‑from‑office policy that balances productivity with personal well‑being. Midtown’s commitment to innovation is reflected in its investment in modern tools such as Python, SQL, Tableau, PowerBI and Azure, ensuring that its analysts work with industry‑standard technology. Role Summary: As a Data Analyst (Fresher), you will be the analytical backbone of the organization, turning raw data into actionable insights that drive business strategy. You will work closely with cross‑functional teams, understand client requirements, and create visualizations that simplify complex data narratives. Key Responsibilities: 1. Understand day‑to‑day business issues and identify data‑based solutions. 2. Coordinate with team members to ensure timely completion of analytical tasks. 3. Compile, clean, and analyze datasets related to business problems. 4. Develop clear, impactful visualizations using Tableau or PowerBI. 5. Prepare customized datasets that align with client needs. 6. Suggest creative ideas to enhance product features based on data insights. 7. Interact with customers daily to support their analytical queries during business hours and occasionally after hours. 8. Document analytical processes and maintain data quality standards. 9. Participate in brainstorming sessions to propose data‑driven improvements. 10. Stay updated with emerging analytics tools and best practices. Tech Stack: Python, R, SQL, Excel, Tableau, PowerBI, Git, Azure Data Services. Growth Path: Junior Data Analyst β†’ Data Analyst β†’ Senior Data Analyst β†’ Data Scientist / Team Lead β†’ Analytics Manager. The company offers structured training, certification support, and clear promotion criteria based on performance and skill acquisition. Why Join Midtown Software: Fresh graduates get hands‑on exposure to real‑world projects from day one, mentorship from seasoned data professionals, and a culture that rewards curiosity and innovation. The competitive salary, performance‑linked bonuses, and a supportive work‑life balance make it an ideal launchpad for a career in analytics.

Midtown Software β€” Data Analytics & SQL Interview Guide

Previously asked questions, exam syllabus, coding benchmarks & round strategy.

APTITUDE & LOGIC πŸ“–
Aptitude Practice Questions & Online Mock Tests

Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test.

Open Resource β†—
COMPANY GUIDE 🎯
Midtown Software Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Midtown Software and off-campus tech roles.

Open Resource β†—
MOCK TESTS & PAPERS πŸ“
Comprehensive Interview Prep Resources & Syllabus

Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds.

Open Resource β†—
CODING PRACTICE πŸ’»
Algorithm and Data Structure Problem Set

Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Open Resource β†—
Round 1: Online Assessment (OA)
Aptitude, Quantitative Logic & 2 Coding Problems
Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1
Core Tech Stack (SQL, Python, Excel, Tableau, PowerBI, Data Visualization, Statistical Analysis, Problem Solving, Communication) & Live Code Tracing
Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving
Database Schemas, APIs & Architecture Basics
Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion
Midtown Software Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between WHERE and HAVING clauses in SQL? Answer β–Ό
Model Answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer β–Ό
Model Answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer β–Ό
Model Answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer β–Ό
Model Answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer β–Ό
Model Answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Why do you want to join Midtown Software as a Data Analyst?
Preparation Tip: Highlight Midtown Software's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Preparation Tip: Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Preparation Tip: Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More Fresh Requirements in Software Engineering

View Category Feed β†—
Midtown Software
Data Analyst
Apply Apply Now β†—
Chat Chat with Kashii