Water and Power Consultancy Services Interview Questions and Answers

Q1. What's the CI/CD workflow that's followed in your team?
Ans. 
Our team follows a CI/CD workflow that includes automated testing, code reviews, and continuous integration.
• Automated testing is run on every code change to catch bugs early.

• Code reviews are conducted before merging changes to ensure code quality.

• Continuous integration is used to automatically build and test code changes in a shared repository.

• Deployment pipelines are set up to automate the release process.

• Version cont...read more
Answered by AI
Add your answer
Q2. Has there been any security incident and how have you handled those ?
Ans. 
Yes, there have been security incidents and I have handled them effectively.
• Implemented security protocols to prevent future incidents

• Conducted thorough investigation to identify the root cause

• Collaborated with IT team to strengthen security measures

• Communicated with stakeholders to ensure transparency and trust

• Provided training to employees on cybersecurity best practices
Answered by AI
Add your answer
Q3. Difference between authorization and authentication ?
Ans. 
Authentication verifies the identity of a user, while authorization determines what actions a user is allowed to perform.
• Authentication confirms the identity of a user through credentials like passwords or biometrics.

• Authorization determines the level of access or permissions a user has once their identity is confirmed.

• Authentication is the process of logging in, while authorization is the process of granting or denyin...read more
Answered by AI
Add your answer
Q4. LLD for an authentication and authorization system
Ans. 
LLD for an authentication and authorization system
• Separate modules for authentication and authorization

• Use of secure hashing algorithms for storing passwords

• Role-based access control implementation

• Audit logging for tracking user actions

• Integration with external identity providers
Answered by AI
Add your answer

Q1. Design a document managed storage like google drive as an E2E solution.
Ans. 
Design a document managed storage like Google Drive as an E2E solution.
• Implement user authentication and authorization for secure access.

• Create a user-friendly interface for uploading, organizing, and sharing documents.

• Include features like version control, file syncing, and search functionality.

• Utilize cloud storage for scalability and accessibility.

• Implement encryption for data security.

• Integrate with third-party app
Answered by AI
Add your answer

Q1. Time you worked under pressure, with a team
Add your answer

Writing Sample based on HBR

Case study on 4 day work week using RCA

Asked coding questions on Python and SQL
Python - find longest non repeating substring
SQL - join and window function

Develop a production-grade application in Python that analyzes data and provides answers to questions based on the dataset.

Q1. System design and project based questions
Add your answer
Q2. Scenario-based questions that can help assess how you handle various situations
Add your answer

Q1. What was your experience like during the one-on-one interview with HR?
Add your answer
Q2. What types of questions will the manager ask?
Add your answer

Q1. Can you explain your previous work experience?
Add your answer
Q2. Salary negotiable
Add your answer

Q1. Highway related Questions
Add your answer
Q2. Highway related
Add your answer

Q1. Highway related Questions
Add your answer
Q2. Highway related Questions
Add your answer

Q1. Highway related Questions
Add your answer

1 good coding question and 33 mcqs

Q1. Easy questions are asked
Add your answer
Q2. Like create a database of the collages composes of students and professors
Ans. 
Create a database to store information about colleges, students, and professors.
• Create tables for colleges, students, and professors

• Include columns for relevant information such as name, ID, courses, etc.

• Establish relationships between the tables using foreign keys

• Use SQL queries to insert, update, and retrieve data

• Consider normalization to avoid data redundancy
Answered by AI
Add your answer

Q1. Some hr questions
Add your answer
Q2. Project discussions
Add your answer

Q1. Hr questions about family
Add your answer

Two coding questions related to matrices and heaps.

Q1. Python and SQL coding
Add your answer

Q1. Same questions like tech 1
Add your answer

Q1. Self intro , why tiger
Add your answer
Q2. Relocation
Add your answer

Q1. Questions relaterd to CV
Add your answer
Q2. Regarding previous company
Add your answer
Q3. Willingness to relocate
Ans. 
Yes, I am open to relocating for the right opportunity.
• I am open to exploring new locations for career growth

• I have relocated in the past for job opportunities

• I understand the benefits of experiencing different work environments
Answered by AI
Add your answer
Q4. Why ITconsulting
Ans. 
IT consulting is important for helping businesses improve their technology infrastructure, optimize processes, and stay competitive in the digital age.
• Provides expertise and guidance on implementing new technologies

• Helps businesses streamline processes and increase efficiency

• Assists in identifying and mitigating cybersecurity risks

• Supports digital transformation initiatives

• Enables businesses to stay competitive in the
Answered by AI
Add your answer