Upload Button Icon Add office photos

Filter interviews by

ElectrifAi Analytics Engineer Interview Questions, Process, and Tips

Updated 31 Jan 2017

ElectrifAi Analytics Engineer Interview Experiences

1 interview found

Analytics Engineer Interview Questions & Answers

user image Tanmay Tushar

posted on 22 Jan 2017

I appeared for an interview in Aug 2016.

Interview Questionnaire 

9 Questions

  • Q1. A probabililty question
  • Q2. Cement Industry in India
  • Ans. 

    The cement industry in India is a major contributor to the country's economy and infrastructure development.

    • India is the second-largest cement producer in the world, with a capacity of over 500 million tonnes per annum.

    • The industry is dominated by a few major players, including UltraTech Cement, ACC Limited, and Ambuja Cements.

    • Cement consumption in India is driven by the housing sector, infrastructure projects, and ind...

  • Answered by AI
  • Q3. The Three Door Puzzle
  • Q4. General HR questions
  • Q5. One probability question
  • Q6. Coin on a Round Table puzzle
  • Q7. Guess the number of people watching a particular movie show in the United Kingdom
  • Ans. 

    It is impossible to accurately guess the number of people watching a particular movie show in the United Kingdom.

    • The number of people watching a movie show can vary greatly depending on various factors such as the popularity of the movie, the time of day, the day of the week, and the location of the theater.

    • To estimate the number of people watching a movie show, one would need access to data from ticket sales, theater ...

  • Answered by AI
  • Q8. What is the 10 digit number a[0]a[1]a[2]a[3]a[4]a[5]a[6]a[7]a[8]a[9] in which i occurs a[i] times?
  • Ans. 

    The 10-digit number in which i occurs a[i] times is 6210001000.

    • The number has 6 zeros because i=0 occurs 6 times.

    • The number has 2 ones because i=1 occurs 2 times.

    • The number has 1 two because i=2 occurs 1 time.

    • The number has 0 threes because i=3 occurs 0 times.

    • The number has 0 fours because i=4 occurs 0 times.

    • The number has 0 fives because i=5 occurs 0 times.

    • The number has 1 six because i=6 occurs 1 time.

    • The number has ...

  • Answered by AI
  • Q9. There are 100 tablets (each weighing exactly same except for one). You have to find out the correct medicine by using a weighing machine but the catch is each time you weigh, it costs you 1 billion, How wi...

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resumes of the interested students were sent to the company and then they shortlisted the students for the written round.
Tips: Your resume should be at most two pages long and should contain everything about you but it must be to the point. You must be thorough with every line that is written in your resume. It's just a basic criteria which is generally met by everybody.

Round: Test
Experience: The paper consisted of objective aptitude questions. The main area of focus should be probability and combinatorics since it requires more practice than the rest of the topics.
Tips: You should brush up your aptitude skills because every company that you sit in for has a section of it in the written or online test. You must not neglect it in any cost. Although the basic aptitude skill of every student is good, but what matters during the test is the speed and accuracy and that only comes with practice. The higher the marks you get in this section, the better are your chances to score higher than your fellow peers. Although the marks in the test are not the sole criteria for the result, but it does play an important role in your selection.
Duration: 1 hour 30 minutes
Total Questions: 45

Round: Guesstimate Interview
Experience: This was the first round of four interviews that I altogether faced. The above three questions were asked to me serially. But before that, I had been asked to give a brief introduction of me. I had solved all three of them. The first question didn't take much time. Since I am not that interested in solving puzzles, I took some time in solving the second question but eventually I did it. The third question is a guesstimate. I started solving it with the inputs being given by the interviewer and I moved closer and closer to a realistic range as per the data inputs that were given to me.
Tips: The practice that I did for aptitude helped me in solving the first question. That's why putting in a little effort in improving your aptitude skills will ultimately help you. The puzzle questions can be found on the internet and you just have to go through them once. After a while, you will be well acquainted with them and you won't face any problem in solving them. And for the guesstimate, the best option you have is Google. Surf the internet and you will get loads of them and how to approach them. They are the questions that are used to check how you approach a problem.

Round: Puzzle Interview
Experience: This was my second round in which I was asked only two question and both were puzzles. I could answer both but my approach in the second question was wrong first. The interviewer made me clear and then asked me to answer. After the questions, we had a conversation on my doubts regarding the work and the company.
Tips: The puzzles as I already said can be practiced from the internet. But the most important point is you need to clearly understand the question before answering them. The second question was a conventional one but with a twist, which actually checks how attentive you are. So you need to hear and understand the questions properly. In case you do not understand in the first go, ask your interviewer to pardon again.

Round: Case Study Interview
Experience: The third interview consisted of a simple probability question and a case study. The case was a Cement Company in India that was losing its market share and I had to describe the reasons considering the constraints were given to me.
Tips: You can easily get the examples of case study problems along with the ways of solving them, on the internet. The most important thing is you need to think out of the box of all the possibilities to analyze the case from an unconventional domain.

Round: HR Interview
Experience: This round was taken by two persons simultaneously. There was one puzzle asked and the rest of the interview went on with general HR questions and answers.
Tips: HR rounds are the easiest of all in the interviews of technical companies. You only need to prove what you say. There must be no contrast in what you speak and what you think at that point of time. At no instance of the interview you must contradict yourself.

College Name: NIT ALLAHABAD

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

Quantitative Aptitude

Round 2 - Group Discussion 

Stakeholders vs Shareholders

Round 3 - Assignment 

Analysis of financial time series

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

I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

(1 Question)

  • Q1. Basic mathematics question, basic English and SQL questions
Round 2 - Technical 

(5 Questions)

  • Q1. Resume based questions
  • Q2. Different types of commands
  • Ans. 

    Different types of commands include data manipulation, data definition, data control, and transaction control commands.

    • Data manipulation commands: SELECT, INSERT, UPDATE, DELETE

    • Data definition commands: CREATE, ALTER, DROP

    • Data control commands: GRANT, REVOKE

    • Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT

  • Answered by AI
  • Q3. Difference between inner join and outer join
  • Ans. 

    Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.

    • Inner join only includes rows that have matching values in both tables

    • Outer join includes all rows from both tables, filling in missing values with NULL if there is no match

    • Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id; Outer join - SELECT * FROM table1 LEFT OUTER JOI

  • Answered by AI
  • Q4. Write SQL query to get second highest salary
  • Ans. 

    SQL query to retrieve the second highest salary from a table

    • Use the ORDER BY clause to sort salaries in descending order

    • Use the LIMIT clause to retrieve the second row

  • Answered by AI
  • Q5. What's the difference between numpy and pandas
  • Ans. 

    Numpy is a library for numerical operations in Python, while Pandas is used for data manipulation and analysis.

    • Numpy is used for numerical operations like linear algebra, Fourier transform, etc.

    • Pandas is used for data manipulation tasks like data cleaning, merging, reshaping, etc.

    • Numpy works with arrays, while Pandas works with dataframes.

    • Numpy is more efficient for numerical computations, while Pandas is more user-fri...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Dilyt Data Analyst interview:
  • SQL
  • Python

Skills evaluated in this interview

I applied via Walk-in and was interviewed in Mar 2022. There were 2 interview rounds.

Round 1 - Coding Test 

Employee model CRUD APIS USING SRPING BOOT & MYSQL

Round 2 - Technical 

(5 Questions)

  • Q1. TELL ME ABOUT YOUR SELF
  • Q2. SPRING BOOT VS SPRING
  • Ans. 

    Spring Boot is a framework that simplifies Spring development by providing pre-configured settings and dependencies.

    • Spring Boot is built on top of the Spring framework.

    • Spring Boot provides a standalone executable that can run the application.

    • Spring Boot provides auto-configuration, which reduces the need for manual configuration.

    • Spring Boot provides a wide range of starter dependencies that can be easily added to the p...

  • Answered by AI
  • Q3. JPA VS HIBERNATE WHAT IS ADVANTAGE USING JPA
  • Ans. 

    JPA is a specification while Hibernate is an implementation of JPA. JPA provides a standard API for ORM frameworks.

    • JPA is a standard API for ORM frameworks

    • JPA provides a vendor-neutral interface

    • JPA allows for easy switching between ORM frameworks

    • Hibernate is an implementation of JPA

    • Hibernate provides additional features beyond JPA

  • Answered by AI
  • Q4. WHTA IS MYSQL GROUP BY & DISTINCT
  • Ans. 

    MySQL GROUP BY is used to group rows with same values. DISTINCT is used to remove duplicate values from a column.

    • GROUP BY is used with aggregate functions like COUNT, SUM, AVG, etc.

    • DISTINCT is used to retrieve unique values from a column.

    • GROUP BY and DISTINCT can be used together to group and retrieve unique values.

    • Example: SELECT COUNT(*) FROM table_name GROUP BY column_name;

    • Example: SELECT DISTINCT column_name FROM t

  • Answered by AI
  • Q5. WHAT ARE SCOPES ARE AVAILABLE IN SPRING
  • Ans. 

    Spring has four scopes: Singleton, Prototype, Request, and Session.

    • Singleton scope creates a single instance of a bean.

    • Prototype scope creates a new instance of a bean every time it is requested.

    • Request scope creates a new instance of a bean for each HTTP request.

    • Session scope creates a new instance of a bean for each HTTP session.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for PruTech Solutions Software Engineer interview:
  • Java
  • Spring Boot
  • MySQL Database Administration
  • JPA
Interview preparation tips for other job seekers - GOOD ORGANIZATION FOR LEARNERS

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Aug 2022. 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 

(4 Questions)

  • Q1. Basic Technical Interview
  • Q2. Basics on Framework used
  • Q3. Infrastructure related
  • Q4. Process and security
Round 3 - HR 

(1 Question)

  • Q1. Salary expectations and negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview is average. Stick to basics and be confident
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-

I appeared for an interview in Nov 2022.

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 - Aptitude Test 

Strong appitude knowledge is required.

Round 3 - Technical 

(1 Question)

  • Q1. String , arrays, oops

Interview Preparation Tips

Interview preparation tips for other job seekers - Have strong basic concepts.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Strecture of sql statement
  • Ans. 

    SQL statements are used to interact with databases by performing operations like querying, updating, and deleting data.

    • SQL statements are made up of keywords like SELECT, INSERT, UPDATE, DELETE, etc.

    • They are structured in a specific order, with clauses like WHERE, ORDER BY, GROUP BY, etc.

    • Tables are referenced using their names, and conditions are specified to filter data.

    • Joins can be used to combine data from multiple

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Job Portal and was interviewed in Jan 2023. 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 - HR 

(1 Question)

  • Q1. More than technology,a senior recruiter asks where you stay which gali you stay,which temple is near by,what your husband do,getting into more personal and final he will ask your janam kundali and tell you...
Round 3 - One-on-one 

(1 Question)

  • Q1. Senior recruiter will ask more personal questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Girls and ladies please don't join this company as it is more into priest kinda,they check your caste,class rather your hardwork it seems. This so called senior recruiter totally flirts with you if you are single,divorce,seperarated and also heard his eyes rolls on always girls upper part,no matter whatever she is wearing. I heard after complaining also higher authorities didn't taken the action. Now you people only imagine how is it safe for a girl to work in that disgusting atmosphere. And in any MNC company if the complain is raised the higher authority should take an action but still they kept him then think what kinda company is this. INDIA HR cgs is worst the worst. They are not giving you secured job,HR are saving there job to close that position and you are bakra,who will be paid with very less salary comparative outside and also you are treated like a dog. Think twice thrice to take the decision.

Interview Questions & Answers

TriGeo Technologies user image Anonymous

posted on 27 Nov 2021

I applied via Company Website and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About GIS, and short cut keys of computer

Interview Preparation Tips

Interview preparation tips for other job seekers - U should be know about GIS before going to Interview

I applied via Walk-in and was interviewed before Dec 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Sample questions on autocad,that too very lite,
  • Q2. If u say any answer also they will accept you, because they need labours to work

Interview Preparation Tips

Interview preparation tips for other job seekers - advice is think twice and join in it, try to consult nearby hostel people before join,bcz alot are in hostel ,if u needy go ahead if not think

ElectrifAi Interview FAQs

What are the top questions asked in ElectrifAi Analytics Engineer interview?

Some of the top questions asked at the ElectrifAi Analytics Engineer interview -

  1. There are 100 tablets (each weighing exactly same except for one). You have to ...read more
  2. What is the 10 digit number a[0]a[1]a[2]a[3]a[4]a[5]a[6]a[7]a[8]a[9] in which i...read more
  3. Guess the number of people watching a particular movie show in the United Kingd...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

CGS Interview Questions
3.5
 • 25 Interviews
Dilyt Interview Questions
3.8
 • 8 Interviews
Unitedlayer Interview Questions
4.0
 • 5 Interviews
QNAP Systems Interview Questions
3.1
 • 4 Interviews
View all
ElectrifAi Analytics Engineer Salary
based on 6 salaries
₹6 L/yr - ₹11.7 L/yr
At par with the average Analytics Engineer Salary in India
View more details
Project Analyst
21 salaries
unlock blur

₹4 L/yr - ₹7.5 L/yr

Software Engineer
15 salaries
unlock blur

₹6 L/yr - ₹16 L/yr

Software Engineer Level 1
8 salaries
unlock blur

₹6 L/yr - ₹14 L/yr

Technical Lead
7 salaries
unlock blur

₹12 L/yr - ₹27 L/yr

Project Analyst 2
6 salaries
unlock blur

₹5 L/yr - ₹9.1 L/yr

Explore more salaries
Compare ElectrifAi with

Primus Global Technologies

3.9
Compare

TriGeo Technologies

3.2
Compare

Plada Infotech Services

3.6
Compare

Riddhi Corporate Services

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