Add office photos
Filter interviews by
Osfin.ai Data Analyst Interview Questions, Process, and Tips
Top Osfin.ai Data Analyst Interview Questions and Answers
- Q1. What is ETL and do you know where it us used
- Q2. How to handle date different date formats
- Q3. What are indexes
Osfin.ai Data Analyst Interview Experiences
6 interviews found
Anonymous
To perform reconciliation using SQL and excel
Reasoning questions and some sql question
(2 Questions)
- Q1. How to handle date different date formats
- Ans.
Handle date different date formats by standardizing them using a common format
Identify all the different date formats present in the dataset
Convert all dates to a common format (e.g. YYYY-MM-DD)
Use libraries like pandas in Python to parse and standardize dates
Handle missing or incorrect dates by setting them to a default value
- Q2. Regarding regex
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2024. There were 6 interview rounds.
(1 Question)
- Q1. SQL Questions hands on, previous experience
Case assignment after you clear round 1
(1 Question)
- Q1. Technical interview with their founding member
(1 Question)
- Q1. Again same as round 3
(1 Question)
- Q1. Offer discussed. informed that somebody will reach out to complete the offer extension formalities.
(1 Question)
- Q1. In the name of one on one discussion to consider my profile for senior position, they ghosted me for a week.
Interview Preparation Tips
Selected
I applied via Job Portal and was interviewed in May 2024. There were 4 interview rounds.
There was a 1 hour sql test consisting of 4 sql coding questions. The questions were easy to moderate.
It was a 1 hour DI test consisting of 17 questions. The questions were easy.
(1 Question)
- Q1. The interview went on for about 1 hour. The interviewer was chill, initially asked a few DI questions, and then easy to moderate level SQL questions. I was asked to share my screen and solve some SQL queri...
The co-founder took the interview for about 30 mins. It was a case study about the number of cylinders in a particular city.
Interview Preparation Tips
- SQL
- case study
- Data Interpretation
- Finance
Selected
I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.
Youll get hacker rank link for sql test pretty decent questions from leetcode and hackerrank were asked like easy ones
Technical round questions based on sql
Computer aptitude and aruthmetic aptitude were asked
(3 Questions)
- Q1. What are indexes
- Ans.
Indexes are data structures that improve the speed of data retrieval operations in databases.
Indexes are used to quickly locate data without having to search every row in a database table.
They are created on columns in a database table to speed up SELECT queries.
Examples of indexes include primary keys, unique keys, and non-unique indexes.
- Q2. Questions on joins
- Q3. What is ETL and do you know where it us used
- Ans.
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a usable format, and load it into a data warehouse.
Extract: Data is extracted from different sources such as databases, files, APIs, etc.
Transform: Data is cleaned, formatted, and transformed into a consistent structure.
Load: The transformed data is loaded into a data warehouse for analysis and reportin...
(2 Questions)
- Q1. Do you know regex
- Ans.
Yes, I am familiar with regex and have experience using it for data analysis.
Regex stands for regular expressions and is used for pattern matching in text data
It allows for searching, extracting, and manipulating text based on specific patterns
Example: using regex to extract email addresses from a dataset
- Q2. After that technical question they asked general hr questions and salary discussions
Skills evaluated in this interview
Osfin.ai interview questions for designations
I applied via Recruitment Consulltant and was interviewed in Feb 2024. There were 2 interview rounds.
SQL related questions
(1 Question)
- Q1. Questions on sql and excel Functions
Interview Preparation Tips
pankaj verma
1 hours SQL questions and resume questions
Based on sql data and excel file
(1 Question)
- Q1. Truncate vs delete ,and basic SQL queries
Data Analyst Jobs at Osfin.ai
Top trending discussions
Interview questions from similar companies
I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Nov 2024. There were 2 interview rounds.
It consists of resume-based skill questions.
(2 Questions)
- Q1. Why do you want to join ICICI Bank?
- Ans.
I want to join ICICI Bank because of its strong reputation in the banking industry and the opportunities for growth and development it offers.
ICICI Bank is one of the leading banks in India with a strong reputation for innovation and customer service
I am impressed by ICICI Bank's focus on technology and digital banking solutions
I believe that working at ICICI Bank will provide me with opportunities for career growth an...
- Q2. Can you tell me about your projects?
- Ans.
I have worked on projects involving data analysis for marketing campaigns, customer segmentation, and sales forecasting.
Developed predictive models to optimize marketing strategies
Utilized clustering techniques for customer segmentation
Built time series models for sales forecasting
Ankit Gupta
Selected
I applied via Naukri.com and was interviewed in May 2024. There were 3 interview rounds.
Average type questions.
(1 Question)
- Q1. About the domain/fields or have any experienced or what u did there
(1 Question)
- Q1. Self introduction
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. All SQL Question
- Q2. Related Join write query and Basic SQL
Python Leetcode Question they ask
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Oct 2023. There were 4 interview rounds.
Create the table for consolidated.sql and enter the records as specified in it.
Close attention to what other's are saying.This shows respect for their opinions and allows you to build on or respond to their points.
(4 Questions)
- Q1. Start with a clear concise introduction.Briefly mention you name and the purpose of the discussion. this sets the tone and provides context
- Q2. If there's anything you're unsure about or if you need clarification, don't hesitate to ask it shows that you are engaged and interested in the conversation
- Ans.
Asking for clarification shows engagement and interest in the conversation.
Asking for clarification demonstrates active listening and a desire to fully understand the topic.
It can also help clarify any misunderstandings or uncertainties, leading to more productive discussions.
Examples: 'Could you please explain that concept in more detail?' or 'I'm not sure I understand, could you provide an example?'
- Q3. If you were faced with a specific challenge what steps would you take to address it
- Q4. How have your previous roles prepare you for this position
Interview Preparation Tips
Osfin.ai Interview FAQs
Tell us how to improve this page.
Osfin.ai Interviews By Designations
Osfin.ai Data Analyst Interview Process
based on 6 interviews in last 1 year
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Osfin.ai Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
2-6 Yrs
Not Disclosed
|
Data Analyst
15
salaries
|  ₹4.8 L/yr - ₹12 L/yr |
|
Software Engineer
6
salaries
| ₹3 L/yr - ₹17.8 L/yr |
|
Program Manager
4
salaries
| ₹14 L/yr - ₹18 L/yr |
|
Associate Director
3
salaries
| ₹40 L/yr - ₹45 L/yr |
|
Senior Software Engineer
3
salaries
| ₹30 L/yr - ₹38 L/yr |
ZestMoney
Axio
LendingKart
NeoGrowth Credit
- Home >
- Interviews >
- Osfin.ai Interview Questions >
- Osfin.ai Data Analyst Interview Questions
