Osfin.ai Data Analyst Interview Questions, Process, and Tips

Q1. SQL Questions hands on, previous experience
Add your answer

Case assignment after you clear round 1

Q1. Technical interview with their founding member
Add your answer

Q1. Again same as round 3
Add your answer

Q1. Offer discussed. informed that somebody will reach out to complete the offer extension formalities.
Add your answer

Q1. In the name of one on one discussion to consider my profile for senior position, they ghosted me for a week.
Add your answer

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.

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...read more
Add your answer

The co-founder took the interview for about 30 mins. It was a case study about the number of cylinders in a particular city.

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

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.
Answered by AI
Add your answer
Q2. Questions on joins
Add your answer
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...read more
Answered by AI
Add your answer

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
Answered by AI
Add your answer
Q2. After that technical question they asked general hr questions and salary discussions
Add your answer

To perform reconciliation using SQL and excel

Reasoning questions and some sql question

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
Answered by AI
Add your answer
Q2. Regarding regex
Add your answer