Upload Button Icon Add office photos

Filter interviews by

ElectrifAi Analytics Specialist Interview Questions and Answers

Updated 31 Aug 2015

ElectrifAi Analytics Specialist Interview Experiences

1 interview found

Interview Preparation Tips

Round: Test
Experience: The test had two parts, the first part consisted of 20 objective aptitude questions and the second part had 5 subjective questions, which were of moderate level of difficulty. 30 people were shortlisted for the final round of interviews.

Round: technical interview
Experience: The first interview was mostly related to my resume and the projects related to statistics that I had done during internships. He also asked me some questions related to regression analysis followed by a simple puzzle.

Round: Puzzle Interview
Experience: The second interviewer asked me two- three puzzles and then we had some discussion related to my interest in data science.

Round: case study interview
Experience: In third interview he asked me two puzzles followed by a case. The interviewer was very helpful and he only wanted to see my approach.


Round: technical interview
Experience: The final interview was a telephonic interview with a senior analyst. He asked me some questions on my internship projects. I was also asked a guess estimate problem.

General Tips: Do’s and Don’ts :

Concentrate on at most two sectors because it is very difficult to prepare for more than two sectors. Also, do not write anything which you are not sure about in your resume because you may feel that it would be helpful for getting shortlisted but considering that your resume would drive your interviews so it is very necessary that you are confident about the things in your resume. Placement Experience (write in different section for different companies)


Final Tips :
Start preparation as early as you can. Decide what kind of work you would like to do and then decide what sectors you want to prepare for. Be in touch with the seniors who are working in the firms that you are targeting. Their advice would be very helpful. Also do some mock interviews in wing or attend the workshops conducted by SPO.

College Name: IIT Kanpur

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
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.

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
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 Recruitment Consultant and was interviewed in Feb 2021. There were 2 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Very basic question i.e give me your brief introduction, where do you see yourself in next 2years? Tell me something about previous job. What was your responsibility there?
  • Q2. And toughest part of interview was that with regional head (yes bank) he was asking to me that why you choose the same designation which you hold from last one and half years?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident. If you don't know the exact or correct answer to any of the question asked by HR. You not need to scare so much. Just simply say "i don't know " No one can judge you by this.

Power BI Developer Interview Questions & Answers

Dilyt user image chittiboyina padmasree

posted on 8 Jul 2021

Interview Questionnaire 

1 Question

  • Q1. All about power bi

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 Specialist Reviews and Ratings

based on 2 reviews

1.0/5

Rating in categories

1.7

Skill development

3.6

Work-life balance

2.3

Salary

1.7

Job security

3.6

Company culture

1.0

Promotions

3.6

Work satisfaction

Explore 2 Reviews and Ratings
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