DXC Technology Senior Data Analyst Interview Questions and Answers

Hacker rank test mostly on sql

Q1. Focused on Statistical analysis and sql. More sql questions on window functions
Add your answer
Q2. Sql joins and aggregation functions
Add your answer

Time vs money, time time time

Dsa, python sql etl ssis

3 questions are there.

Q1. About Projects and previous work exp
Add your answer

Q1. Functions in SQL Linear Regression
Ans. 
Functions in SQL are used to perform specific tasks on the data stored in a database.
• SQL functions can be used to manipulate data, perform calculations, and retrieve specific information from a database.

• Common SQL functions include aggregate functions (e.g., SUM, AVG), string functions (e.g., CONCAT, SUBSTRING), and date functions (e.g., DATEPART, GETDATE).

• Functions can be used in SELECT statements, WHERE clauses, and ...read more
Answered by AI
Add your answer
Q2. Machine Learning
Add your answer
Q3. Transformations in Informatica
Ans. 
Transformations in Informatica are used to manipulate and modify data during the ETL process.
• Transformations are used to filter, aggregate, join, and sort data.

• Examples of transformations include Filter, Aggregator, Joiner, and Sorter.

• Transformations can be used to perform calculations, data cleansing, and data validation.

• They can also be used to create new columns, merge data from multiple sources, and split data into
Answered by AI
Add your answer
Q4. Power BI Basic questions
Add your answer

Q1. Techincal with sql python and power bi
Add your answer

Depedending on previous experience

Q1. What is clustering? And how do you check if a ML model is performing well?
Ans. 
Clustering is a machine learning technique used to group similar data points together. Model performance can be checked using evaluation metrics like silhouette score or inertia.
• Clustering is the process of dividing a set of data points into groups based on their similarities.

• Common clustering algorithms include K-means, hierarchical clustering, and DBSCAN.

• To check if a ML model is performing well, evaluation metrics l...read more
Answered by AI
Add your answer
Q2. Explain the difference between Arithmetic mean, Harmonic mean and Geometric mean?
Ans. 
Arithmetic mean is the sum of all values divided by the number of values. Harmonic mean is the reciprocal of the arithmetic mean of the reciprocals of the values. Geometric mean is the nth root of the product of n values.
• Arithmetic mean is most commonly used and is calculated by summing all values and dividing by the number of values.

• Harmonic mean is used when dealing with rates or ratios, and is calculated by taking t...read more
Answered by AI
Add your answer