Upload Button Icon Add office photos

Filter interviews by

Water and Power Consultancy Services Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

I appeared for an interview before May 2021.

Round 1 - Coding Test 

(1 Question)

Round duration - 120 Minutes
Round difficulty - Medium

It had multiple reasoning, aptitude questions, pseudo codes and there was one guesstimate and an essay.

  • Q1. What is your guesstimate on how many people use mobile phones in India?
  • Ans. 

    It is estimated that over 800 million people use mobile phones in India.

    • India has a population of over 1.3 billion people.

    • The mobile phone penetration rate in India is around 80%.

    • Majority of the population use mobile phones for communication, internet access, and entertainment.

    • The number of mobile phone users in India is constantly increasing due to affordable smartphones and data plans.

  • Answered by AI
Round 2 - Face to Face 

Round duration - 20 minutes
Round difficulty - Medium

It was a technical round

Round 3 - Face to Face 

(1 Question)

Round duration - 25 minutes
Round difficulty - Medium

Programming Questions were asked

  • Q1. How do you change the data type and push the data into a database?
  • Ans. 

    To change data type and push data into a database, use data conversion functions and SQL queries.

    • Use data conversion functions like CAST or CONVERT to change data type before pushing into the database.

    • Write SQL INSERT or UPDATE queries to push the data into the database.

    • Ensure the data being pushed matches the data type of the database column to avoid errors.

  • Answered by AI

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Analyst in BengaluruEligibility criteria6.5 CGPATredence Analytics interview preparation:Topics to prepare for the interview - Object oriented programming- Python, DS & Algorithms, SQL, Excel, SparkTime required to prepare for the interview - 2 monthsInterview preparation tips for other job seekers

Tip 1 : Practice guesstimates and puzzles.
Tip 2 : Do atleast 2 projects using various data sets.

Application resume tips for other job seekers

Tip 1 : Do not put fake things on resume.
Tip 2 : A short and crisp description is good to have.

Final outcome of the interviewSelected

I applied via Indeed and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Know sql baaoc queriz
  • Ans. 

    SQL basics involve understanding queries, data manipulation, and database management concepts essential for business analysis.

    • SQL stands for Structured Query Language, used for managing and manipulating databases.

    • Basic SQL commands include SELECT, INSERT, UPDATE, DELETE.

    • Example of a SELECT query: SELECT * FROM customers WHERE age > 30;

    • JOIN operations allow combining rows from two or more tables based on related colu...

  • Answered by AI
  • Q2. Mongodb queries
  • Q3. Excel queries

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics of sql , java mongo rdmbs

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed before Apr 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Overall work experience
  • Ans. 

    I have over five years of experience in data analysis, focusing on transforming data into actionable insights for business growth.

    • Worked at XYZ Corp, where I analyzed sales data to identify trends, leading to a 15% increase in quarterly revenue.

    • Utilized SQL and Python for data extraction and manipulation, improving reporting efficiency by 30%.

    • Collaborated with cross-functional teams to develop dashboards that visualize...

  • Answered by AI

Interview Questionnaire 

2 Questions

  • Q1. Three round. Each had one market sizing case study.
  • Q2. Layout of your approach is most important. Clearly communicating thoughts, making the interview interactive are key points for any management consulting interview. You dont need an absolute answer. What ma...

Associate Interview Questions & Answers

Infosys Consulting user image Uttayam Bhattacharya

posted on 2 May 2021

Interview Questionnaire 

1 Question

  • Q1. What is your hobby
  • Ans. 

    My hobby is photography.

    • I enjoy capturing moments and expressing my creativity through photography.

    • I love experimenting with different angles, lighting, and compositions.

    • Photography allows me to explore and appreciate the beauty in everyday life.

    • I often take photos of landscapes, portraits, and events.

    • I also enjoy editing and enhancing my photos to create stunning visuals.

  • Answered by AI

Interview Questionnaire 

1 Question

  • Q1. About DS architecture

Interview Preparation Tips

Round: Resume Shortlist
Experience: I consulted my seniors for preparation of my resume. I believe that seniors provide the best provide you with the best possible insights in this regards.

Round: Test
Experience: The first round was the written test. The duration of the test was half an hour. The test consisted of questions on data interpretation, logical reasoning and analytics. The questions were pretty easy. The company shortlisted a lot of candidates for the Group Discussion (GD).

Round: HR Interview
Experience: The interview was, as I would call it, an HR and a puzzle based interview. Some questions from probability were also asked. The puzzles asked were tricky but easy at the same time. I cannot recall any of the puzzles that were asked.
Tips: Before appearing for the interview, I would suggest you to solve puzzles from a book named ‘Out of the Box’; the book contains some really good puzzles.

College Name: IIT ROORKEE

Interview Preparation Tips

Round: Test
Experience: The written test had various sections. After the written test which was held online, few students were shortlisted for the interview process. There were a total of three rounds of interviews.

Round: HR Interview
Experience: The questions asked from all the candidates in all the rounds were quite similar in nature. They were asking puzzles, numerical reasoning based questions and things which would require use of your analytical skills. The questions weren’t difficult and one can easily find them on placement preparation sites. They also tested me on my knowledge of core engineering subjects to ascertain whether I am serious about the tasks I have in hand.

They also asked few normal HR questions. Some of them were about my short term and long term goals and where do I see myself after three years. They also asked me the reason for shift to a non-core field company.

College Name: IIT ROORKEE
Motivation: I had appeared for the placement process for Mu Sigma as arranged by the placement committee of my college. There was no resume based selection and neither there was any group activity. The major criterion for being able to appear for the written test was the CGPA.

Interview Preparation Tips

Round: Test
Experience: Half an hour test which had 5 C questions, 10 math and 10 on simple English.
Duration: 30 minutes

Round: Puzzle Interview
Experience: Preliminary Round: One Puzzle and a question on probability, I Couldn't answer that puzzle so I started talking about my internship in a great detail and this helped me to get to the next round.

General Tips: It will be of great help if you can solve simple mathematics problems with speed - CAT type.
Skill Tips: Make Sure you do all the common puzzles before you go to interview, E.g 100 gold coin/pirate one which keep repeating.
College Name: NIT SURATHKAL

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a business analyst with experience in data analysis and project management.

    • Experienced in data analysis and project management

    • Proficient in using tools like Excel, SQL, and Tableau

    • Skilled in identifying business problems and providing solutions

    • Excellent communication and presentation skills

    • Worked with cross-functional teams to achieve project goals

  • Answered by AI
  • Q2. Asking about team work

Interview Preparation Tips

Round: Test
Experience: Accuracy required
Tips: Easy just need more speed in calculations
Duration: 20 minutes
Total Questions: 15

Round: Problem Statement
Experience: Strategies required for buisness , simple coding
Tips: Strategies required for buisness , simple coding

Round: Group Discussion
Experience: A video round followed by GD will be conducted
Tips: Video round may have clips from films like pursuit of happiness and you have to write about video

Skills: Communication , Team work, Stress handling
College Name: SATHYABAMA UNIVERSITY
Motivation: No need to prepare much being cool and self confident is enough

Tell us how to improve this page.

Interview Questions from Similar Companies

Cummins Interview Questions
4.3
 • 252 Interviews
Mu Sigma Interview Questions
2.6
 • 240 Interviews
BCG Interview Questions
3.7
 • 203 Interviews
Tredence Interview Questions
3.5
 • 137 Interviews
GEP Worldwide Interview Questions
3.6
 • 137 Interviews
Apco Infratech Interview Questions
3.7
 • 122 Interviews
Xceedance Interview Questions
3.6
 • 113 Interviews
Bain & Company Interview Questions
3.9
 • 111 Interviews
View all

Water and Power Consultancy Services Reviews and Ratings

based on 4 reviews

4.8/5

Rating in categories

4.9

Skill development

4.8

Work-life balance

4.9

Salary

4.5

Job security

4.7

Company culture

4.9

Promotions

4.9

Work satisfaction

Explore 4 Reviews and Ratings
Compare Water and Power Consultancy Services with

Cummins

4.3
Compare

Mercer

3.6
Compare

Bharat Forge

3.9
Compare

AtkinsRealis

3.9
Compare
write
Share an Interview