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

It was a good experience.I have completed it.

Q1. Tell me something about yourself
Ans. 
I am a highly analytical and detail-oriented data analyst with a passion for solving complex problems.
• I have a strong background in statistics and data visualization

• I am proficient in programming languages such as Python and SQL

• I have experience working with large datasets and conducting in-depth analysis

• I have excellent communication skills and can effectively present findings to stakeholders
Answered by AI
Add your answer
Q2. Expected salary
Ans. 
Negotiable based on the responsibilities and benefits offered by the company.
• My salary expectations are flexible and dependent on the responsibilities and benefits provided by the company.

• I am open to discussing salary based on the overall compensation package.

• I am looking for a competitive salary that aligns with industry standards for a Senior Data Analyst role.
Answered by AI
Add your answer