Upload Button Icon Add office photos

Filter interviews by

ElectrifAi Consultant Interview Questions and Answers for Freshers

Updated 16 Feb 2015

ElectrifAi Consultant Interview Experiences for Freshers

1 interview found

Consultant Interview Questions & Answers

user image Anonymous

posted on 16 Feb 2015

Interview Preparation Tips

Round: Resume Shortlist
Experience: I started preparing my resume somewhere around August end. I spoke to a few seniors about it and read quite a few resumes, especially of those seniors who either had a profile similar to mine or had secured jobs in fields of my interest, eg. Consulting, finance, etc. I also attended the Resume Writing Workshop conducted by McKinsey and Co. on campus and cleared a few doubts there.
Tips: I would advise you guys to start preparing your resumes well in advance, it is not something to be kept for the last minute. Being the first form of acquaintance between you and a firm, it is a highly important document and the way you highlight your strong points and attributes can go a long way in shortlisting you from amongst the hundreds of resumes that they have to scan. Also, it is important that you be able to speak on any point in your resume in detail, hence you must be sure of what you are writing in it.

Round: Case Study Interview
Experience: The procedure of selection for Opera Solutions was a set of 4 interviews, each having a case study and some HR questions. The initial shortlist had around 22 candidates, after the first 2 interviews around 10 candidates were selected for the final rounds. Finally 3 candidates were made offers.  There were no GDs, only case interviews. The first interview had a case involving a music company which scouts for amateur talent and launches them. They want to enter India and want you to analyse the market and suggest if its feasible or not. The interviewer gave a lot of data related to market share of pop music, bollywood, devotional music, etc and it suggested that the market share of the genre related to the company is very little. However I think what worked best was that I also pointed out certain solutions which could make it feasible, such as merging with another company in a genre where the given company has core competencies in. I think this was the high point of the interview which I atleast would like to believe compensated for a later interview that I did not do well in. Another interview had a case where a pharmaceutical company in the US wants to enter India. A set of constraints and data was given and I was asked to calculate if it should actually setup a manufacturing facility in India or manufacture in the US and transport to India. I did not do well in this one, I wasn’t being able to come up with a figure. Both the interviews had an HR component where I was asked about my strengths and weaknesses, about Mood Indigo and my academic record. I was asked to describe myself. I was also asked to talk about my co-intern’s project in ITC (she was also interviewing with Opera). In a subsequent interview after the shortlist, I was asked to estimate the market for Maruti cars, domestic air travel. They weren't expecting too much detail, the interviewer was more interested in the approach. point.
Tips: I attended most of the initial PPTs. One does get a good understanding of what a firm does and where exactly do you fit into it, you also understand what they are looking for and what is the extent of their operations. I must admit though that I found my interaction with seniors, especially those working in those firms was more informative and fruitful. They can give clarity in certain grey areas that companies might stay non-committal on.ending across links/documents would help us compile a single point resource) . I prepared for case studies from the material I took from seniors, most of which is available on the LAN. For case studies I prepared with a friend and sometimes in groups of 3. I think this method is better than individual preparation because the other person can point out where you are going wrong, you get a different perspective and at the same time you can prepare in a fashion where one interviews the other and vice versa, so you get slightly comfortable with how an actual interview might feel like. It is however important to ensure that the person you are preparing with is competent and complementary to your skill sets, so that you can improve upon aspects where you might be lacking in.

General Tips: Case studies and HR questions. One should be very comfortable with points mentioned in the resume and should be able to talk at length about any . I guess it'd just be shifting a little from being myself if you know what I mean. A lot of seniors would give you a lot of fundae, but at the end one must remember that unless one is comfortable with a certain way of speaking or certain method of solving cases, it wont look genuine. For example, one need not thrash out every single detail of a case before beginning to solve it, sometimes the interviewer might get impatient or might think you are trying to buy time to think by asking unnecessary details. So if you are the kind of a person who can intuitively draw good conclusions at the outset so as to decide which direction to proceed in and hence which questions to ask, you can surely go ahead and do that, you need not also ask questions that you know are not required. Case interviews are very feel-good interviews, even if you make a mistake you will be guided back on track by the interviewer, hence I personally would recommend that you stick more to your general approach to solving cases (if you know it is a good one and works of course) and not try to change too much just because a certain senior did it in a different way.
College Name: IIT BOMBAY

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Aug 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Decision tree, random forest, regressions, classification metrics

Interview Preparation Tips

Interview preparation tips for other job seekers - Very nice experience, warm and welcoming people.

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

I applied via Recruitment Consultant and was interviewed in Sep 2021. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Explain briefly the work and responsibilities in ur previous company
  • Ans. 

    In my previous company, I worked as a Consultant where I provided expert advice and solutions to clients.

    • Analyzed client's business processes and identified areas for improvement

    • Developed and implemented strategies to optimize client's operations

    • Conducted market research and competitor analysis to identify market trends

    • Provided recommendations and solutions to clients based on data analysis

    • Collaborated with cross-funct...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick to basics and dont fake about ur work

I applied via Referral and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic SQL questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through fundamental of SQL , how null behaves with all joins, Cte and other objects .

I applied via Naukri.com and was interviewed before Oct 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Basic of python and it related questions
  • Q2. Python API and it's applications
  • Ans. 

    Python API is a set of protocols and tools for building software applications in Python.

    • Python API allows developers to access and manipulate data from external sources.

    • It can be used to create web applications, automate tasks, and build machine learning models.

    • Popular Python APIs include Flask, Django, and NumPy.

    • Python API can also be used for data visualization and analysis with libraries like Matplotlib and Pandas.

  • Answered by AI
Round 3 - Technical 

(2 Questions)

  • Q1. Basics of python and it's related questions
  • Q2. Python API and it's related questions

Interview Preparation Tips

Interview preparation tips for other job seekers - This in one of the best place to work for Analytics

Skills evaluated in this interview

Round 1 - Technical 

(1 Question)

  • Q1. Python,project questions
Round 2 - Case Study 

Case study

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up your project well. Get your technical skills done.

I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Online coding test. Basic questions on sql and python

Round 2 - Technical 

(1 Question)

  • Q1. Question on analytics and past work experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice basic skill. Go through your resume
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL Window functions
  • Q2. Tableau LOD functions
Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Question based on SQL and Pyspark SQL scripts, Project discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Just need to work on basics and some scenario based question need to practice that will work

Tell us how to improve this page.

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
Tredence Interview Questions
3.6
 • 123 Interviews
CGS Interview Questions
3.6
 • 25 Interviews
AbsolutData Interview Questions
3.6
 • 9 Interviews
Algonomy Interview Questions
4.0
 • 9 Interviews
View all
Project Analyst
21 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
15 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer Level 1
8 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
7 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Project Analyst 2
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ElectrifAi with

Mu Sigma

2.6
Compare

Fractal Analytics

4.0
Compare

Tiger Analytics

3.7
Compare

LatentView Analytics

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview