AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
FirstCry Data Analyst Interview Questions and Answers for Experienced
FirstCry Data Analyst Interview Experiences for Experienced
1 interview found
Anonymous
I applied via Recruitment Consultant and was interviewed in Jan 2021. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. Why do you want to leave your current organization
Interview questions from similar companies
Snigdha Dhupal
I applied via Job Portal
SQL and Python data analysis questions
(1 Question)
- Q1. How do you match the data in different columns.
- Ans.
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
Use string matching techniques like exact match, partial match, or fuzzy matching.
Apply data cleaning and preprocessing techniques to standardize the data before matching.
Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.
Consider using database join...
Selected
I applied via Job Portal and was interviewed in Feb 2024. There was 1 interview round.
(3 Questions)
- Q1. Excel based questions in , vlookup, xlookup, index , match
- Q2. SQL questions using queries based on concepts like subqueries, CTE & windows functions
- Q3. Scenerio-based question, table 1 & table 2 with 5 & 3 liter if water, assuming the flow of water is unlimited & we need to get 4 liter of it
I applied via Campus Placement and was interviewed in Nov 2024. There were 4 interview rounds.
Questions from arrays and strings and some aptitude questions
(2 Questions)
- Q1. How to merge 2 csv files
- Ans.
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
Open both CSV files in a software like Microsoft Excel.
Copy the data from one CSV file and paste it into the other CSV file.
Save the merged CSV file with a new name.
Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
- Q2. Basic questions on arrays
(1 Question)
- Q1. 3 reasons why u choose this company
- Ans.
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.
Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.
Company culture - I value a positive work environment and the...
(1 Question)
- Q1. Questions on python
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
(1 Question)
- Q1. Basic details about work ex, reason to switch, salary expectations
2 SQL questions asked
Selected
I appeared for an interview before Oct 2023.
(2 Questions)
- Q1. Basic Excel, Regression, Anova model, CHAID model etc
- Q2. Previous experience
(2 Questions)
- Q1. SQL joins , previous experience
- Q2. Guesstimate, probability questions
I applied via Referral and was interviewed in Feb 2021. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Technical Questions (SQL and Python)
- Q2. Business case studies
Interview Preparation Tips
(2 Questions)
- Q1. Create the pivot table, sort the data in ascending order
- Ans.
Create a pivot table and sort the data in ascending order.
To create a pivot table, select the data range and go to the 'Insert' tab in Excel.
Choose 'PivotTable' and select the location for the pivot table.
Drag the desired fields to the 'Rows' and 'Values' areas.
To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.
- Q2. Use lookup with the product based given data and find the needed data
- Ans.
Using lookup with product-based data to find the needed data.
Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data
Identify the key or unique identifier to match the data
Specify the range or table where the data is located
Retrieve the desired data based on the lookup value
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Test was based on SQL, coding and MCQ. Coding involved nested query.
vinay kalikota
There are 2 coding challenges and 7 objective questions
(1 Question)
- Q1. Technical questions related to role
FirstCry Interview FAQs
Tell us how to improve this page.
FirstCry Interviews By Designations
- FirstCry Store Manager Interview Questions
- FirstCry Customer Relationship Officer Interview Questions
- FirstCry Sales Executive Interview Questions
- FirstCry Data Analyst Interview Questions
- FirstCry Assistant Manager Interview Questions
- FirstCry Software Developer Interview Questions
- FirstCry Area Operation Manager Interview Questions
- FirstCry Area Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
FirstCry Data Analyst Reviews and Ratings
based on 4 reviews
Rating in categories
|
Store Manager
373
salaries
|  ₹1.2 L/yr - ₹6.5 L/yr |
|
Software Developer
271
salaries
| ₹2.6 L/yr - ₹9.1 L/yr |
|
Purchase Executive
184
salaries
| ₹2.5 L/yr - ₹6 L/yr |
|
Assistant Manager
152
salaries
| ₹2 L/yr - ₹11 L/yr |
|
Sales Executive
137
salaries
| ₹0.8 L/yr - ₹9 L/yr |
Udaan
Swiggy
BlackBuck
Blinkit
- Home >
- Interviews >
- FirstCry Interview Questions >
- FirstCry Data Analyst Interview Questions for Experienced
