Nerd Square Digital Solutions Analyst Interview Questions and Answers

Its overall good . First aptitude and then english test

Q1. Networking related questions
Add your answer
Q2. Sql and oops conecpts
Add your answer

Q1. Why we shouod hire you
Ans. 
I have a strong analytical background, excellent communication skills, and a proven track record of delivering actionable insights.
• I have a degree in Economics with a focus on data analysis

• I have experience using statistical software such as R and Python

• I have successfully presented findings to senior management in previous roles
Answered by AI
Add your answer
Q2. Your strength and weakness
Ans. 
Strength: Analytical skills, Weakness: Perfectionism
• Strength: Strong analytical skills help me in problem-solving and decision-making.

• Weakness: Perfectionism can sometimes lead to spending too much time on a task to ensure it is flawless.

• Strength: Attention to detail allows me to catch errors and improve processes.

• Weakness: Striving for perfection can cause stress and hinder progress.

• Strength: Ability to think critical...read more
Answered by AI
Add your answer

General assesment, grammar, vocabulary

Q1. SQL and Python basic level
Add your answer
Q2. Sql problems regarding joins and window function
Ans. 
Understanding SQL problems related to joins and window functions
• Ensure you understand the different types of joins (inner, outer, left, right)

• Know how to use window functions like ROW_NUMBER(), RANK(), and PARTITION BY

• Practice writing queries that involve multiple tables and window functions
Answered by AI
Add your answer

Q1. Normal questions
Add your answer

Number system, and basic apptitude questions

Q1. Tell us about your self
Ans. 
I am a detail-oriented analyst with a strong background in data analysis and problem-solving skills.
• Experience in analyzing complex data sets

• Proficient in using statistical software such as R or Python

• Strong communication skills for presenting findings to stakeholders
Answered by AI
Add your answer
Q2. About your job experience
Add your answer

Q1. Explain power BI in your project
Add your answer
Q2. Write sql code using rank
Ans. 
Using SQL rank function to assign ranks to rows based on specified criteria.
• Use the RANK() function to assign ranks to rows based on specified criteria.

• Specify the ORDER BY clause to determine the criteria for ranking.

• Use the PARTITION BY clause to rank rows within groups.

• Example: SELECT column1, column2, RANK() OVER (ORDER BY column3) AS rank_column FROM table_name;
Answered by AI
Add your answer

Q1. Regarding field knowledge like Preventive maintenance of all equipments; safety of equipments
Ans. To maintain trackers on dialy basis of All electrical equipments; in electrical we have to ensure earthing of equipments to prevent from Ht surge as well as leakage current.
Answered Anonymously
Add your answer
Q2. Follow safety rules first
Add your answer

Q1. About cost control
Ans. We suggested as much as we can
Answered Anonymously
Add your answer

It was easy and not difficult

Q1. Describe yourself, strength, weakness
Add your answer

General Questions on Apti

Applications on the case based on your experience and of course coding

Coding on Python ,Tableau

Q1. On salary expectations
Add your answer
Q2. Company expectations
Add your answer
Q3. Some general questions related situations and why did you leave the company etc etc
Add your answer
Q4. Questions on WFO and WFH PREFERENCE
Add your answer
Q5. WHY gENPACT YOU LEAVE AT THIS TIME
Add your answer
Q6. SOME OTHER GENERAL QUESTIONS
Add your answer
Q7. THATS IT NOT MUCH
Add your answer
Q8. ABOUT PREVIOUS WORK EXPERIENCE
Add your answer
Q9. WHATS SO SPECIAL ABOUT OUR COMPANY
Add your answer
Q10. DDadADAFSAFDSAFDSFDSAFDSAFAFAFA
Add your answer

Few questions related to escalation Engineering process

Q1. What do you know the escalation Engineering process?
Ans. 
Escalation Engineering process involves identifying and resolving critical issues in a timely manner.
• Escalation process is triggered when a critical issue is identified

• The issue is then assigned to a team of experts who work on resolving it

• Regular updates are provided to stakeholders until the issue is resolved

• The process involves prioritizing and managing multiple escalations simultaneously

• Examples include software bu
Answered by AI
Add your answer
Q2. What is the most Google product you use and give the details about the product?
Ans. 
The most used Google product is Google Drive.
• Google Drive is a cloud storage service that allows users to store and share files.

• It offers free storage up to 15GB and paid plans for more storage.

• It also includes Google Docs, Sheets, and Slides for creating and collaborating on documents.

• Google Drive can be accessed on desktop and mobile devices.

• It is a convenient and reliable tool for personal and professional use.
Answered by AI
Add your answer
Q3. Tell me about 5 Google products?
Ans. 
Google Search, Google Maps, Google Drive, Google Photos, Google Translate
• Google Search - search engine for finding information on the internet

• Google Maps - mapping service for directions and location information

• Google Drive - cloud storage and file sharing service

• Google Photos - photo and video storage and sharing service

• Google Translate - language translation service
Answered by AI
Add your answer
Q4. Salary discussion with Team lead mostly, HR not the part of interview.
Add your answer