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

Data Analyst Internship

Company
Company Codeatrix
Type
Opportunity Type Internship
Salary
Stipend / Salary β‚Ή15,000 per month
Location
Location Remote
Posted Date
Posted Date Today
SQL Python Excel Data Visualization Tableau PowerBI Statistics Data Cleaning Analytical Thinking Communication
πŸ“–
Aptitude and Reasoning Practice Open Resource β†—
Helps you sharpen logical and quantitative skills that are often tested in the first screening round.
πŸ“–
Interview Preparation Corner Open Resource β†—
Provides a collection of common interview questions and answers useful for technical and HR rounds.
πŸ“–
Data Analyst Role Guide Open Resource β†—
Specific preparation material for Codeatrix data analyst interviews, covering SQL, Excel and visualization concepts.
πŸ“–
Algorithm Practice Problems Open Resource β†—
Offers a wide range of coding problems to improve problem‑solving speed, beneficial for technical assessments.

Open to undergraduate and postgraduate students from any stream (Engineering, Arts, Commerce, Sciences, etc.). Freshers, recent graduates and candidates with a career gap are welcome. No minimum percentage requirement specified. Candidates should be in the current batch or have graduated within the last 2 years. Backlog policy: preferably zero backlogs, but minor academic gaps may be considered with a strong skill set.

1
Round 1: Online aptitude & logical reasoning test
2
Round 2: Technical assessment covering SQL queries and basic data analysis
3
Round 3: HR interview focusing on motivation, fit and communication skills
Codeatrix is an emerging technology solutions provider that focuses on data‑driven products for small and medium enterprises across India. Founded by a group of analytics enthusiasts, the firm has quickly built a reputation for delivering actionable insights that help clients optimise operations, improve customer experience and drive revenue growth. With a lean but passionate team, Codeatrix encourages a culture of continuous learning, where interns and fresh graduates get to work on real‑world projects from day one. The company’s remote‑first policy means talent can contribute from any corner of the country while still feeling part of a collaborative community. The Data Analyst Internship at Codeatrix is designed for students and freshers who want to translate raw data into meaningful business narratives. Interns will be mentored by senior analysts and will handle end‑to‑end data workflows – from extraction and cleaning to visualisation and reporting. The role offers a hands‑on environment where you will use industry‑standard tools, receive constructive feedback, and build a portfolio that showcases your analytical capabilities. Key responsibilities include: 1. Interpreting large datasets to uncover patterns, trends, and actionable insights. 2. Writing and optimizing SQL queries to extract relevant data from relational databases. 3. Cleaning and preprocessing data by handling missing values, duplicates, and inconsistencies. 4. Performing exploratory data analysis using statistical techniques. 5. Creating interactive dashboards and visualisations with tools such as Tableau or Powerβ€―BI. 6. Preparing concise reports and presentations for stakeholders. 7. Collaborating with cross‑functional teams to understand business requirements. 8. Documenting data pipelines and analytical processes for future reference. 9. Assisting in ad‑hoc data requests and supporting decision‑making meetings. 10. Continuously learning new analytical methods and sharing knowledge within the team. The tech stack primarily includes SQL, Python (pandas, numpy, matplotlib), Excel, and data‑visualisation platforms like Tableau or Powerβ€―BI. Successful interns can expect a clear growth path – high‑performing interns may be offered a full‑time analyst position, with opportunities to move into senior analytics, product management, or data‑science roles as the company scales. Joining Codeatrix means gaining exposure to a fast‑moving startup environment, building a solid analytical foundation, and contributing to projects that have a direct impact on client success. The stipend of β‚Ή10‑15β€―K per month, flexible work‑from‑home setup, and mentorship from industry practitioners make this internship an attractive launchpad for a career in data analytics.

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

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Codeatrix 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, Data Visualization, Tableau, PowerBI, Statistics, Data Cleaning, Analytical Thinking, 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
Codeatrix 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 Codeatrix as a Data Analyst Internship?
Preparation Tip: Highlight Codeatrix'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 & Tech

View Category Feed β†—
Codeatrix
Data Analyst Internship
Apply Apply Now β†—
Chat Chat with Kashii