Zensar Technologies Data Analyst Interview Questions and Answers

Simple assessment includes logical reasoning and general aptitude

Includes simple programs

Q1. Tell me about yourself
Add your answer
Q2. Compare strings from 2 files and store distinct strings in a different file
Ans. 
The solution compares strings from 2 files and stores distinct strings in a different file.
• Read the contents of both files into separate arrays

• Loop through the first array and check if each string is present in the second array

• If not present, add the string to a new array

• Write the contents of the new array to a different file
Answered by AI
Add your answer

Q1. DAX Related Syntax and Codes
Add your answer
Q2. Data Modelling, SQL, Python
Add your answer

Q1. No Response from HR after calling of selection after Round 1
Add your answer

It is very easy . Leetcode easy prob can help out

Basic cat type questions

Q1. Basics about python, some queries about SQL , something about machine learning
Add your answer

Q1. What is your family background?
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Why should we hire you?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. What is sql
Ans. 
SQL (Structured Query Language) is a standard programming language for managing and manipulating relational databases.
• SQL is used to query, insert, update, and delete data in databases. Example: SELECT * FROM users;

• It allows for data definition and manipulation through commands like CREATE, ALTER, and DROP. Example: CREATE TABLE orders (id INT, amount DECIMAL);

• SQL supports complex queries with JOIN operations to combin...read more
Answered by AI
Add your answer
Q2. Data warehouse in sql
Ans. 
A data warehouse is a centralized repository for storing and analyzing large volumes of structured and unstructured data.
• Data warehouses integrate data from multiple sources, such as databases, CRM systems, and flat files.

• They support complex queries and data analysis, enabling businesses to make informed decisions.

• Data is organized in a star or snowflake schema, optimizing query performance.

• ETL (Extract, Transform, Lo...read more
Answered by AI
Add your answer

Q1. Question related to SQL, Tableau and some problem statements. Challenges faced in work environment.
Add your answer

Q1. Work experience. Challenges faced in work. Type of visualization for a specific type of problem.
Ans. 
Work experience, challenges faced, and visualization types for specific problems.
• Work experience: Mention relevant job roles and responsibilities.

• Challenges faced: Discuss specific challenges encountered and how they were overcome.

• Visualization types: Provide examples of visualizations used for different types of problems.
Answered by AI
Add your answer

Q1. Work experience, expectations etc.
Add your answer