OneCard Data Analyst Interview Questions and Answers

Intermediate level coding round

Q1. Project explaination
Add your answer
Q2. Explain project ind detail
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecommunications company.
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer

Q1. Case Study of zomato ?
Add your answer
Q2. Some basic math questions. Simultaneous equations .
Add your answer

How to increase personal insurance revenue to 5x?

Q1. How do you think Business analyst?
Ans. 
Business analysts think analytically and strategically to identify business needs and recommend solutions.
• Business analysts analyze data to identify trends and patterns.

• They work closely with stakeholders to gather requirements and understand business processes.

• They use tools such as SWOT analysis, process flow diagrams, and data modeling to recommend solutions.

• Business analysts communicate effectively to bridge the ga...read more
Answered by AI
Add your answer
Q2. Please tell me about your data analyst experience.
Add your answer
Q3. Do you have any experience on SQL or Python
Ans. 
Yes, I have experience with both SQL and Python.
• I have used SQL to query databases and extract relevant information.

• I have written Python scripts to automate data analysis and reporting tasks.

• I am familiar with using SQLAlchemy in Python for database interactions.

• I have experience with data manipulation and visualization using Python libraries like Pandas and Matplotlib.
Answered by AI
Add your answer

Q1. SQL questions and logical reasoning questions
Add your answer

It was simple program of url shorting for registered and non registered users each request must have unique shortened url.

Q1. Palindrome implementation and run time
Ans. 
A palindrome is a word or phrase that reads the same backward as forward. Implementing it involves comparing the first and last characters and iterating towards the middle.
• Implement a function that takes a string as input and returns true if it is a palindrome, false otherwise.

• Use two pointers, one starting from the beginning and the other from the end, and compare the characters at each position.

• If the characters matc...read more
Answered by AI
Add your answer
Q2. DSA and various algorithms and run time
Add your answer

Q1. This round was one on one with VP of engineering. Basic q and a regarding role and responsibilities
Add your answer

Q1. Relocation, Reason For job change, future plan, careers objective
Add your answer

Scenarios base conding round

Questions on strings in javascript.
Basic javascript and typescript.

Q1. Questions on cloud technologies
Add your answer

Q1. Cultural fit and salary related discussion
Add your answer