i
Standard
Chartered
Filter interviews by
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.
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
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.
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...
What people are saying about Standard Chartered
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 spec...
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 behavio...
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
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
The Big 6 Regulators are the six major regulatory bodies in the UK.
The Financial Conduct Authority (FCA) regulates financial services
The Prudential Regulation Authority (PRA) supervises financial institutions
Ofgem regulates gas and electricity markets
Ofcom regulates the communications industry
The Office for Nuclear Regulation (ONR) regulates nuclear safety
The Environment Agency regulates environmental issues
These ...
In a challenging situation, I would assess, communicate, and implement a solution while ensuring customer satisfaction.
Assess the situation: Gather all relevant information to understand the problem.
Communicate effectively: Keep the customer informed about the steps being taken.
Implement a solution: Take decisive action to resolve the issue promptly.
Follow up: Ensure the customer is satisfied with the resolution a...
I appeared for an interview in Jun 2025, where I was asked the following questions.
In 10 years, I envision myself as a leader in business development, driving strategic initiatives and mentoring future talent.
I aim to progress to a senior management role, overseeing a team of business development professionals.
I plan to develop expertise in emerging markets, identifying new opportunities for growth and expansion.
I aspire to build strong relationships with key stakeholders and partners, enhancing coll...
I am highly motivated to secure this position, driven by my passion for business development and my desire to contribute to the company's growth.
I have a proven track record in identifying new business opportunities, as demonstrated by my previous role where I increased sales by 30%.
I am eager to learn and adapt, having taken the initiative to complete courses in negotiation and strategic planning to enhance my skills.
...
My salary expectations are based on my experience, skills, and the market rate for this position.
Research the average salary range for Technical Leads in the industry and location
Consider your years of experience and level of expertise
Factor in any additional benefits or perks offered by the company
I applied via Approached by Company and was interviewed in Oct 2024. There were 6 interview rounds.
Logical, react, SQL related questions
I applied via Referral
In my current role, I am responsible for leading business analysis activities, gathering requirements, conducting stakeholder interviews, and creating functional specifications.
Leading business analysis activities
Gathering requirements from stakeholders
Conducting stakeholder interviews
Creating functional specifications
Collaborating with cross-functional teams
Yes, I am committed to a long-term position with the bank.
I have a strong track record of long-term employment with previous companies.
I am excited about the opportunity to grow and develop within the bank.
I am dedicated to contributing to the success and growth of the bank.
I am willing to invest my time and effort into building a successful career with the bank.
I applied via LinkedIn and was interviewed in Nov 2024. There were 2 interview rounds.
Only we can determine how easy it was.
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
I have a Bachelor's degree in Statistics from XYZ University.
I have 3 years of experience working as a data analyst at ABC Company.
I am proficient in using statistical software such as R and Python for data analysis.
I have a proven track record of delivering actionable insights to drive business decisions.
posted on 1 Dec 2024
I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.
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
A forward rate agreement (FRA) is a financial contract between two parties to exchange interest rate payments based on a specified notional amount and a predetermined interest rate.
FRA is a derivative contract where one party agrees to pay a fixed interest rate while the other party agrees to pay a floating interest rate based on a notional amount.
It helps in hedging against interest rate risk by locking in a future in...
LCR & NSFR are regulatory requirements that banks must meet to ensure they have enough liquidity to withstand financial stress.
LCR stands for Liquidity Coverage Ratio and measures a bank's ability to meet its short-term obligations with high-quality liquid assets.
NSFR stands for Net Stable Funding Ratio and assesses a bank's long-term stability by comparing available stable funding to required stable funding.
The pu...
I applied via LinkedIn and was interviewed in Dec 2024. There were 3 interview rounds.
Passed all the round
Passed all the round
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
Just a normal aptitude test
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 service...
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 servi...
Nostro reconciliation is the process of ensuring that the bank's records of its accounts with other banks match the records of those banks.
Nostro reconciliation involves comparing the bank's records of its accounts with other banks to the records provided by those banks.
It helps in identifying any discrepancies or errors in the transactions between the banks.
The process involves investigating and resolving any differen...
2 questions were asked followed by a behavioral test
Merge sort is a divide-and-conquer algorithm that sorts an array by recursively splitting and merging sorted subarrays.
1. Divide the array into two halves until each subarray contains a single element.
2. Merge the subarrays back together in sorted order.
3. Example: For array [38, 27, 43, 3, 9, 82, 10], split into [38, 27, 43] and [3, 9, 82, 10].
4. Continue splitting until you have [38], [27], [43], [3], [9], [82], [10]...
I want to join SCB because of its reputation for innovation and global presence.
SCB is known for its innovative approach to banking and financial services
I am impressed by SCB's global network and opportunities for growth
I believe SCB will provide me with valuable experience and skills for my future career
I selected SC because of its strong reputation in the industry and the exciting opportunities for growth. Yes, I have received an offer.
Strong reputation in the industry
Exciting opportunities for growth
Received an offer
Some of the top questions asked at the Standard Chartered interview -
The duration of Standard Chartered interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 258 interview experiences
Difficulty level
Duration
based on 5.1k reviews
Rating in categories
Team Lead
2.5k
salaries
| ₹4.8 L/yr - ₹11 L/yr |
Associate Manager
2.4k
salaries
| ₹8.8 L/yr - ₹15.4 L/yr |
Senior Officer
2.3k
salaries
| ₹3.1 L/yr - ₹7.3 L/yr |
Manager
2.1k
salaries
| ₹14.3 L/yr - ₹24.4 L/yr |
Senior Manager
2.1k
salaries
| ₹21.8 L/yr - ₹38 L/yr |
HDFC Bank
ICICI Bank
Axis Bank
Kotak Mahindra Bank