Aditya Birla Fashion and Retail Limited (ABFRL) – TCNS is looking for an Analytics & AI Intern to work on practical projects across Generative AI, Databricks, SQL, Data Analytics, Business Intelligence, Web Automation and AI Bots. The opportunity is particularly relevant for final-year students and fresh graduates who enjoy working with data, solving business problems and exploring emerging AI technologies.
🏢 About ABFRL & TCNS
Aditya Birla Fashion and Retail Limited (ABFRL) is one of India’s major fashion and lifestyle companies, with a portfolio spanning multiple fashion brands and retail formats. Its business combines fashion, retail operations, digital platforms, supply-chain capabilities and customer-focused analytics.
TCNS Clothing Co. Limited, known for brands such as W, Aurelia and Wishful, became part of the ABFRL ecosystem following ABFRL’s acquisition of a controlling stake in TCNS. The integration provides exposure to a large-scale fashion-retail environment where data can support areas such as customer behaviour, merchandising, inventory, marketing and business performance.
📌 Job Overview
- 🏢 Company: ABFRL – TCNS
- 💼 Role: Analytics & AI Intern
- 📍 Location: Delhi NCR
- 🎓 Target Candidates: Final-year students / Fresh Graduates
- 🤖 Focus Areas: GenAI, Databricks, SQL, Data Analytics
- 📊 Additional Areas: Business Intelligence, Web Automation, AI Bots
- 🧠 Key Requirement: Analytical thinking and curiosity for AI/GenAI
- 🗣️ Work Style: Learning-oriented, problem-solving and project-focused
💻 What Could You Work On?
The role covers several connected areas. In data analytics, an intern could work with SQL queries, datasets, dashboards and business metrics. With Databricks, the work may involve data preparation, transformation, analysis and potentially analytics workflows on larger datasets.
The GenAI and AI-bot component adds a modern engineering dimension. Depending on the project, interns may explore LLM-based assistants, automated workflows, prompt engineering, document processing or AI-powered business applications.
🌟 Why This Role Is Good for Freshers
For a final-year student or recent graduate, the biggest advantage is the opportunity to build a profile that combines SQL + analytics + cloud data platforms + AI. These skills are increasingly interconnected in modern data teams.
Instead of specialising immediately in only traditional reporting or only AI experimentation, an intern can gain exposure to the complete journey: data → analysis → business insight → automation → AI-powered solution.
🛠️ Skills Required
🔹 Data & Analytics
- SQL: joins, subqueries, CTEs and window functions
- Data cleaning and transformation
- Excel and basic statistical analysis
- Data visualisation and dashboard concepts
- Business KPI understanding
🔹 Databricks
- Databricks notebooks
- Spark/PySpark fundamentals
- DataFrames and transformations
- Basic data-lake/lakehouse concepts
🔹 GenAI
- LLM fundamentals
- Prompt engineering
- Embeddings and RAG basics
- AI chatbot architecture
- GenAI evaluation and hallucination awareness
🔹 Automation
- Python scripting
- Selenium, Playwright or similar tools
- REST APIs
- Git/GitHub
- Basic debugging and exception handling
🔹 Professional Skills
- Analytical thinking
- Curiosity and willingness to learn
- Business communication
- Presentation and storytelling
- Collaboration and ownership
🎯 Expected Interview Rounds
- Round 1 – Resume/Recruiter Screening: Education, projects, SQL exposure, availability and interest in analytics/AI.
- Round 2 – Technical Assessment: SQL, Python, data interpretation, logical reasoning and possibly a basic coding or analytics task.
- Round 3 – Technical/Project Discussion: Questions around Databricks, analytics projects, GenAI concepts, automation and the candidate’s actual contribution.
- Round 4 – Manager/HR Discussion: Problem-solving approach, communication, learning ability, teamwork and motivation for the fashion-retail/AI environment.
💰 Expected Salary / Stipend
The hiring post does not disclose an official stipend. Public internship salary data for ABFRL-related roles varies significantly by designation and source, so there is not enough reliable evidence to assign a precise official figure to this particular Analytics & AI internship.
For planning purposes, candidates may encounter an indicative internship range of approximately ₹15,000–₹30,000 per month, depending on the final role structure, candidate profile and employment terms. This is not an official ABFRL/TCNS salary band and should be confirmed with the recruiter.
📚 Preparation Tips
- SQL first: Practise joins, CTEs, window functions, aggregation and business-oriented queries.
- Build a retail analytics project: Analyse sales, customer, product or inventory data and create a dashboard with actionable insights.
- Learn Databricks basics: Understand notebooks, PySpark, DataFrames and the difference between traditional databases and lakehouse workflows.
- Build a small GenAI bot: Create a simple RAG chatbot using company/product documents and explain ingestion, embeddings, retrieval and generation.
- Try automation: Automate a repetitive website workflow using Selenium or Playwright and document the business value.
- Prepare business cases: Practise answering questions such as “Why did sales fall?” or “Which products should receive more inventory?” using data.
- Explain AI responsibly: Know basic risks including hallucination, data privacy, prompt injection and incorrect model outputs.
📝 Resume Tips
- Put SQL, Python, Data Analytics, Databricks and GenAI prominently in the skills section.
- Create separate Analytics Projects and AI/GenAI Projects sections if you have relevant work.
- Quantify results: dataset size, dashboard users, query-performance improvement, automation time saved or model accuracy.
- Mention PySpark/Databricks only when you can explain your implementation.
- Include dashboards created using Power BI/Tableau if relevant.
- For GenAI projects, mention the LLM, vector database, RAG approach and evaluation method instead of simply writing “GenAI chatbot.”
- Highlight web automation with the exact framework used.
- Keep the resume to one page and focus on projects demonstrating practical skills.
🚀 How to Apply
Interested candidates can DM to Shakir Wani and share updated resume if their experience matches the job requirements.
The hiring post asks interested candidates to DM to Shakir Wani their profile. Final-year students and fresh graduates interested in the role should share an updated, concise resume highlighting SQL, analytics, Python, Databricks and AI/GenAI projects.
📍 Location: Delhi NCR
🎓 Preferred: Final-year students / Fresh Graduates
🤖 Focus: Analytics + AI + GenAI + Databricks
📩 Application: DM the recruiter/post author with your profile
🔔 Final Thoughts: This Analytics & AI Intern opportunity combines data analytics, SQL, Databricks, GenAI, BI and automation in a real business environment. Candidates should focus on demonstrating practical projects rather than only listing technologies. A strong SQL foundation, one meaningful analytics project and one hands-on GenAI or automation project can make the profile substantially more relevant to this type of internship.
