AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Zifo RnD Solutions Associate Data Analyst Interview Questions and Answers
Zifo RnD Solutions Associate Data Analyst Interview Experiences
2 interviews found
Anonymous
I applied via Campus Placement and was interviewed in Aug 2023. There were 5 interview rounds.
30 minutes of aptitude round with 45 questions of basic topics such as trains, ratio, age, speed, profit and loss
Picture description. You will be given two pictures and write an essay on it.
(1 Question)
- Q1. Questions based on the domain you have picked eg: Drug development, drug discovery
(1 Question)
- Q1. Basic aptitude questions to be solved in person and general HR questions
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed in Sep 2023. There was 1 interview round.
Round 1 - Aptitude (very basic)
Round 2 - Game round
Round 3 - Basic questions regarding your course
Round 4 - Essay on give n picture
Round 4 - Interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Self Introduction
- Q2. Salary Expectation
- Ans.
I expect a salary that reflects my skills and experience, ideally in the range of $60,000 to $80,000 annually.
Research industry standards: For example, Glassdoor and Payscale can provide insights into average salaries for data analysts in my area.
Consider my experience: With 3 years of experience and proficiency in SQL and Python, I believe I bring valuable skills to the table.
Factor in the company's size and location:...
(1 Question)
- Q1. 14 questions in excel formulas
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Tell about yourself
- Ans.
I am a data analyst with a background in statistics and programming, passionate about turning data into actionable insights.
Background in statistics and programming
Experience in data analysis and visualization tools like Python, R, and Tableau
Strong problem-solving skills and attention to detail
Ability to communicate complex data findings to non-technical stakeholders
- Q2. Rate yourself in sql
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Complex sql scenarios and their results
- Ans.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. SQL and excel questions intermediate
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(3 Questions)
- Q1. Highlight the odd cells in excel
- Ans.
Use conditional formatting to highlight odd cells in Excel
Select the range of cells you want to highlight
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose 'New Rule' and select 'Use a formula to determine which cells to format'
Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)
Choose the formatting style you want for the odd cells
- Q2. What are Joins in SQL, explain different joins and their outputs
- Q3. Query to give running sum of salary
Interview Preparation Tips
Skills evaluated in this interview
I appeared for an interview in Jun 2024.
Easy SQL questions related to sub query
SQL moderate questions related to joins and window functions
(1 Question)
- Q1. Asked about specific tools related to requirement
Interview Preparation Tips
Sai Shreyas B.K
I appeared for an interview in Aug 2024.
The sql questions were hard
Basic aptitude questions, statics, probability etc
(2 Questions)
- Q1. Where do you live in the USA
- Ans.
I live in New York City, the bustling metropolis known for its iconic landmarks and diverse culture.
I reside in the heart of Manhattan, surrounded by towering skyscrapers.
New York City is home to famous attractions like Times Square, Central Park, and the Statue of Liberty.
The city offers a vibrant arts and entertainment scene, with Broadway shows and world-class museums.
I enjoy exploring the diverse neighborhoods and ...
- Q2. Where do you see yourself in 5 years
Interview Preparation Tips
Zifo RnD Solutions Interview FAQs
Tell us how to improve this page.
Zifo RnD Solutions Interviews By Designations
- Zifo RnD Solutions Associate Analyst Interview Questions
- Zifo RnD Solutions Analyst Interview Questions
- Zifo RnD Solutions Programmer Analyst Interview Questions
- Zifo RnD Solutions Data Analyst Interview Questions
- Zifo RnD Solutions Trainee Interview Questions
- Zifo RnD Solutions Research Analyst Interview Questions
- Zifo RnD Solutions Associate Data Analyst Interview Questions
- Zifo RnD Solutions Project Trainee Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 2 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
|
Associate Analyst
228
salaries
|  ₹3.8 L/yr - ₹5 L/yr |
|
Programmer Analyst
78
salaries
| ₹4.9 L/yr - ₹9.6 L/yr |
|
Research Analyst
45
salaries
| ₹4.5 L/yr - ₹9.2 L/yr |
|
Senior Programmer Analyst
35
salaries
| ₹8 L/yr - ₹13.8 L/yr |
|
Validation Analyst
28
salaries
| ₹5 L/yr - ₹9.2 L/yr |
JoulestoWatts Business Solutions
Value Point Systems
Saama Technologies
Systems Plus
- Home >
- Interviews >
- Zifo RnD Solutions Interview Questions
