
Required Skills & Tech Stack
SQL
Python
Excel
Data Visualization
Tableau
PowerBI
Statistics
Data Cleaning
Analytical Thinking
Communication

π Free Study Materials (4)

Eligibility Criteria
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.

Selection & Interview Process
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

Job Description & Key Responsibilities
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.

Preparation Hub
Codeatrix β Data Analytics & SQL Interview Guide
Previously asked questions, exam syllabus, coding benchmarks & round strategy.
π Previously Asked Questions & Preparation Links
π» Previously Asked Coding Challenges
πΊοΈ Round-Wise Strategy
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.
β Core Technical Questions & Answers
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.
π€ Behavioral & HR Questions (STAR Method)
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.