Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Standard Chartered Team. If you also belong to the team, you can get access from here

Standard Chartered Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Standard Chartered Senior Analyst Interview Questions, Process, and Tips

Updated 6 May 2024

Top Standard Chartered Senior Analyst 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 s ...read more
  • Q2. What are the programing tools you know ? Rate yourself ( out of 5 )
  • Q3. How to remove duplicate Records by using first. And last. ?
View all 19 questions

Standard Chartered Senior Analyst Interview Experiences

6 interviews found

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I was interviewed in Apr 2024.

Round 1 - Aptitude Test 

General cultural fit test

Round 2 - Technical 

(1 Question)

  • Q1. Basics of AML and KYC
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(13 Questions)

  • Q1. What are the programing tools you know ? Rate yourself ( out of 5 )
  • Ans. 

    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

  • Answered by AI
  • Q2. Important of SAS Macro.
  • Ans. 

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

  • Answered by AI
  • Q3. How to create macro variables?
  • Ans. 

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

  • Answered by AI
  • Q4. How to get different dataset from existing one ?
  • Ans. 

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

  • Answered by AI
  • Q5. How to remove null values in numeric data types?
  • Ans. 

    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.

  • Answered by AI
  • Q6. Difference between add and sum function
  • Ans. 

    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

  • Answered by AI
  • Q7. Use of retain statement.
  • Ans. 

    Retain statement is used to store the value of a variable across iterations of a data step.

    • Retain statement is used to keep the value of a variable from one iteration of a data step to the next.

    • It is commonly used to calculate running totals or to keep track of previous values.

    • Retain statement is placed before the SET statement in a data step.

    • Example: retain total; total + sales; output;

    • Retain statement can also be use...

  • Answered by AI
  • Q8. How to remove duplicate Records by using first. And last. ?
  • Ans. 

    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.

  • Answered by AI
  • Q9. How to get cumulative salary from a employee table ?
  • Ans. 

    To get cumulative salary from an employee table, you can use SQL aggregate function SUM() along with GROUP BY clause.

    • Write a SQL query to select the employee ID and the sum of their salaries from the employee table.

    • Use the SUM() function to calculate the cumulative salary for each employee.

    • Group the results by employee ID using the GROUP BY clause.

    • The query should look like: SELECT employee_id, SUM(salary) FROM employe...

  • Answered by AI
  • Q10. How Tableau get data from SAS environment?
  • Ans. 

    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.

  • Answered by AI
  • Q11. What is calculative field in SAS
  • Ans. 

    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.

  • Answered by AI
  • Q12. What is blending in Tableau ?
  • Ans. 

    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.

    • Exa...

  • Answered by AI
  • Q13. What are the different filters in Tableau you use.
  • Ans. 

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

  • Answered by AI
Round 3 - Behavioral 

(9 Questions)

  • Q1. What is Datamart and Data warehouse
  • Ans. 

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

  • Answered by AI
  • Q2. What are the cleansing process you used
  • Ans. 

    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

  • Answered by AI
  • Q3. Difference between CSV and Excel file
  • Ans. 

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

  • Answered by AI
  • Q4. How you manage your time ?
  • Q5. What are the different dashboard you prepared till now
  • Ans. 

    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

  • Answered by AI
  • Q6. Who are your stakeholders
  • Q7. Whom you present your report
  • Ans. 

    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.

  • Answered by AI
  • Q8. What type of adhoc report you get from client side ?
  • Ans. 

    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.

  • Answered by AI
  • Q9. What is your day to day activities

Interview Preparation Tips

Topics to prepare for Standard Chartered Senior Analyst interview:
  • SAS
  • Tableau
Interview preparation tips for other job seekers - Be Cool and Calm
Go through your resume
Before speak listen properly

Skills evaluated in this interview

Senior Analyst Interview Questions Asked at Other Companies

Q1. Explain 3 statement financial model Calculating discount rate Cou ... read more
Q2. Tell me about your profile? What do you know about Transaction Mo ... read more
asked in Accenture
Q3. What do you understand by Budgeting and Forecasting?
Q4. Q4. What is the probability of getting 5 Sundays in 31 day month.
Q5. Q4. You are standing in a field. Chances of seeing atleast 1 plan ... read more
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(2 Questions)

  • Q1. Qualification and education
  • Q2. AML background questions
Round 3 - Aptitude Test 

General questions on aml and other red flags sanctions

Round 4 - Case Study 

AML transactions monitoring case study

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough in aml concepts and sanctions and due diligence techniques

I applied via LinkedIn and was interviewed in Jun 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

Online assessment on behaviour

Round 3 - One-on-one 

(1 Question)

  • Q1. Technically question will be asked
Round 4 - HR 

(1 Question)

  • Q1. Hr decision will take place

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best ! SCB is a nice place to work

Standard Chartered interview questions for designations

 Analyst

 (3)

 Senior Financial Analyst

 (2)

 Senior Analyst 1

 (1)

 Business Analyst

 (4)

 Data Analyst

 (3)

 Senior AML KYC Analyst

 (2)

 AML Analyst

 (3)

 Financial Analyst

 (2)

I applied via LinkedIn and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • 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 whi...
  • Ans. 

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

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Standard Chartered Senior Analyst interview:
  • Aml
  • Anti Money Laundering
  • KYC
  • Sanction
Interview preparation tips for other job seekers - Be confident and answer every question.

Get interview-ready with Top Standard Chartered Interview Questions

Senior Analyst Interview Questions & Answers

user image Nithya jegan

posted on 10 Mar 2021

I was interviewed in Feb 2021.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself, brief about your resume and previous company experience if ur experience candidate, and some questions regarding the process to r hiring , and why do u left the previous job

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and polite and don't get tensed every for any interview and most the question which are asked are previous experience and resume type of question please always know the things that u put in your resume and don't put unnecessary things which u don't have idea about it

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Aptitude Test 

General mathematics & english

Round 2 - Group Discussion 

Common topics for GD but unsure if its conducted lately

Round 3 - One-on-one 

(2 Questions)

  • Q1. Why did you choose natwest
  • Q2. What was the reason you left your last organisation
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. How to stop and start JVMs from backend in a WAS. What is the best practice to be followed for the restart of JVMs?
  • Ans. 

    To stop and start JVMs in a WAS backend, use administrative console or scripting. Best practice is to perform rolling restarts.

    • Use administrative console to stop and start JVMs individually or in a cluster

    • Use scripting (such as wsadmin) for automation and bulk operations

    • Perform rolling restarts to minimize downtime and ensure high availability

    • Monitor JVM health and performance before and after restarts

  • Answered by AI
  • Q2. Create a script which will delete the files older than 7 days in a linux vm.
  • Ans. 

    Script to delete files older than 7 days in a Linux VM

    • Use the find command to locate files older than 7 days

    • Pipe the output of find to the rm command to delete the files

    • Make sure to test the script in a safe environment before running it on important files

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Tell me your education
Round 2 - HR 

(2 Questions)

  • Q1. What is your name
  • Q2. Tell me about yoursf

Interview Preparation Tips

Interview preparation tips for other job seekers - Ghjjn
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain your role and responsibilities in previous organisation
  • Ans. 

    Managed data analysis projects, conducted market research, and provided insights for decision-making.

    • Led cross-functional teams to analyze market trends and competitor performance

    • Developed forecasting models to predict sales and revenue

    • Presented findings and recommendations to senior management

    • Collaborated with stakeholders to define project scope and objectives

  • Answered by AI
  • Q2. Why do you want to leave your current job
  • Ans. 

    Seeking new challenges and growth opportunities

    • Looking for a more challenging role to further develop my skills

    • Interested in exploring new industries or sectors

    • Seeking better work-life balance or company culture

    • Want to take on more responsibilities and leadership roles

    • Current job lacks opportunities for career advancement

  • Answered by AI
Round 2 - One-on-one 

(3 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    Experienced Senior Analyst with a background in financial analysis and data interpretation.

    • Over 5 years of experience in analyzing financial data and providing insights to drive business decisions

    • Proficient in using various analytical tools and software such as Excel, Tableau, and SQL

    • Strong communication skills to effectively present findings and recommendations to stakeholders

    • Proven track record of improving operation...

  • Answered by AI
  • Q2. Why are you changing your job
  • Ans. 

    Seeking new challenges and opportunities for growth in a different environment.

    • Desire for career advancement

    • Seeking new challenges

    • Opportunity for professional growth

    • Change in work environment

    • Exploring new industries or sectors

  • Answered by AI
  • Q3. How comfortable are you in working in early morning shifts
  • Ans. 

    I am very comfortable working in early morning shifts and have experience doing so in previous roles.

    • I am a morning person and find that I am most productive during early hours

    • I have worked early morning shifts in my previous job as a financial analyst

    • I am able to adjust my schedule to accommodate early morning shifts

    • I understand the importance of being punctual and reliable in a professional setting

  • Answered by AI

Standard Chartered Interview FAQs

How many rounds are there in Standard Chartered Senior Analyst interview?
Standard Chartered interview process usually has 3 rounds. The most common rounds in the Standard Chartered interview process are Resume Shortlist, Aptitude Test and HR.
How to prepare for Standard Chartered Senior Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Standard Chartered. The most common topics and skills that interviewers at Standard Chartered expect are Aml, Due Diligence, Anti Money Laundering, Compliance and Finance.
What are the top questions asked in Standard Chartered Senior Analyst interview?

Some of the top questions asked at the Standard Chartered Senior Analyst interview -

  1. Tell me about your profile? What do you know about Transaction Monitoring ? Wha...read more
  2. What are the programing tools you know ? Rate yourself ( out of ...read more
  3. How to remove duplicate Records by using first. And last...read more

Tell us how to improve this page.

Standard Chartered Senior Analyst Interview Process

based on 3 interviews

1 Interview rounds

  • Resume Shortlist Round
View more
Standard Chartered Senior Analyst Salary
based on 1.9k salaries
₹2 L/yr - ₹9 L/yr
36% less than the average Senior Analyst Salary in India
View more details

Standard Chartered Senior Analyst Reviews and Ratings

based on 132 reviews

4.0/5

Rating in categories

3.9

Skill development

4.0

Work-life balance

3.3

Salary

4.2

Job security

4.0

Company culture

3.0

Promotions

3.7

Work satisfaction

Explore 132 Reviews and Ratings
Team Lead
2.5k salaries
unlock blur

₹4.1 L/yr - ₹13.3 L/yr

Associate Manager
2.3k salaries
unlock blur

₹5.2 L/yr - ₹20 L/yr

Senior Officer
2.3k salaries
unlock blur

₹1.8 L/yr - ₹7.3 L/yr

Manager
2k salaries
unlock blur

₹7 L/yr - ₹29 L/yr

Senior Analyst
1.9k salaries
unlock blur

₹2 L/yr - ₹9 L/yr

Explore more salaries
Compare Standard Chartered with

HSBC Bank

4.0
Compare

ICICI Bank

4.0
Compare

HDFC Bank

3.9
Compare

Axis Bank

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview