Eaton Data Analyst Interview Questions and Answers

Q1. Tell me about yourself? PowerBI, SQL, work experience, Data mining,data profiling, power query power pivot, next 5 years
Add your answer

Mettle test and mcq were given in interview

Q1. Power bi and tableau
Add your answer

Q1. About the projects worked
Add your answer
Q2. Questions on the product and logics that we worked
Add your answer

Q1. What is the notice period
Ans. 
Notice period is the amount of time an employee must give before leaving a job.
• Notice period is typically stated in the employment contract.

• It can vary from company to company and can range from 1 month to 3 months.

• During the notice period, the employee is expected to work as usual and hand over responsibilities.

• Some companies may allow employees to buy out their notice period by paying a fee.

• Notice period is important...read more
Answered by AI
Add your answer
Q2. Current Salary and relocate to base location
Ans. 
Disclosing current salary and willingness to relocate are common questions in job interviews.
• It is important to be honest about your current salary to avoid any discrepancies later on.

• Express your willingness to relocate if necessary, but also discuss any potential concerns or conditions.

• Consider the benefits of relocating to the base location, such as career growth opportunities or cost of living.

• Provide examples of s...read more
Answered by AI
Add your answer

Q1. Difference between ADF and synapse in Azure
Ans. 
ADF is a cloud-based data integration service while Synapse is an analytics service that brings together big data and data warehousing.
• ADF is used for data integration and orchestration tasks, while Synapse is used for big data analytics and data warehousing

• ADF allows you to create data pipelines to move and transform data, while Synapse provides a unified experience for data preparation, data management, data warehous...read more
Answered by AI
Add your answer
Q2. What RDD & why
Ans. 
RDD stands for Resilient Distributed Dataset, a fundamental data structure in Apache Spark.
• RDD is a fault-tolerant collection of elements that can be operated on in parallel.

• RDDs are immutable, meaning they cannot be changed once created.

• RDDs support two types of operations: transformations (creating a new RDD from an existing one) and actions (returning a value to the driver program).
Answered by AI
Add your answer
Q3. What SCD1 and SCD2
Ans. 
SCD1 and SCD2 are types of slowly changing dimensions used in data warehousing.
• SCD1 (Type 1): Overwrites old data with new data, losing historical information.

• SCD2 (Type 2): Keeps track of historical data by creating new records for changes.

• SCD1 is simpler and faster, while SCD2 provides more detailed historical information.

• Example: SCD1 would update a customer's address directly, while SCD2 would create a new record w...read more
Answered by AI
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

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