AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Osfin.ai Data Analyst Intern Interview Questions and Answers
Osfin.ai Data Analyst Intern Interview Experiences
2 interviews found
Anonymous
Selected
I applied via Company Website and was interviewed in Nov 2024. There were 5 interview rounds.
You'll get a test link for SQL, which is moderate level.
Its basically the logical reasoning
(3 Questions)
- Q1. Scenerio based questions on joins (prepare for multiple answers)
- Q2. Secenerio based questions on windows functions
- Q3. Questions on Regex since we'll be using it a lot in the work
(2 Questions)
- Q1. This round was with the implementation team maneger.
- Q2. Scenerio based questions based on sql(this will be bit tricky round), since it'll include sql, logical reasoning, aptitude to solve by sharing the screen
(2 Questions)
- Q1. Questions on sql, mostly simple definitions and probably one scenario based on joins
- Q2. Previous experience etc might be asked
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed in Nov 2024. There were 4 interview rounds.
3 SQL questions were asked
30 mcqs based on aptitude and LR were asked
(3 Questions)
- Q1. Sql question based on CTE
- Q2. Sql question based on window functions
- Q3. Some questions based on probability
(2 Questions)
- Q1. A guestimate question regarding no of Bisleri bottles sold in India in a day.
- Q2. Why do you want to join us ?
- Ans.
I am passionate about data analysis and believe this internship will provide valuable experience and learning opportunities.
Passionate about data analysis
Seeking valuable experience and learning opportunities
Believe in the company's mission and values
Interview Preparation Tips
- Data Analysis
-> Study case analysis and guesstimates
-> Be well versed with puzzles and aptitude
Interview questions from similar companies
I applied via Naukri.com and was interviewed before Aug 2021. There were 2 interview rounds.
(1 Question)
- Q1. What is Structured Query Language?
- Ans.
Structured Query Language (SQL) is a programming language used to manage and manipulate relational databases.
SQL is used to create, modify, and delete databases, tables, and data
It is used to retrieve data from databases using queries
SQL is used to perform operations on data such as sorting, filtering, and grouping
Examples of SQL-based database management systems include MySQL, Oracle, and Microsoft SQL Server
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Prior experience,questions related to data analysis tools.
Interview Preparation Tips
The reason behind the offer letter delay is they have to get approvals from multiple teams which creates a delay on the process.
I applied via Company Website and was interviewed before Aug 2021. There were 3 interview rounds.
Simple aptitude and coding test, I was selected from national talent hunt exam
(1 Question)
- Q1. Discussion about projects and Areas of interest
(1 Question)
- Q1. Basic questions like ok with location, shifts etc
Interview Preparation Tips
- Leetcode
- Data Structures
- Python
Interview Questionnaire
2 Questions
- Q1. Actualy I got the mail for filling the profile, one of the Accenture employee refered me, I filled the profile
- Q2. But that's expired on 2nd March, so Pls help me
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. Data science
Interview Preparation Tips
I applied via LinkedIn and was interviewed before Nov 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Real life example of usage of Window functions - lag and lead
- Ans.
Window functions like lag and lead are used to analyze data over a specific range or window.
Lag function can be used to calculate the difference between current and previous values in a time series data.
Lead function can be used to calculate the difference between current and future values in a time series data.
Window functions can be used to calculate moving averages, cumulative sums, and other statistical measures.
Fo...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Oct 2020. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. I went as a fresher for the job. They asked me technical skills and good cummication skills.
- Q2. I am interested to do in it
Interview Preparation Tips
I am pursuing my graduation final year (bcom
Computer)
I have technical skills and good at computer knowledge
I have good cummication skills
Thanking you
Yours careingly
I applied via Company Website and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Why should we hire you?
- Ans. Because you will never get some one like me.
Interview Preparation Tips
Osfin.ai Interview FAQs
Some of the top questions asked at the Osfin.ai Data Analyst Intern interview -
Tell us how to improve this page.
Osfin.ai Interviews By Designations
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Show more
Osfin.ai Data Analyst Intern Interview Process
based on 2 interviews
Interview experience
Data Analyst Intern Interview Questions from Similar Companies
Fast track your campus placements
|
Data Analyst
19
salaries
|  ₹3.6 L/yr - ₹9.8 L/yr |
|
Software Engineer
6
salaries
| ₹3 L/yr - ₹16.9 L/yr |
|
Program Manager
4
salaries
| ₹14 L/yr - ₹18 L/yr |
|
Business Analyst
3
salaries
| ₹3.6 L/yr - ₹8.5 L/yr |
|
Associate Director
3
salaries
| ₹40 L/yr - ₹45 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Osfin.ai Interview Questions >
- Osfin.ai Data Analyst Intern Interview Questions
