Standard Chartered
100+ Interview Questions and Answers
Q1. Tell me about your profile? What do you know about Transaction Monitoring ? What are the sanctioned countries ? Do you know what is sectoral sanctions ? Can you explain sectoral sanctions and countries which is...
read moreAnswering questions related to Transaction Monitoring, Sanctions, Risk Assessment, AML, and Russia sanctions.
Transaction Monitoring is the process of monitoring financial transactions to identify suspicious activities.
Sanctioned countries are those that are subject to economic or trade sanctions imposed by governments or international organizations.
Sectoral sanctions are restrictions on specific sectors of a country's economy, such as energy or finance.
High risk refers to cus...read more
Ninja is given an array of integers that contain numbers in random order. He needs to write a program to find and return the number which occurs the maximum times in the given input. He ...read more
You are given a paragraph that may have letters both in lowercase and uppercase, spaces, and punctuation. You have also given a list of banned words. Now your task is to find the most frequent...read more
You have been given a string STR. Your task is to find the total number of palindromic substrings of STR.
Example :
If the input string is "abbc", then all the possible palindromic substr...read more
You are given a string S of words. Your task is to count the occurrence of each word present in the string S. A word is a sequence of one or more non-space characters, and there can be m...read more
You are given an infinite supply of coins of each of denominations D = {D0, D1, D2, D3, ...... Dn-1}. You need to figure out the total number of ways W, in which you can make a change fo...read more
Mike is a little boy who loves solving math problems. One day he was playing with his mom’s mobile. The mobile keypad contains 12 buttons { 10 digits(0-9) and 2 characters(‘*’ and ‘#’) }. Mike wa...read more
Pre-requisites: Anagrams are defined as words or names that can be formed by rearranging letters of another word. Such as "spar" can be formed by rearranging letters of "rasp". Hence, "spar" and "r...read more
Q9. What are the programing tools you know ? Rate yourself ( out of 5 )
I am proficient in several programming tools and rate myself highly in their usage.
Java - 5
Python - 4
SQL - 4
R - 3
MATLAB - 3
Tableau - 4
Excel - 5
You have been given an array/list 'ARR' of integers. Your task is to find the second largest element present in the 'ARR'.
Note:
a) Duplicate elements may be present. b) If no...read more
Ninja is playing with numbers but hates when he gets duplicate numbers. Ninja is provided an array, and he wants to remove all duplicate elements and return the array, but he has to maintain th...read more
You are given a starting position for a rat which is stuck in a maze at an initial point (0, 0) (the maze can be thought of as a 2-dimensional plane). The maze would be given in the form of a squar...read more
Nth term of Fibonacci series F(n), where F(n) is a function, is calculated using the following formula -
F(n) = F(n-1) + F(n-2), Where, F(1) = F(2) = 1
Provided N you have to find out the ...read more
You are given 'N' rectangular buildings in a 2-dimensional city. Your task is to compute the skyline of these buildings, eliminating hidden lines return the skyline formed by these buildings ...read more
You have been given an undirected graph of ‘V’ vertices (labeled 0,1,..., V-1) and ‘E’ edges. Each edge connecting two nodes (‘X’,’Y’) will have a weight denoting the distance between no...read more
Q16. How to remove duplicate Records by using first. And last. ?
Removing duplicate records using first. and last. functions.
Use the first. and last. functions to select the first and last occurrence of each record.
Sort the data by the key field to ensure that the first and last records are selected correctly.
Use the delete statement to remove the duplicate records.
25 horses problem
There are 25 horses. What is the minimum number of races needed so you can identify the fastest 3 horses? You can race up to 5 horses at a time, but you do not have a watch.
Egg Dropping p...read more
She asked me why do haven't done java to which i replied i have good logics and good understanding of c++ .Learning java is not difficult for me and i only have to learn syntax(be confident i...read more
1. Family background
2. Location of the intern
3. Any interest in startups (as they don’t want students who they hire also work with startups side by side)
4. Willingness to relocate
Q20. What type of adhoc report you get from client side ?
Adhoc reports requested by clients vary depending on their needs and objectives.
Client may request reports on sales performance, customer behavior, or market trends.
Reports may be in the form of tables, graphs, or charts.
Clients may also request customized reports based on specific criteria or filters.
Adhoc reports are usually requested on a one-time basis and may not follow a regular schedule.
Q21. How would you perform outlier analysis- detection and treatment?
Outlier analysis involves identifying and treating data points that are significantly different from the rest.
Identify outliers using statistical methods such as box plots, scatter plots, and z-scores.
Determine the cause of the outlier and decide whether to remove it or keep it in the dataset.
Consider the impact of outliers on the analysis and adjust the model accordingly.
Use techniques such as winsorization or data transformation to treat outliers.
Repeat the analysis after t...read more
Q22. How would you impute missing value when we don't ant to use single value for imputation?
Multiple imputation can be used to impute missing values by creating multiple datasets with imputed values.
Use multiple imputation to create multiple datasets with imputed values
Combine the results from the multiple datasets to obtain a final imputed dataset
Consider using predictive models to impute missing values
Evaluate the quality of imputation using metrics such as mean squared error or R-squared
Q23. How would you perform variable selection before modelling/ multicollinearity?
Variable selection can be done using techniques like correlation matrix, stepwise regression, and principal component analysis.
Check for correlation between variables using correlation matrix
Use stepwise regression to select variables based on their significance
Perform principal component analysis to identify important variables
Check for multicollinearity using variance inflation factor (VIF)
Consider domain knowledge and business requirements while selecting variables
Q24. The relationship between interest rate and investment
The relationship between interest rate and investment
Higher interest rates tend to discourage investment as borrowing becomes more expensive
Lower interest rates encourage investment as borrowing becomes cheaper
Investment decisions are influenced by the cost of borrowing and the potential return on investment
Higher interest rates can lead to a decrease in business investment and economic growth
Lower interest rates can stimulate investment and economic activity
What is DOM?
What are indexes in database.
What is the difference between stored functions and procedures?
Q26. How to remove null values in numeric data types?
Null values in numeric data types can be removed using various methods.
Use the dropna() function in pandas library to remove null values.
Replace null values with a default value using fillna() function.
Use the interpolate() function to fill null values with interpolated values.
Use the drop() function to remove rows or columns with null values.
Use the notnull() function to filter out null values from the data.
Q27. 1.when customer gives request for stop payment? Would you do immediately or take your time till evening till Banking hours are closed?
Stop payment requests should be processed immediately for customer satisfaction and to prevent any potential fraud.
Stop payment requests should be taken seriously and processed promptly.
Delaying the process could lead to customer dissatisfaction and potential fraud.
It is important to verify the customer's identity and the validity of the request before processing.
Once verified, the request should be processed immediately to prevent any further transactions.
Communication with ...read more
Q28. How would you test model performance of classification models?
Model performance of classification models can be tested using various metrics.
Use confusion matrix to calculate accuracy, precision, recall, and F1 score.
ROC curve and AUC can be used to evaluate model's ability to distinguish between positive and negative classes.
Cross-validation can be used to test model's performance on different subsets of data.
Use lift charts to compare model's performance with random selection.
Use KS statistic to measure the separation between positive...read more
Q29. What are the different filters in Tableau you use.
Tableau has various filters including dimension filters, measure filters, top N filters, wildcard filters, and context filters.
Dimension filters allow you to filter data based on specific dimensions such as category or region.
Measure filters filter data based on measures like sales or profit.
Top N filters allow you to filter the top or bottom N values based on a measure.
Wildcard filters filter data based on a specific pattern or wildcard.
Context filters create a temporary sub...read more
Q30. How to get different dataset from existing one ?
To get a different dataset from an existing one, you can filter, sort, aggregate, or transform the data.
Filter the data by selecting specific rows or columns based on certain criteria.
Sort the data by arranging it in ascending or descending order based on one or more columns.
Aggregate the data by grouping it based on one or more columns and calculating summary statistics.
Transform the data by applying mathematical or logical operations, merging with other datasets, or creatin...read more
Q31. What are the different dashboard you prepared till now
I have prepared various dashboards for different purposes.
Sales dashboard for tracking revenue and sales performance
Marketing dashboard for monitoring campaign effectiveness and lead generation
Financial dashboard for analyzing financial data and forecasting
Operational dashboard for tracking operational metrics and KPIs
Customer service dashboard for monitoring customer satisfaction and support metrics
Q32. What is Xgboost? How it is different from Random Forest?
Xgboost is a gradient boosting algorithm used for classification and regression tasks. It is faster and more accurate than Random Forest.
Xgboost stands for Extreme Gradient Boosting
It is a type of gradient boosting algorithm that uses decision trees
It is faster and more accurate than Random Forest
Xgboost uses a more regularized model formalization to control overfitting
Random Forest builds multiple decision trees and combines them to get a more accurate prediction
Xgboost is w...read more
Q33. How would you measure relationship between two features?
The relationship between two features can be measured using correlation coefficient.
Calculate the correlation coefficient using statistical methods.
Correlation coefficient ranges from -1 to 1.
A positive correlation indicates a direct relationship between the features.
A negative correlation indicates an inverse relationship between the features.
A correlation coefficient of 0 indicates no relationship between the features.
Q34. In case you came across database usage how you have designed the database
I would first analyze the requirements and then design the database accordingly.
Understand the data and its relationships
Identify the entities and their attributes
Normalize the data to reduce redundancy
Choose appropriate data types and constraints
Consider scalability and performance
Ensure data integrity and security
Q35. How Tableau get data from SAS environment?
Tableau can connect to SAS environment through ODBC or SAS/ACCESS Interface.
Tableau can use ODBC to connect to SAS environment and access data.
SAS/ACCESS Interface can also be used to connect Tableau to SAS environment.
Tableau can directly connect to SAS datasets and tables.
Tableau can also use SAS data connectors to access data from SAS environment.
Q36. what is Loss function in Logistic Regression?
Loss function in Logistic Regression measures the difference between predicted and actual values.
It is used to optimize the model parameters during training.
The most common loss function used in logistic regression is the binary cross-entropy loss.
The goal is to minimize the loss function to improve the accuracy of the model.
The loss function is calculated using the predicted probabilities and the actual labels.
Other loss functions used in logistic regression include hinge lo...read more
Q37. What is the difference between AML Monitoring and Fraud Monitoring
AML Monitoring focuses on detecting and preventing money laundering activities, while Fraud Monitoring focuses on identifying and preventing fraudulent transactions.
AML Monitoring is primarily concerned with identifying suspicious financial activities that may be indicative of money laundering.
Fraud Monitoring is primarily concerned with detecting and preventing fraudulent transactions or activities.
AML Monitoring involves analyzing customer transactions, monitoring for patte...read more
Q38. What is redflag ? What is AML ? What is ML ?
Red flags are warning signs that indicate potential suspicious activity. AML stands for Anti-Money Laundering and ML stands for Money Laundering.
Red flags are indicators of potential suspicious activity that require further investigation.
AML refers to the set of laws, regulations, and procedures that financial institutions must follow to prevent, detect, and report money laundering activities.
ML is the process of disguising the proceeds of illegal activity as legitimate funds...read more
Q39. Which institution is responsible for the regulation of stock market in India?
Securities and Exchange Board of India (SEBI) is responsible for the regulation of stock market in India.
SEBI is a statutory regulatory body established in 1988.
It regulates the securities market in India and protects the interests of investors.
SEBI ensures transparency and fairness in the functioning of the stock market.
It also regulates the activities of stockbrokers, sub-brokers, and other intermediaries in the securities market.
SEBI has the power to investigate and take a...read more
Q40. Is it better to have one monolithic application instead of several micro services in terms of resources?
It depends on the specific requirements and constraints of the project.
Monolithic applications can be easier to develop and deploy, but can become difficult to maintain and scale as they grow.
Microservices can be more flexible and scalable, but require more resources and complexity to manage.
Consider factors such as team size, project scope, performance requirements, and future growth plans when deciding on architecture.
Hybrid approaches, such as using microservices for certa...read more
Q41. What are the documents required while issuing guarantees?
Documents required for issuing guarantees
Application form
Copy of contract/agreement
Proof of identity/address
Financial statements
Collateral documents
Power of attorney (if applicable)
Q42. How to mock unit test cases to test an API call in Python
Q43. What is Logistic Regression and when do we use it?
Logistic Regression is a statistical method used to analyze and model the relationship between a binary dependent variable and one or more independent variables.
It is used when the dependent variable is binary (0 or 1).
It estimates the probability of an event occurring based on the values of the independent variables.
It is commonly used in credit risk analysis to predict the likelihood of default.
It can also be used in marketing to predict the likelihood of a customer making ...read more
Q44. What is the use of Learning rate in Xgboost?
Learning rate controls the step size at each boosting iteration in Xgboost.
Learning rate is a hyperparameter that determines the contribution of each tree in the final output.
A smaller learning rate requires more trees to be added to the model, but can lead to better performance.
A larger learning rate can speed up the training process, but may result in overfitting.
Typical values for learning rate range from 0.01 to 0.2.
Example: setting a learning rate of 0.1 means that each ...read more
Q45. what is p value and what it's interpretation?
P value is the probability of obtaining a result as extreme or more extreme than the observed result, assuming the null hypothesis is true.
P value is used in hypothesis testing to determine the significance of a result.
A small p value (less than 0.05) indicates strong evidence against the null hypothesis.
A large p value (greater than 0.05) indicates weak evidence against the null hypothesis.
P value should not be used as the sole criterion for accepting or rejecting a hypothes...read more
Q46. What is sblc and how is it different from guarantees?
SBLC is a financial instrument used for international trade transactions, while guarantees are used for domestic transactions.
SBLC stands for Standby Letter of Credit
It is a guarantee issued by a bank on behalf of a client to ensure payment to a third party in case of default
SBLC is commonly used in international trade transactions
Guarantees are similar to SBLCs but are used for domestic transactions
Guarantees are issued by banks or other financial institutions to ensure paym...read more
Q47. What is the probability that you can cut a rope into exactly two halves?
The probability of cutting a rope into exactly two halves is zero.
Cutting a rope into exactly two halves is impossible due to the thickness of the blade or scissors used.
Even if the rope is thin enough to be cut into two halves, the cut will never be perfectly straight.
Therefore, the probability of cutting a rope into exactly two halves is zero.
Q48. How do you sell banking products
To sell banking products, you need to understand customer needs, build relationships, showcase product benefits, and provide excellent customer service.
Understand customer needs and tailor product recommendations accordingly
Build relationships with potential customers through networking and referrals
Showcase the benefits and features of banking products to potential customers
Provide excellent customer service to build trust and loyalty
Offer personalized solutions and address ...read more
Q49. How do you acquire hni clients with high up value
Acquiring HNI clients with high up value requires a strategic approach and personalized communication.
Identify target market and research their needs and preferences
Develop a personalized approach and communication strategy
Leverage existing network and referrals
Attend industry events and conferences to network and build relationships
Offer exclusive benefits and services to attract and retain clients
Provide exceptional customer service to build trust and loyalty
Find 4th highest salary from the table.
Q51. What is Datamart and Data warehouse
Datamart is a subset of a data warehouse that is designed for a specific business unit or department.
Data warehouse is a centralized repository that stores data from various sources for business intelligence purposes.
Data warehouse is designed for enterprise-wide querying and analysis.
Datamart is a subset of a data warehouse that is designed for a specific business unit or department.
Datamart contains a subset of data from the data warehouse that is relevant to a particular b...read more
Q52. given a 4 coordinates, write a memory efficient program to check if it's forming a square
Program to check if 4 coordinates form a square
Calculate distance between all pairs of points
Check if all distances are equal
Check if diagonals are equal
Use Pythagorean theorem to calculate distance
Q53. What are the cleansing process you used
We use a multi-step process to cleanse data, including removing duplicates, correcting errors, and standardizing formats.
Identify and remove duplicates
Correct errors such as misspellings and inconsistent data formats
Standardize data formats to ensure consistency
Validate data against external sources
Perform manual review and verification as needed
Q54. List some column and dataframe level functions from pandas and their usage by sharing screen and writing a sample program
Q55. How you are keeping the automation logs ?
Automation logs are kept in a centralized location with detailed information on test cases and results.
Automation logs are stored in a centralized location for easy access and analysis.
Logs include detailed information on test cases, such as test name, status, and duration.
Logs also include information on the environment and system under test.
Logs are organized by date and time for easy tracking of changes and issues.
Logs are regularly reviewed and analyzed to identify areas ...read more
Q56. How to create macro variables?
Macro variables can be created using the %LET statement in SAS programming.
Use %LET statement followed by the macro variable name and its value.
Macro variables can be created with or without quotes around the value.
Macro variables can be referenced using & symbol followed by the variable name.
Example: %LET var1 = 10; %LET var2 = 'Hello';
Example: %LET var3 = &var1.;
Q57. What is calculative field in SAS
A calculative field in SAS is a field that is created by performing calculations on existing fields.
Calculative fields are created using SAS functions and expressions.
They can be used to perform complex calculations and transformations on data.
Examples include calculating averages, percentages, and ratios.
Calculative fields can be added to existing datasets or created as part of a data transformation process.
Q58. What is the difference between a commercial bank and a investment bank?
Commercial banks focus on providing services to individuals and businesses, while investment banks focus on helping companies raise capital and provide financial advisory services.
Commercial banks primarily deal with deposits, loans, and basic financial services for individuals and businesses.
Investment banks focus on underwriting securities, facilitating mergers and acquisitions, and providing financial advisory services.
Commercial banks are more focused on retail banking, w...read more
Q59. Why did you use this icon?, what was the thought process? Why did you use particular image? Why didn't you use some different things? How can you redesign this slide?
Q60. Difference between add and sum function
Add function is used to concatenate two or more strings or add numbers, while sum function is used to add numbers only.
Add function can be used to concatenate strings like 'hello' and 'world' to form 'helloworld'
Add function can also be used to add numbers like 2 and 3 to form 5
Sum function is used to add numbers only, like sum(2,3) will return 5
Q61. Difference between CSV and Excel file
CSV is a plain text file format while Excel is a binary file format.
CSV files contain data separated by commas while Excel files can contain multiple sheets and complex formatting.
CSV files can be easily opened in any text editor while Excel files require Microsoft Excel or a compatible program.
CSV files are smaller in size compared to Excel files.
CSV files are commonly used for data exchange between different systems while Excel files are used for data analysis and reporting...read more
Q62. What do you think about a Tecnical Research devlope amazingly?
Technical research and development can lead to amazing advancements in the field of data analytics.
Technical research and development can lead to the creation of new tools and technologies that can improve data analytics processes.
It can also lead to the discovery of new insights and patterns in data that were previously unknown.
Examples of technical research and development in data analytics include the development of machine learning algorithms and the use of big data analy...read more
Q63. Will you be able to sell insurance 4 lacs per month
Yes, I have a proven track record of exceeding sales targets and have the necessary skills to sell insurance worth 4 lacs per month.
I have experience in selling insurance products to a diverse range of customers
I have a deep understanding of the insurance industry and the products offered
I am skilled in building and maintaining relationships with clients
I am confident in my ability to meet and exceed sales targets
I am willing to put in the necessary effort and work hard to ac...read more
Q64. What loss function is used in Xgboost?
The loss function used in Xgboost is customizable and can be specified by the user.
Xgboost supports various loss functions such as binary logistic regression, multi-class classification, and regression.
The default loss function for binary classification is logistic regression while for regression it is mean squared error.
Users can specify their own loss function by defining a custom objective and evaluation function.
The objective function measures the difference between predi...read more
Q65. What are the parameters in Xgboost?
Xgboost parameters include learning rate, max depth, subsample, colsample by tree, and more.
Learning rate controls the step size during training.
Max depth limits the depth of each tree.
Subsample controls the fraction of observations to be randomly sampled for each tree.
Colsample by tree controls the fraction of features to be randomly sampled for each tree.
Other parameters include min child weight, gamma, and lambda for regularization.
Q66. What are all the off balance sheet items in banks ?
Off balance sheet items in banks are financial instruments or contingent liabilities that do not appear on the bank's balance sheet.
Loan commitments
Letters of credit
Derivatives contracts
Securitization transactions
Standby letters of credit
Q67. What is blending in Tableau ?
Blending in Tableau is combining data from multiple sources to create a single view.
Blending allows for analysis of data from different sources without the need for merging.
Data sources can be blended based on common fields or dimensions.
Blending can be used to create a single view with data from multiple sources.
Example: Blending sales data from Excel with customer data from a database to analyze customer behavior.
Example: Blending survey data from SurveyMonkey with sales da...read more
Q68. Using database commands and connection string in pega Openspan?
Pega Openspan supports database commands and connection string.
Database commands can be executed using the OLEDB connector in Pega Openspan.
Connection string can be defined in the configuration of the OLEDB connector.
Examples of database commands include SELECT, INSERT, UPDATE, and DELETE.
Connection string includes details such as server name, database name, and authentication mode.
Q69. Flexibility to support the BAU when there is some additional support.
I am willing to be flexible and provide additional support to ensure smooth BAU operations.
I understand the importance of BAU operations and will prioritize them accordingly.
I am willing to adjust my schedule to provide additional support when needed.
I will communicate effectively with my team to ensure everyone is aware of the additional support needed.
I will work collaboratively with other teams to ensure a seamless transition of support.
Examples: If a team member is out si...read more
Q70. What does KYC stand for and explain in detail?
KYC stands for Know Your Customer. It is a process of verifying the identity of a customer and assessing their potential risks.
KYC is a mandatory process for banks and financial institutions to prevent money laundering and terrorist financing.
It involves collecting personal information and documents such as ID proof, address proof, and PAN card.
The collected information is verified through various sources such as government databases and credit bureaus.
KYC also involves asses...read more
Q71. What types of banking services does standard chartered provide?
Standard Chartered provides a wide range of banking services including retail banking, corporate banking, wealth management, and investment banking.
Retail banking services such as savings accounts, credit cards, and personal loans
Corporate banking services including trade finance, cash management, and corporate lending
Wealth management services like investment advisory and portfolio management
Investment banking services such as mergers and acquisitions, capital raising, and a...read more
Q72. What is guarantee and it's type?
A guarantee is a promise or assurance that something will happen or be done. There are two types of guarantees: express and implied.
A guarantee is a form of assurance that a product or service will meet certain standards.
Express guarantees are explicitly stated, such as a warranty or money-back guarantee.
Implied guarantees are not explicitly stated but are assumed to exist, such as the guarantee of merchantability or fitness for a particular purpose.
Guarantees can also be con...read more
Q73. Can you provide opportunities for Bank's cybersecurity ?
Yes, regular security audits, employee training, and implementing advanced security measures can provide opportunities for Bank's cybersecurity.
Conduct regular security audits to identify vulnerabilities
Provide employee training on cybersecurity best practices
Implement advanced security measures such as multi-factor authentication and encryption
Partner with cybersecurity firms to stay up-to-date on the latest threats and solutions
Q74. Program for finding duplicates in a series of numbers without using pre-existing function
Q75. How would you test variable importance
Variable importance can be tested using various methods such as permutation importance, drop column importance, and SHAP values.
Permutation importance involves randomly shuffling the values of a variable and measuring the decrease in model performance.
Drop column importance involves removing a variable from the model and measuring the decrease in model performance.
SHAP values provide a measure of the contribution of each variable to the model output.
Other methods include corr...read more
Q76. What are the golden rules of accounting?
The golden rules of accounting are basic principles that guide the recording of financial transactions.
The first golden rule is the rule of debit and credit.
The second golden rule is the rule of consistency.
The third golden rule is the rule of conservatism.
The fourth golden rule is the rule of materiality.
The fifth golden rule is the rule of objectivity.
For example, the rule of debit and credit states that for every debit entry, there must be a corresponding credit entry.
The ...read more
Q77. What is OTC Derivatives clearing, house clearing vs client clearing.
OTC Derivatives clearing involves the process of mitigating counterparty risk by using a third-party clearinghouse.
OTC Derivatives clearing is the process of reducing counterparty risk by using a third-party clearinghouse.
House clearing involves the clearing of trades between two parties through a central clearinghouse.
Client clearing involves the clearing of trades between a client and a clearinghouse.
OTC Derivatives clearing is mandatory for certain types of derivatives und...read more
Q78. Difference between wait all and wait any ?
Wait all waits for all tasks to complete while wait any waits for any one task to complete.
Wait all is used when all tasks need to be completed before proceeding.
Wait any is used when any one task can complete before proceeding.
Wait all returns when all tasks complete while wait any returns when any one task completes.
Wait all can cause longer wait times if one task takes longer while wait any can be faster if one task completes quickly.
Q79. Important of SAS Macro.
SAS Macro is important for automating repetitive tasks and reducing code redundancy.
SAS Macro allows for parameterization of code, making it more flexible and reusable.
It can be used to automate repetitive tasks, saving time and effort.
Macro variables can be used to store and manipulate data, making code more efficient.
Macro functions can be used to perform complex calculations and data transformations.
SAS Macro can help reduce code redundancy and improve code maintainability...read more
Q80. What are Derivatives and its types?
Derivatives are financial contracts that derive their value from an underlying asset or security.
Types of derivatives include futures, options, swaps, and forwards.
Futures are contracts to buy or sell an asset at a predetermined price and date.
Options give the holder the right, but not the obligation, to buy or sell an asset at a predetermined price and date.
Swaps involve exchanging cash flows based on different financial instruments.
Forwards are similar to futures, but are c...read more
Q81. Whom you present your report
I present my report to my immediate supervisor and other relevant stakeholders.
Reports are presented to the immediate supervisor for review and approval.
Reports may also be presented to other stakeholders such as department heads or clients.
The presentation format may vary depending on the audience and purpose of the report.
Q82. What are decorators how do they work?
Q83. How to calculate EAD & PD?
EAD is calculated using the formula EAD = Exposure at Default = PD x LGD x EAD
Calculate Probability of Default (PD) based on historical data and credit rating
Determine Loss Given Default (LGD) based on collateral or recovery rate
Use the formula EAD = PD x LGD x EAD to calculate Exposure at Default
Q84. What amendment comes under guarantee?
The 9th Amendment guarantees rights not explicitly listed in the Constitution.
The 9th Amendment is part of the Bill of Rights.
It protects rights that are not specifically mentioned in the Constitution.
Examples of rights protected by the 9th Amendment include the right to privacy and the right to marry.
The 9th Amendment is often cited in cases involving reproductive rights and LGBTQ+ rights.
Q85. 1. What are the changes from Basel 2 to Basel 3
Basel 3 introduced stricter capital requirements and new liquidity standards compared to Basel 2.
Basel 3 increased the minimum common equity requirement from 2% to 4.5%
Basel 3 introduced a capital conservation buffer of 2.5%
Basel 3 introduced a countercyclical buffer of up to 2.5%
Basel 3 introduced new liquidity standards such as the Liquidity Coverage Ratio (LCR) and Net Stable Funding Ratio (NSFR)
Basel 3 expanded the scope of risk-weighted assets to include counterparty cre...read more
Q86. How you manage test data, design Automation framework, bdd, selenium
Test data is managed through a combination of manual and automated processes. Automation framework is designed using BDD and Selenium.
Test data is created and maintained in a separate database or spreadsheet
Automated scripts are designed to pull test data from the database or spreadsheet
Data is randomized or parameterized to ensure test coverage
Automation framework is designed using BDD principles to ensure collaboration between developers and testers
Selenium is used as the p...read more
Q87. What are the values of Standard Chartered
Standard Chartered values include integrity, teamwork, and excellence.
Integrity: acting with honesty and transparency in all dealings
Teamwork: collaborating and supporting each other to achieve common goals
Excellence: striving for the highest standards of performance and innovation
Examples: Standard Chartered's sustainability initiatives, employee volunteer programs, and commitment to diversity and inclusion
Q88. What is more measurable -P&l statement of cashflow statement
Cashflow statement is more measurable as it tracks actual cash inflows and outflows.
Cashflow statement tracks actual cash movements in and out of the business, making it more measurable than P&L statement which includes non-cash items like depreciation.
Cashflow statement helps in assessing the liquidity and solvency of a company by showing how much actual cash it generates and uses.
P&L statement can be manipulated through accounting practices, while cashflow statement provide...read more
Q89. What are the assumptions of linear regression?
Assumptions of linear regression include linearity, independence, homoscedasticity, and normality.
Linearity: The relationship between the independent and dependent variables is linear.
Independence: The residuals are independent of each other.
Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.
Normality: The residuals are normally distributed.
No multicollinearity: The independent variables are not highly correlated with ea...read more
Q90. Programmed application to pull the transaction that are triggered by the threshold.
I have experience in programming applications to pull transactions triggered by thresholds.
Utilize programming languages such as Python, SQL, or R to create scripts that monitor transactions
Set up automated alerts to notify relevant parties when threshold transactions occur
Implement filters and rules to accurately identify threshold-triggered transactions
Regularly test and update the application to ensure accuracy and efficiency
Q91. Difference between counterparty and credit risk?
Counterparty risk is the risk of default by a party in a financial transaction, while credit risk is the risk of loss due to a borrower's failure to repay a loan.
Counterparty risk is specific to financial transactions involving parties such as banks, brokers, or counterparties in derivatives contracts.
Credit risk is more general and refers to the risk of loss due to a borrower's failure to repay a loan or meet other financial obligations.
Counterparty risk is typically associa...read more
Q92. Using text adapters in pega robotics?
Text adapters are used in Pega Robotics to interact with text-based applications.
Text adapters can be used to read and write text from/to text-based applications.
They can be configured to recognize specific text patterns and respond accordingly.
Examples of text-based applications include command prompt, terminal, and text editors.
Text adapters can also be used in conjunction with other adapters, such as web adapters, to automate end-to-end processes.
Q93. What are the three steps in Money Laundering
The three steps in Money Laundering are placement, layering, and integration.
Placement: The initial stage where illegal funds are introduced into the financial system.
Layering: The process of moving the funds through a series of complex transactions to obscure the audit trail.
Integration: The final stage where the laundered funds are reintroduced into the legitimate economy.
Q94. How to change to date format in pandas
Q95. 1. Tell me about urself 2. How will ypu achieve targets
I am a results-driven business development manager with a proven track record of exceeding targets through strategic planning and relationship building.
Setting clear and achievable targets based on market analysis and company goals
Developing strong relationships with key clients and partners to drive sales
Implementing effective sales strategies and tactics to meet and exceed targets
Regularly monitoring progress towards targets and adjusting strategies as needed
Leveraging data...read more
Q96. The most difficult challenges faced, situation-based approach, dealing with ambiguous requirements
Dealing with ambiguous requirements and difficult challenges in a situation-based approach.
Identifying and clarifying ambiguous requirements through effective communication
Breaking down complex problems into smaller, manageable tasks
Adapting to changing priorities and tight deadlines
Collaborating with team members to brainstorm solutions
Using critical thinking and problem-solving skills to find innovative solutions
Managing expectations and balancing trade-offs between differe...read more
Q97. How to perform code review?
Code review involves examining code for errors, security vulnerabilities, and adherence to coding standards.
Start by understanding the requirements and design of the code.
Check for syntax errors, logic errors, and security vulnerabilities.
Ensure the code adheres to coding standards and best practices.
Provide constructive feedback to the developer.
Use code review tools to automate the process and save time.
Collaborate with the development team to ensure code quality.
Perform co...read more
Q98. What are the functions held in Back of the bank.
Functions held in Back of the bank include operations related to treasury management, risk management, compliance, and security.
Treasury management - handling cash flow, liquidity, and investments
Risk management - assessing and mitigating financial risks
Compliance - ensuring adherence to regulations and policies
Security - protecting assets and preventing fraud
Back office functions support front office operations
Q99. What is sansation countries
There is no such term as 'sansation countries'. It is likely a mispronunciation or misspelling of another term.
Q100. Why linux is faster than windows?
Linux is faster than Windows due to its lightweight design, efficient kernel, and open-source nature.
Linux has a more lightweight design compared to Windows, resulting in faster performance on older hardware.
The Linux kernel is more efficient at handling system resources, leading to quicker response times and lower latency.
Linux is open-source, allowing for constant optimization and customization by the community, which can improve performance over time.
More about working at Standard Chartered
Top HR Questions asked in null
Interview Process at null
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month