Galytix interview experience Real time questions & tips from candidates to crack your interview

Data Analyst

Galytix
upvote
share-icon
2 rounds | 3 Coding problems

Interview preparation journey

expand-icon
Journey
My journey began with learning HTML, CSS, and JavaScript, forming a solid foundation for web applications. I then explored frameworks like React and Node.js, building projects such as QuizMaster and an e-commerce app with seamless cart functionality. Expanding into AI, I worked on Brain Tumor Detection using CNNs and Credit Card Fraud Detection with XGBoost, integrating machine learning into development. Platforms like GitHub and Indeed provided resources and internships, including a research role and a summer internship at Cantilever. These experiences refined my problem-solving skills and ability to build production-ready applications. Preparing for roles involved revisiting core concepts, practicing coding problems, and developing AI-based solutions. This journey has reinforced the value of consistency, curiosity, and hands-on practice, shaping my passion for technology.
Application story
The Galytix on-campus recruitment process was a valuable learning experience. It began with an online test assessing aptitude, data structures, and algorithmic skills, followed by a technical interview where I discussed my analytical approach and problem-solving abilities. This journey enhanced my confidence and prepared me for future opportunities in data analysis.
Why selected/rejected for the role?
I was not selected for the role at Galytix because, while my DSA skills were strong, my analytical thinking and domain-specific knowledge needed improvement. The interview process made me realize the importance of structured problem-solving, data-driven decision-making, and business-oriented analytical skills in a data analyst role. This experience has motivated me to work on refining my critical thinking abilities and gaining deeper insights into real-world data analysis.
Preparation
Duration: 1 month
Topics: SQL, Excel, Arrays, Strings, DataFrames, Trees, Hashmaps, OOPS, Statistics, Data Visualization, Machine Learning
Tip
Tip

Tip 1 : Understand common patterns like sliding window and prefix sums for optimization.
Tip 2 : Solve problems on binary search tree operations (insertion, deletion, search).
Tip 3 : Focus on dynamic programming techniques for problems like longest common subsequence.

Application process
Where: Campus
Eligibility: Above 7 CGPA, Need SQL & Excel skills, (Salary Package: 6 LPA)
Resume Tip
Resume tip

Tip 1: Add some factual information about the projects you made.
Tip 2: State only those skills that you possess and not fake ones.

Interview rounds

01
Round
Medium
Online Coding Interview
Duration60 minutes
Interview date14 Feb 2025
Coding problem2

In this round around 40 MCQs and 2 coding question were given to solve. MCQs were based on Vocabulary, Logical reasoning and Analytical Thinking.

1. Duplicate In Array

Easy
15m average time
85% success
0/40
Asked in companies
WalmartBNY MellonMorgan Stanley

Given an array of N+1 integers where each number is between 1 and N (inclusive), find the duplicate element.

Problem approach

Array: [3, 1, 3, 4, 2]

Initialize a set to track seen numbers.
First element (3): Not in the set, add it.
Next element (1): Not in the set, add it.
Next element (3): Already in the set → Duplicate found: 3
Stop searching as we found the duplicate.

Final result: The duplicate element is 3.

Try solving now

2. First Missing Positive

Moderate
18m average time
84% success
0/80
Asked in companies
SAP LabsMicrosoftDunzo

Find the First Missing Positive Integer.

Problem approach

Array: [3, 4, -1, 1]

Rearrange the array so that each positive number is at its correct index (e.g., 1 at index 0, 2 at index 1, etc.).
Step 1 (Initial array): [3, 4, -1, 1]
Step 2 (Swap 3 and -1 to place 1 correctly): [1, 4, -1, 3]
Step 3 (Ignore -1 and 4, they are out of place)
Now check for the first missing number by scanning from index 0:
1 is at index 0 
4 is at index 1 (should be 2) → Missing number found: 2

Final result: The first missing positive integer is 2.

Try solving now
02
Round
Hard
Face to Face
Duration50 minutes
Interview date21 Feb 2025
Coding problem1

1. DBMS

You are designing a relational database for an e-commerce platform. The platform needs to store information about customers, products, orders, and payments.

 

Tasks:

 

Design the database schema with appropriate tables, primary keys, and foreign keys. The main tables should include:

 

  • Customers (customer details)
  • Products (product catalogue)
  • Orders (order details, including customer and product references)
  • Payments (payment transactions for orders)

 

Write an SQL query to retrieve:

 

  • The total revenue generated in the last 30 days.
  • The top 3 most purchased products.
  • The list of customers who have not placed any orders.

 

Ensure database normalization (at least up to 3rd Normal Form) and justify your design decisions.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

Which traversal uses a queue as its primary data structure?

Choose another skill to practice
Similar interview experiences
company logo
SDE - 1
3 rounds | 7 problems
Interviewed by OYO
2839 views
0 comments
0 upvotes
company logo
SDE - 1
2 rounds | 5 problems
Interviewed by Meesho
5182 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
1971 views
0 comments
0 upvotes
company logo
System Engineer
2 rounds | 2 problems
Interviewed by Tata Consultancy Services (TCS)
1742 views
0 comments
0 upvotes
Companies with similar interview experiences
company logo
Data Analyst
3 rounds | 6 problems
Interviewed by Cognizant
2455 views
0 comments
0 upvotes
company logo
Data Analyst
2 rounds | 3 problems
Interviewed by Tata Consultancy Services (TCS)
0 views
0 comments
0 upvotes