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

Data Analyst

Company
Company Indigo
Type
Opportunity Type Internship
Salary
Stipend / Salary 5 LPA
Location
Location Gurgaon, Haryana
Posted Date
Posted Date Today
Python SQL Machine Learning Statistics Data Analysis Data Visualization Deep Learning GenAI Databricks Snowflake Azure AWS MLOps Model Deployment
πŸ“–
Aptitude Practice Questions Open Resource β†—
Helps you sharpen quantitative and logical reasoning skills essential for the online test at IndiGo.
πŸ“–
Data Science Interview Preparation Open Resource β†—
Covers common data‑science concepts and interview questions that align with IndiGo's technical round.
πŸ“–
Comprehensive Interview Guides Open Resource β†—
Provides detailed interview experiences and tips for navigating the multi‑round process at IndiGo.
πŸ“–
Coding Practice Problems Open Resource β†—
Offers a wide range of algorithmic challenges to improve coding speed and accuracy for the technical assessment.

Bachelor's or Master's degree in Computer Science, Statistics, Mathematics, Engineering or related field; minimum 60% aggregate (or CGPA 6.0/10); no active backlogs; graduating batch 2026 (or 2025/2027 for eligible candidates); strong foundation in programming, statistics, and data analysis.

1
Round 1: Online Aptitude & Logical Reasoning Test
2
Round 2: Technical Interview (Data Science & Programming)
3
Round 3: HR Interview (fitment, communication, and expectations)
IndiGo, officially InterGlobe Aviation Ltd., is India’s largest low‑cost airline and a pioneer in the domestic aviation space. With a fleet of over 300 aircraft and a network that connects more than 100 destinations, IndiGo has built a reputation for punctuality, operational excellence, and a customer‑centric approach. The company’s rapid growth has been driven by a data‑first mindset, where insights from analytics shape route planning, pricing strategies, and customer experience enhancements. As a result, IndiGo invests heavily in building a robust analytics ecosystem, offering fresh talent a chance to work on real‑world problems that impact millions of passengers every day. The Data Analyst role at IndiGo’s Gurgaon office is designed for recent graduates who are passionate about turning raw data into actionable intelligence. You will be part of a cross‑functional team that collaborates closely with product managers, engineers, and business leaders to deliver AI/ML solutions that drive revenue, improve operational efficiency, and enhance decision‑making across the organization. This position offers exposure to end‑to‑end data pipelines, from data ingestion on cloud platforms to model deployment and monitoring in production. Key Responsibilities: 1. Engage with business stakeholders to understand challenges and translate them into analytical problems. 2. Perform exploratory data analysis, data cleaning, and feature engineering on large datasets. 3. Build, train, and validate machine‑learning models using Python libraries such as scikit‑learn, TensorFlow, or PyTorch. 4. Deploy models on cloud environments (Azure/AWS) and set up monitoring dashboards for performance tracking. 5. Create interactive visualisations and dashboards using tools like Power BI or Tableau to communicate insights. 6. Automate repetitive analytical workflows using SQL scripts and Python pipelines. 7. Collaborate with data engineering teams to ensure data quality, reliability, and scalability. 8. Document methodologies, findings, and recommendations for both technical and non‑technical audiences. 9. Stay updated with emerging trends in AI, GenAI, and MLOps to continuously improve solutions. 10. Participate in code reviews and knowledge‑sharing sessions within the analytics community. Tech Stack: Python, SQL, Machine Learning, Statistics, Data Visualization, Deep Learning/GenAI (preferred), Databricks, Snowflake, Azure/AWS (preferred), MLOps tools (Docker, Kubernetes, MLflow). Growth Path: Starting as a Data Analyst, high performers can progress to Senior Analyst, Data Scientist, or Analytics Lead roles within 2‑3 years. The airline’s emphasis on internal mobility means you can also transition to product analytics, revenue management, or operations research teams. Why Join IndiGo? You will work in a fast‑paced, data‑driven environment that values innovation and impact. The company offers competitive compensation, continuous learning opportunities, and a culture that encourages collaboration across functions. If you are eager to apply your analytical skills to solve real business problems in the aviation sector, IndiGo provides the platform to accelerate your career.

Indigo β€” 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 🎯
Indigo Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Indigo 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 (Python, SQL, Machine Learning, Statistics, Data Analysis, Data Visualization, Deep Learning, GenAI, Databricks, Snowflake, Azure, AWS, MLOps, Model Deployment) & 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
Indigo 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 Indigo as a Data Analyst?
Preparation Tip: Highlight Indigo's market reputation, recent tech innovations, and how your skills in Python 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 β†—
Indigo
Data Analyst
Apply Apply Now β†—
Chat Chat with Kashii