AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
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
Anonymous
I appeared for an interview before May 2021.
(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.
Round duration - 20 minutes
Round difficulty - Medium
It was a technical round
(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.
Interview Preparation Tips
Tip 1 : Practice guesstimates and puzzles.
Tip 2 : Do atleast 2 projects using various data sets.
Tip 1 : Do not put fake things on resume.
Tip 2 : A short and crisp description is good to have.
Business Analyst Interview Questions & Answers
Infosys Consulting
aniket agarwal
posted on 1 May 2021
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...
- Q2. Mongodb queries
- Q3. Excel queries
Interview Preparation Tips
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...
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
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.
Interview Questionnaire
1 Question
- Q1. About DS architecture
Interview Preparation Tips
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
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
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
Suraj Jain
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
- Q2. Asking about team work
Interview Preparation Tips
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 for Popular Designations
Interview Questions from Similar Companies
Water and Power Consultancy Services Reviews and Ratings
based on 4 reviews
Rating in categories
|
Civil Engineer
5
salaries
|  ₹2.7 L/yr - ₹4.4 L/yr |
|
Construction Engineer
3
salaries
| ₹3.2 L/yr - ₹4.8 L/yr |
Cummins
Mercer
Bharat Forge
AtkinsRealis
- Home >
- Interviews >
- Water and Power Consultancy Services Interview Questions
