AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
EpiFi
Compare
Filter interviews by
EpiFi Production Analyst Interview Questions and Answers for Experienced
EpiFi Production Analyst Interview Experiences for Experienced
1 interview found
Shantanu Saxena
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
Basic Intro followed by SQL test. Worst part is that SQL test was on Notepad with poorly drafted questions. The interview was outsourced to Curatal who had very poor management, the interviewer did not turn camera on and had no information about the job profile.
Top trending discussions
Interview questions from similar companies
Anonymous
(2 Questions)
- Q1. Case Study of zomato ?
- Q2. Some basic math questions. Simultaneous equations .
Interview Preparation Tips
Selected
I was interviewed in Sep 2024.
(2 Questions)
- Q1. Tell me brief about your self
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets using SQL, Python, and R
Skilled in creating insightful reports and dashboards using Tableau and Power BI
Strong communication skills to present findings to stakeholders
Certified in data analysis and machine learning techniques
- Q2. What are youre strenth and weekness
- Ans.
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
Strength: Strong analytical skills
Strength: Attention to detail
Weakness: Getting caught up in details (provide example)
Interview Preparation Tips
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There was 1 interview round.
Aptitude tests + 3 Rounds
Interview Preparation Tips
1. The First Round was a basic guesstimate round.
2. The Second Round was a feature Discussion round about the Netflix search bar.
3. The final round was a mix of a Case Breakdown + HR + Questions about Groww.
Selected
I applied via Referral and was interviewed in Sep 2022. There were 4 interview rounds.
First round of test consisted of sql questions , medium and easy level
(1 Question)
- Q1. Mostly sql questions like cumulative sum
(1 Question)
- Q1. This interview was more focused on the decision making in different scenarios
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Aug 2023. There were 3 interview rounds.
Sql mainly windows function aggregate function
How would you imprpve netflix recommendation system.
(1 Question)
- Q1. Some stat question
I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. Joins, SQL query execution
- Q2. Simple Sals Question - SQL
(2 Questions)
- Q1. Questions based on the understanding of joins in sql
- Q2. Convert row to columns using sql
- Ans.
Use SQL pivot function to convert rows to columns
Use the PIVOT function in SQL to convert rows into columns
Specify the columns you want to pivot on and the values you want to display in the new columns
Example: SELECT * FROM table_name PIVOT (MAX(value_column) FOR pivot_column IN (column1, column2, column3)) AS alias_name
Skills evaluated in this interview
Interview Preparation Tips
Experience: I got shortlisted for Capital One but could not make through the interview comprising mainly of number crunching questions. Later, I interviewed with Flipkart and got selected.
General Tips: 1. I was inclined in clearing CAT from my second year onwards.
2. I did a summer project in the second year and simultaneously joined Career Launcher.
3. I didn’t prepared much for the placements and was only focussed on CAT preparations during the seventh semester.
4. I did not give as much time in resume building as given by mates since I knew that I have nothing to mention about except my CPI.
5. CAT preparations helped me strengthen my aptitude and quant skills.
6. I was able to clear the tests of various companies just with my CAT knowledge.
7. I practised maths for entire month and was pretty confident in English and a week before the main exam, I did one or two mock papers daily.
College Name: IIT KANPUR
Interview Questionnaire
3 Questions
- Q1. A situation where you had to take expertise from someone and why?
- Ans.
Yes
I had to take expertise from a senior analyst to understand a complex financial model.
I sought guidance from a subject matter expert to interpret a new regulatory requirement.
I collaborated with a data scientist to analyze and interpret a large dataset.
I consulted with a software engineer to troubleshoot a technical issue in a data analysis tool.
- Q2. A situation where you were not able to meet the deadline of your work and finally what was the response you got for your work?
- Ans.
I missed a deadline due to unexpected complications, but received understanding and support from my team.
I was working on a project with a tight deadline
Unexpected complications arose that delayed my progress
I communicated the situation to my team and asked for an extension
My team was understanding and supportive, and we worked together to adjust the timeline
- Q3. A situation where you had to do a thing which you had no prior knowledge about and what was the result?
Interview Preparation Tips
Experience: The questions were related to Data Interpretation. I felt severe time constraint in the paper.
Tips: Selectivity among the questions proved beneficial in clearing the cut-off.
Duration: 60 minutes
Total Questions: 30
Round: Case Study Interview
Experience: Preliminary(Long before Placement Season)
It was a 10-minute one on one interview. They had given the link for few practice case-studies. The Case Study given at their website is the most important one. It helps you understand the standard approach they look for in a candidate.
Round: Case Study Interview
Experience: This was a 50-minute interview during the placement season.
Round: Case Study Interview
Experience: This was a 20-minute interview. It was a case interview similar to the first one.
Round: HR Interview
Experience: It was a behavioral Interview.
Tips: Questions were expected to be answered in detail.
College Name: IIT KANPUR
EpiFi Interview FAQs
Tell us how to improve this page.
EpiFi Interviews By Designations
Interview Questions for Popular Designations
- Production Engineer Interview Questions
- Production Supervisor Interview Questions
- Production Manager Interview Questions
- Production Officer Interview Questions
- Executive Production Interview Questions
- Production Interview Questions
- Senior Production Engineer Interview Questions
- Production Graduate Engineer Trainee Interview Questions
- Show more
EpiFi Production Analyst Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Software Engineer
22
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Risk Analyst
14
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Risk Operations Analyst
9
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Paytm
PhonePe
Mobikwik
Payed
- Home >
- Interviews >
- EpiFi Interview Questions >
- EpiFi Production Analyst Interview Questions for Experienced
