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
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
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
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 was interviewed in Dec 2024.
(6 Questions)
- Q1. Tell me About Yourself
- Q2. Project working and day to day activities I do
- Q3. Rate Yourself In SQL out of 5
- Q4. Sql 3 question based on windows function
- Q5. Very basic python 2 Question
- Q6. What You do on power bi in your work Explain with full details workflow
(1 Question)
- Q1. All 3 sql Questions very simple Round but they didn't provide any Data tables just tell this and that so it may get confusing I slove 2 out of three but rejected on this Round questions Are intermidate
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Can you provide an overview of your background, including your past experiences and daily activities, as well as the tools you use in your routine?
- Q2. What are the concepts of advanced Excel and Power BI projects, and how are they utilized within a company or for clients?
(2 Questions)
- Q1. Can you explain your project experience related to Advanced Excel and Power BI?
- Q2. What are the concepts of credit and operations, particularly in relation to Know Your Customer (KYC) procedures and the privacy of client data?
Interview Preparation Tips
I applied via AmbitionBox and was interviewed in Nov 2024. There were 3 interview rounds.
(1 Question)
- Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.
A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.
Interview Preparation Tips
Sql python bigdata hadoop hive spark
1 hour simple coding python sql
(5 Questions)
- Q1. Advantages of sql
- Ans.
SQL allows for efficient data retrieval, manipulation, and analysis in relational databases.
SQL is widely used in querying databases to retrieve specific data.
It allows for data manipulation, such as adding, updating, and deleting records.
SQL can perform complex data analysis tasks, such as aggregations and joins.
It provides a standardized language for interacting with relational databases.
SQL is essential for generati...
- Q2. Advantages of python
- Ans.
Python is a versatile programming language known for its simplicity, readability, and vast library support.
Easy to learn and use, making it ideal for beginners and experienced programmers alike
Extensive library support for data analysis, machine learning, web development, and more
Strong community support with active forums and resources for problem-solving
Cross-platform compatibility allows for seamless integration wit...
- Q3. Spark and its benefits
- Ans.
Spark is a fast and powerful big data processing framework that offers benefits like speed, ease of use, and versatility.
Spark is known for its speed, as it can process data up to 100 times faster than traditional Hadoop MapReduce.
It offers ease of use with high-level APIs in Java, Scala, Python, and SQL, making it accessible to a wide range of users.
Spark is versatile, supporting various workloads such as batch proces...
- Q4. Why to leave the company
- Q5. Huddles of data engineer
- Ans.
Huddles of data engineers refer to collaborative meetings or discussions among data engineers to share insights, solve problems, and make decisions.
Huddles are typically informal and can be scheduled or ad-hoc.
They provide a platform for data engineers to brainstorm, troubleshoot, and exchange ideas.
Huddles may involve reviewing code, discussing data pipelines, or addressing technical challenges.
Effective huddles promo...
Skills evaluated in this interview
Osfin.ai Interview FAQs
Tell us how to improve this page.
Osfin.ai Interviews By Designations
Osfin.ai Data Analyst Interview Process
based on 8 interviews
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
17
salaries
|  ₹3.6 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
