Adani Power Data Analyst Interview Questions and Answers

Practical test was taken in this round

Q1. More of a managerial round
Add your answer
Q2. Tell about current role
Add your answer
Q3. Question on current project
Add your answer

Q1. Tell about yourself
Add your answer

Q1. Sir i want to apply for job in your company
Add your answer

Q1. SQL MongoDB Postgress MySQL
Add your answer
Q2. What is MySQL and its responsibilities?
Ans. 
MySQL is a popular open-source relational database management system.
• MySQL is used for storing and managing data in a structured format.

• It allows users to create, read, update, and delete data using SQL queries.

• MySQL is commonly used in web applications to store user information, product data, and more.

• It supports features like transactions, indexing, and replication for data consistency and reliability.
Answered by AI
Add your answer
Q3. What is SQL and its main role as db engg.?
Ans. 
SQL is a programming language used for managing and querying relational databases.
• SQL stands for Structured Query Language

• Main role is to interact with databases by querying, updating, and managing data

• Used to create, retrieve, update, and delete data in relational databases

• Allows for data manipulation, data definition, and data control operations

• Examples include SELECT, INSERT, UPDATE, DELETE statements
Answered by AI
Add your answer
Q4. What is mongoDB ?
Ans. 
mongoDB is a popular NoSQL database management system.
• NoSQL database

• Document-oriented

• Scalable and flexible

• Supports dynamic schemas

• Used for handling large volumes of data
Answered by AI
Add your answer
Q5. What is postgress?
Ans. 
PostgreSQL is an open-source relational database management system known for its robustness and extensibility.
• PostgreSQL is commonly referred to as Postgres.

• It is known for its ACID compliance, extensibility, and support for various data types.

• PostgreSQL supports SQL and JSON querying, as well as various programming languages for stored procedures.

• It is widely used in enterprise applications and web development.

• Example...read more
Answered by AI
Add your answer

Q1. Projects related which you have done in past and basics of ml
Add your answer
Q2. Questions around LLMs
Add your answer

Q1. Deep dive in concepts of stats, ml and dl
Add your answer

Q1. Salary discussion
Add your answer

Mettle test and mcq were given in interview

Excel test. You must be able to find the special caracters from the cells. You must be aware about ctrl find and ctrl replace shortcuts. Len formulas, count formula, sum + count + find formulas will help while working, Data Govenance knowledge will help while interview.

Q1. The reason job change, ready for Afternoon shift_ Free transport provided by company, Salary discussion
Add your answer

There are more the 10 people in the group discussion round i was selected one of them

Q1. They asked about azure data factory, azure databricks, azure technology
Add your answer
Q2. What is azure data factory
Ans. 
Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• Azure Data Factory is used to move and transform data from various sources to destinations.

• It supports data integration and orchestration of workflows.

• You can create data pipelines using a visual interface or code.

• It integrates with various data sources like Azure Blob Storage, SQL Database, and m
Answered by AI
Add your answer

Q1. They asked about my college project
Add your answer

Practical test was taken in this round

Q1. More of a managerial round
Add your answer
Q2. Tell about current role
Add your answer
Q3. Question on current project
Add your answer

Q1. Tell about yourself
Add your answer