Institutional Shareholder Services Junior Analyst Interview Questions and Answers

Q1. Tell me about your self
Add your answer
Q2. What do you know about iss
Add your answer

Aptitude test along with some coding questions. The aptitude questions were of easy to moderate difficulty. Coding questions were about OOPs concepts in Java and Python

Q1. How do we join two tables in SQL? How do we join two dataframes in pandas python?
Ans. 
In SQL, tables are joined using JOIN statements. In pandas, dataframes are joined using merge() function.
• In SQL, use JOIN statements such as INNER JOIN, LEFT JOIN, RIGHT JOIN, or FULL JOIN to combine data from two tables based on a related column.

• In pandas, use the merge() function to join two dataframes based on one or more keys.

• Example in SQL: SELECT * FROM table1 JOIN table2 ON table1.key = table2.key;

• Example in pan...read more
Answered by AI
Add your answer
Q2. What is Software Development Lifecycle?
Ans. 
Software Development Lifecycle (SDLC) is a process used by software development teams to design, develop, test, and deploy high-quality software.
• SDLC consists of several phases including planning, analysis, design, implementation, testing, and maintenance.

• Each phase has specific goals and deliverables to ensure the software meets requirements and is of high quality.

• Examples of SDLC models include Waterfall, Agile, and ...read more
Answered by AI
Add your answer
Q3. Please expalin you project work and what did you learnt from it?
Ans. 
I worked on a project analyzing customer data to improve marketing strategies.
• Used data analysis tools like Excel and Tableau to analyze customer demographics and behavior

• Identified key trends and patterns in customer data to target specific customer segments

• Collaborated with marketing team to implement targeted marketing campaigns based on findings

• Presented findings and recommendations to senior management for decisio
Answered by AI
Add your answer

Q1. Why you chose the software developer role?
Ans. 
I chose the software developer role because of my passion for problem-solving and creating innovative solutions.
• Passion for problem-solving

• Interest in creating innovative solutions

• Enjoy working with technology

• Opportunity for continuous learning and growth
Answered by AI
Add your answer
Q2. What is there in this company that excites you to join us?
Ans. 
The company's innovative projects and collaborative work environment excite me to join.
• Innovative projects that challenge me to think creatively

• Collaborative work environment where ideas are valued

• Opportunities for growth and development within the company
Answered by AI
Add your answer
Q3. Where do you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a Senior Analyst leading a team and contributing to strategic decision-making.
• Advancing to a Senior Analyst role within the company

• Leading a team of analysts and collaborating on projects

• Contributing to strategic decision-making processes

• Continuing professional development through additional certifications or training
Answered by AI
Add your answer

Q1. 1st round - It was with someone from phillipines who was nice and ask basic questions on resume say prior experience, past academic qualifications.
Add your answer

Q1. Where do you stay? Can you work for 16+ hours in a day? Your weakness
Add your answer
Q2. 2nd round - It was with Head of Data - Pooja an arrogant lady who does not know how to speak nor to ask questions. She lacks basic manner and etiquettes, don't know how did she managed to reach at such a p...read more
Add your answer

Q1. About yourself, hobbies etc
Add your answer
Q2. 3rd round - HR Round. Generic question.
Add your answer

Basic research skills testing questions

Q1. About how you manage time and quality at the same time
Add your answer

Q1. Basic HR questions
Add your answer