Upload Button Icon Add office photos

Filter interviews by

IIFL SAMASTA Data Analyst Interview Questions, Process, and Tips

Updated 25 Feb 2024

IIFL SAMASTA Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 25 Feb 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - One-on-one 

(6 Questions)

  • Q1. What are different types of joins in sql.
  • Ans. 

    Different types of joins in SQL include inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is a 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 table.

    • Full outer join: Returns rows when there is a match in either table.

  • Answered by AI
  • Q2. How to use Vlookup in excel.
  • Ans. 

    Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.

    • Enter the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) in a cell

    • lookup_value is the value to search for in the first column of the table_array

    • table_array is the range of cells that contains the data

    • col_index_num is the column number in the table_array from which to retr...

  • Answered by AI
  • Q3. Write a python code to retrieve common rows from two tables
  • Ans. 

    Python code to retrieve common rows from two tables

    • Use pandas library to read tables and perform operations

    • Merge the two tables using a common column

    • Filter the merged table to get common rows

  • Answered by AI
  • Q4. Explain one of your capstone projects.
  • Q5. How do we manage large data.
  • Ans. 

    Large data can be managed through data storage solutions, data processing techniques, and data visualization tools.

    • Utilize data storage solutions such as databases, data lakes, and cloud storage to store large volumes of data.

    • Implement data processing techniques like data cleaning, transformation, and aggregation to analyze and extract insights from large datasets.

    • Use data visualization tools like Tableau, Power BI, or...

  • Answered by AI
  • Q6. What do you know about our comapny.

Interview Preparation Tips

Topics to prepare for IIFL SAMASTA Data Analyst interview:
  • Python
  • Excel
  • Data Management
  • SQL
Interview preparation tips for other job seekers - You must have advance knowledge in excel, python, good knowledge in sql would be beneficial. And should have knowledge on how to manage large data.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected

I appeared for an interview in Feb 2024.

Round 1 - Coding Test 

1 hour coding test on intermediate python programming

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on cloud-based technologies
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Asked questions of finance and aptitude

Round 2 - One-on-one 

(3 Questions)

  • Q1. What is machine learning?
  • Ans. 

    Machine learning is a branch of artificial intelligence that involves developing algorithms and models that enable computers to learn from and make predictions or decisions based on data.

    • Machine learning is a subset of artificial intelligence that focuses on developing algorithms that can learn from and make predictions or decisions based on data.

    • It involves training models on large datasets to recognize patterns and m...

  • Answered by AI
  • Q2. What do you know about SQL?
  • Ans. 

    SQL is a programming language used for managing and manipulating relational databases.

    • SQL stands for Structured Query Language

    • It is used to retrieve and manipulate data in relational databases

    • Common SQL commands include SELECT, INSERT, UPDATE, DELETE

    • SQL can be used to create tables, indexes, and views

    • Examples of SQL databases include MySQL, PostgreSQL, Oracle

  • Answered by AI
  • Q3. What you know about software Development?
  • Ans. 

    Software development involves creating, designing, testing, and maintaining software applications.

    • Software development includes coding, testing, debugging, and documenting software applications.

    • Developers use programming languages like Java, Python, C++, etc. to write code.

    • Agile and Waterfall are common software development methodologies.

    • Version control systems like Git are used to manage code changes.

    • Software developm...

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. What are the algorithms you know in machine learning and their details ?
  • Ans. 

    Various machine learning algorithms with brief details

    • Supervised Learning: Linear Regression, Logistic Regression, Support Vector Machines (SVM), Decision Trees, Random Forest

    • Unsupervised Learning: K-means Clustering, Hierarchical Clustering, Principal Component Analysis (PCA)

    • Reinforcement Learning: Q-Learning, Deep Q-Networks (DQN)

    • Neural Networks: Convolutional Neural Networks (CNN), Recurrent Neural Networks (RNN), L

  • Answered by AI
  • Q2. Python questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Python and ML well.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

They will ask general aptitude test

Round 3 - Aptitude Test 

It was 30 minutes aptitude test

Round 4 - HR 

(3 Questions)

  • Q1. Salary related questions
  • Q2. Work related questions
  • Q3. They asked about last job details

Interview Preparation Tips

Interview preparation tips for other job seekers - If you want to have good work like balance and good culture piramal will be there as a good life and they really celebrate small small achievement of employees and every fastival celebration in office before the leave of fastival good leave policy happy position environment good employees buddy training also they provide after the training
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. It was more related to my projects
  • Q2. Asked questions on PCA,KNN and Elbow method .
Round 2 - Technical 

(2 Questions)

  • Q1. Asked SVM and Logistic regression, their applications and real life uses
  • Q2. Matrix formation of a knockout Tournament
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. What is your current role ?
  • Q2. Why are you looking for a job change?
Round 2 - Technical 

(1 Question)

  • Q1. Python based list iteration, SQL join based questions
Round 3 - Behavioral 

(1 Question)

  • Q1. What are the project you have worked upon ?

Interview Preparation Tips

Interview preparation tips for other job seekers - Ensure your SQL concepts are solid especially windows functions. For python try working on list and string based manipulation along with fundamentals.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Case Study 

Asked about a case study on whom to give a loan among 1000 customers

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - HR 

(1 Question)

  • Q1. Proficiency in data analytics tool level?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about the types of join sql.
  • Ans. 

    Types of join SQL include inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is a 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 table.

    • Full outer join: Returns rows when there is a match in either table.

  • Answered by AI
  • Q2. Tell about the dax function
  • Ans. 

    DAX (Data Analysis Expressions) is a collection of functions, operators, and constants that can be used in Power BI, Excel, and other data analysis tools.

    • DAX functions are used to create calculated columns, measures, and calculated tables in Power BI and Excel.

    • DAX functions include mathematical, logical, statistical, and text functions.

    • Examples of DAX functions are SUM, AVERAGE, IF, RELATED, CALCULATE, etc.

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Oct 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(3 Questions)

  • Q1. No questions asked
  • Q2. No questions are asked
  • Q3. No questions asked as doesnt want to interview

Interview Preparation Tips

Interview preparation tips for other job seekers - The so called person Mr.Ritom Das is least bother to take interview.
When we started the interview I introduced about me then inbetween interview he went to discuss with another person and came back after 15 min.Once came back he just heard me and doesn't ask any questions.
Too much unprofessional behaviour. All job seekers please don't join this company where the senior person having this kind of behaviour.
They already taking the internal person or alread had someone from their relationship.
Why wasting people's time

IIFL SAMASTA Interview FAQs

How many rounds are there in IIFL SAMASTA Data Analyst interview?
IIFL SAMASTA interview process usually has 1 rounds. The most common rounds in the IIFL SAMASTA interview process are One-on-one Round.
How to prepare for IIFL SAMASTA Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at IIFL SAMASTA. The most common topics and skills that interviewers at IIFL SAMASTA expect are Data Analysis, Data Cleansing, Data Collection, Power BI and Python.
What are the top questions asked in IIFL SAMASTA Data Analyst interview?

Some of the top questions asked at the IIFL SAMASTA Data Analyst interview -

  1. Write a python code to retrieve common rows from two tab...read more
  2. What are different types of joins in s...read more
  3. How to use Vlookup in exc...read more

Tell us how to improve this page.

IIFL SAMASTA Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
IIFL SAMASTA Data Analyst Salary
based on 12 salaries
₹4.3 L/yr - ₹7.3 L/yr
16% less than the average Data Analyst Salary in India
View more details

IIFL SAMASTA Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

2.0

Skill development

4.0

Work-life balance

3.0

Salary

5.0

Job security

2.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Branch Credit Manager
299 salaries
unlock blur

₹1.5 L/yr - ₹4.2 L/yr

Branch Manager
186 salaries
unlock blur

₹2 L/yr - ₹7 L/yr

Assistant Manager
171 salaries
unlock blur

₹2.5 L/yr - ₹6.8 L/yr

Credit Manager
121 salaries
unlock blur

₹0.9 L/yr - ₹6.8 L/yr

Relationship Manager
105 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Explore more salaries
Compare IIFL SAMASTA with

HDB Financial Services

3.9
Compare

Shriram Finance

4.1
Compare

Muthoot Fincorp

4.5
Compare

Bajaj Finance

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview