Upload Button Icon Add office photos

Filter interviews by

Clear (1)

ElectrifAi Consultant Interview Questions and Answers

Updated 16 Feb 2015

ElectrifAi Consultant Interview Experiences

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 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 .
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Feb 2023. There were 4 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Questions related to Pharma domain about patient/hcp activity table, HIT targeting project end to end implementation, raw data cleaning and filtering etc.
  • Q2. Basic SQL question based on a sample data given which will be used as a backend for a visualisation
Round 2 - Coding Test 

6-8 questions on SQL and Python

Round 3 - One-on-one 

(1 Question)

  • Q1. An overview on all the projects I have worked on and my knowledge on domain
Round 4 - HR 

(3 Questions)

  • Q1. Strength and Weakness
  • Q2. Reason to switch
  • Ans. 

    Seeking new challenges and opportunities for growth

    • Desire to work on more diverse projects

    • Opportunity for career advancement

    • Seeking a better work-life balance

    • Interested in learning new skills or technologies

  • Answered by AI
  • Q3. Negotiations on salary

Interview Preparation Tips

Topics to prepare for Fractal Analytics Consultant interview:
  • SQL
  • Python
  • Pandas
  • Pharma
Interview preparation tips for other job seekers - Please be thorough with the profile you are applying for and the domain in which you have relevant experience.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed before Mar 2023.

Round 1 - One-on-one 

(1 Question)

  • Q1. More about what you have been doing in past role
Round 2 - One-on-one 

(1 Question)

  • Q1. How much you know about fractal
  • Ans. 

    Fractals are complex geometric shapes that can be split into parts, each of which is a reduced-scale copy of the whole.

    • Fractals exhibit self-similarity, meaning they look similar at any scale or magnification.

    • Examples of fractals include the Mandelbrot set, Koch snowflake, and Sierpinski triangle.

    • Fractals are used in various fields such as mathematics, computer graphics, and art.

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. To check culture fit with the org
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL and Python basic questions

Round 2 - Technical 

(2 Questions)

  • Q1. Problem solving questions
  • Q2. SQL query on 2nd largest
  • Ans. 

    Use a subquery to find the 2nd largest value in a SQL table.

    • Use a subquery to find the maximum value in the table

    • Exclude the maximum value from the results to find the 2nd largest value

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Culture fit questions

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Coding Test 

It was decent round.

Round 2 - One-on-one 

(1 Question)

  • Q1. Good one on one round with details of past project
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What are the scopes of GA3
  • Ans. 

    GA3 is a plant hormone that regulates various growth processes in plants.

    • Regulates seed germination

    • Promotes stem elongation

    • Influences flowering and fruit development

    • Used in agriculture to increase crop yield

    • Can be applied externally to plants to induce growth responses

  • Answered by AI
  • Q2. What is a data layer
  • Ans. 

    A data layer is a software component that separates the data access logic from the business logic in an application.

    • It acts as an intermediary between the database and the application's business logic

    • Helps in managing data access, storage, and retrieval

    • Improves scalability and maintainability of the application

    • Examples include ORM frameworks like Hibernate in Java or Entity Framework in .NET

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Salary negotiation
  • Q2. What is your notice period

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Arrange the number is fibonacci series

Round 2 - Assignment 

Discussion on Supply chain demand and production planning

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Write SQL queries for given scenario
  • Ans. 

    Writing SQL queries for a given scenario

    • Use SELECT statement to retrieve data from tables

    • Use WHERE clause to filter data based on specific conditions

    • Use JOIN clause to combine data from multiple tables

  • Answered by AI
  • Q2. Simple queries initially, sub queries and CTEs will be touched in later part, window functions and extensive usage of joins will also be checked
  • Q3. Test test test test?
Round 2 - One-on-one 

(2 Questions)

  • Q1. Engagement manager round will have a case study
  • Q2. Mostly case study related to some of the practice will be asked, mostly CPG

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL very imp, python imp, any dashboarding tool knowledge required all in all

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Recently Viewed

INTERVIEWS

Qualcomm

No Interviews

INTERVIEWS

Blue Yonder

No Interviews

INTERVIEWS

Qualcomm

No Interviews

DESIGNATION

SALARIES

Blue Yonder

INTERVIEWS

Qualcomm

No Interviews

INTERVIEWS

Daimler Truck

No Interviews

INTERVIEWS

Blue Yonder

40 top interview questions

SALARIES

Brillio

INTERVIEWS

TechnipFMC

No Interviews

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