AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Fractal Analytics Data Analyst Interview Questions and Answers
Fractal Analytics Data Analyst Interview Experiences
4 interviews found
Anonymous
(1 Question)
- Q1. What are the SQL commands can you explain it
- Ans.
SQL commands are used to interact with databases to perform various operations like querying, updating, and deleting data.
SELECT: Retrieves data from a database
INSERT INTO: Adds new records to a table
UPDATE: Modifies existing records in a table
DELETE: Removes records from a table
CREATE TABLE: Creates a new table in the database
ALTER TABLE: Modifies an existing table structure
DROP TABLE: Deletes a table from the databas
Skills evaluated in this interview
I applied via Company Website and was interviewed before Jan 2024. There were 2 interview rounds.
SQL Test
3 questions for Solution using SQL queries.
(4 Questions)
- Q1. SQL queries using window function
- Q2. Resume questions
- Q3. Past experience
- Q4. KPI that you have created
Interview Preparation Tips
Then he had bad internet connectivity he didnt hear my responses properly
I applied via Recruitment Consulltant and was interviewed in May 2024. There was 1 interview round.
Basic quants test had to attend.
Interview Preparation Tips
- Python
- SQL
- powerbi
Selected
I was interviewed before Feb 2024.
The platform used was Deselect, which featured questions on Python, SQL, and aptitude.
(3 Questions)
- Q1. Asked some python and sql questions.
- Q2. Questions regarding sql joins, having where clause.
- Q3. Some machine learning questions on regression, classification, confusion matrix, assumptions of linear regression, how bagging boosting works.
(2 Questions)
- Q1. Asked questions related to projects mentioned in resume
- Q2. Asked me to explaind the credit card fraud detection project end to end.
Fractal Analytics interview questions for designations
Top trending discussions
Interview questions from similar companies
(1 Question)
- Q1. SQL, excel, python and power Bi
I applied via Campus Placement and was interviewed in Oct 2022. There were 4 interview rounds.
SQL and quant, logical questions were asked.
(1 Question)
- Q1. 1. Tell me about your self 2. Resume based questions 3. Need to write basic SQL queries and also print same output using pandas
(1 Question)
- Q1. 1. Tell me about your self 2. Statistics questions 3. Guestimates 4. Why do you want to join company
Interview Preparation Tips
Selected
I applied via campus placement at University Business School (UBS), Chandigarh and was interviewed before Aug 2022. There were 4 interview rounds.
It consist of questions related to aptitude, basic computer science, statistics.
(1 Question)
- Q1. Listen to audio and speak what is said.
(2 Questions)
- Q1. What is your strength and weakness.
- Q2. What is join and it's types
- Ans.
Join is a SQL operation used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left ...
Interview Preparation Tips
- SQL
- Web Development
Skills evaluated in this interview
Syed Afraz Hussain
I applied via campus placement at Muffakhamjah College of Engineering and Technology, Hyderabad and was interviewed before May 2022. There were 5 interview rounds.
It was a hybrid type of test it consisted of 3 sections
1. Aptitude
2. 2 DSA questions only the algorithm was to be written on the paper
3. 5 SQL queries (Intermediate level)
(2 Questions)
- Q1. This was a one-to-one coding round medium-level dsa questions were asked.
- Q2. Find the minimum element in a stack in O(1) complexity
- Ans.
To find the minimum element in a stack in O(1) complexity, we can use an auxiliary stack.
Create an auxiliary stack to keep track of the minimum element.
Push the first element of the main stack onto the auxiliary stack.
For each subsequent element, compare it with the top element of the auxiliary stack.
If it is smaller, push it onto the auxiliary stack.
To get the minimum element, simply return the top element of the auxi...
(2 Questions)
- Q1. In this round knowledge regarding SQL queries was tested.
- Q2. Fetch data without using subqueries instead use joins type of questions
(1 Question)
- Q1. In this round real world problem was described and I was asked to develop a data analytics solution for the same.
Interview Preparation Tips
Skills evaluated in this interview
Saumya Gupta
I applied via campus placement at Indraprastha College for Women, Delhi and was interviewed before Dec 2021. There were 5 interview rounds.
The questions asked were very easy and easy to solve.
(1 Question)
- Q1. The questions asked from the project itself. My project was on NLP so they asked lemmatizing, tokenization etc., and some of the basic SQL questions.
This was a fitment round they ask questions from the project if you have done any otherwise the case studies.
(1 Question)
- Q1. As i was a freshwr so they asked questions about the interviews have done so far.
Interview Preparation Tips
- Try to done some project
- SQL
- Excel
Selected
I applied via Indeed and was interviewed before Oct 2022. There were 3 interview rounds.
Basic python questions
(1 Question)
- Q1. SQL question on joins and subqueries. Capstone project questions
Interview Preparation Tips
Fractal Analytics Interview FAQs
Tell us how to improve this page.
Fractal Analytics Interviews By Designations
- Fractal Analytics Consultant Interview Questions
- Fractal Analytics Data Engineer Interview Questions
- Fractal Analytics Data Scientist Interview Questions
- Fractal Analytics Software Engineer Interview Questions
- Fractal Analytics Decision Scientist Interview Questions
- Fractal Analytics Business Analyst Interview Questions
- Fractal Analytics Senior Consultant Interview Questions
- Fractal Analytics Summer Intern Interview Questions
- Show more
Fractal Analytics Data Analyst Interview Process
based on 4 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Fractal Analytics Data Analyst Reviews and Ratings
based on 10 reviews
Rating in categories
|
Consultant
1.1k
salaries
|  ₹6.8 L/yr - ₹24 L/yr |
|
Data Engineer
717
salaries
| ₹7.5 L/yr - ₹28 L/yr |
|
Senior Consultant
586
salaries
| ₹11 L/yr - ₹40 L/yr |
|
Data Scientist
462
salaries
| ₹8.4 L/yr - ₹33 L/yr |
|
Senior Engineer
201
salaries
| ₹15 L/yr - ₹44 L/yr |
Mu Sigma
AbsolutData
LatentView Analytics
Tiger Analytics
- Home >
- Interviews >
- Fractal Analytics Interview Questions >
- Fractal Analytics Data Analyst Interview Questions
