Institutional Shareholder Services Interview Questions and Answers

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 pandas: merged_df = pd.merge(df1, df2, on='key_column')

Custom registry in IBM Websphere allows users to define their own user repositories for authentication and authorization.

• Custom registry can be configured in the security.xml file of the Websphere application server.

• Users can define their own LDAP servers, databases, or custom Java classes as user repositories.

• Custom registry provides flexibility in integrating with different authentication and authorization systems.

• Example: Configuring a custom LDAP server as the user regist...read more

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 DevOps.

• SDLC helps teams manage and control the development...read more

ESG factors are weighted differently for FMCG and banks based on industry-specific risks and opportunities.

• Consider industry-specific risks and opportunities for FMCG and banks

• For FMCG, focus on environmental impact of production, social responsibility in supply chain, and governance practices

• For banks, prioritize governance practices, risk management, and social impact of lending practices

• Use industry benchmarks and ESG ratings to inform weighting decisions

ESG stands for Environmental, Social, and Governance criteria. People consider ESG now due to increasing awareness of sustainability and ethical practices in business.

• ESG criteria are used by investors to evaluate the sustainability and ethical impact of a company.

• Companies are increasingly focusing on ESG factors to attract investors and customers who prioritize sustainability.

• Regulatory bodies are also emphasizing the importance of ESG practices for businesses to operate re...read more