Standard Chartered Interview Questions, Process, and Tips

Q1. Tell about CSS3 Flexbox
Ans. 
CSS3 Flexbox is a layout module that provides a more efficient way to design and align elements in a container.
• Flexbox allows for flexible and responsive layouts without the need for complex CSS hacks.

• It uses a parent-child relationship where the parent element is the flex container and the child elements are flex items.

• Flexbox provides properties such as flex-direction, justify-content, align-items, and align-self to ...read more
Answered by AI
Add your answer
Q2. Tell about Angular Directives
Ans. 
Angular directives are markers on a DOM element that tell AngularJS to attach a specified behavior to that DOM element.
• Directives are used to create custom HTML tags that serve as new, reusable widgets.

• They can be used to manipulate the DOM, add event listeners, and create reusable components.

• Some built-in directives include ng-model, ng-repeat, and ng-show.

• Directives can be restricted to only apply to certain types of...read more
Answered by AI
Add your answer
Q3. Tell about Angular pipe
Ans. 
Angular pipe is a feature that allows transforming data before displaying it in the view.
• Pipes are used to format, filter, and transform data.

• They can be used in interpolation, property binding, and directive binding.

• Built-in pipes include DatePipe, UpperCasePipe, and CurrencyPipe.

• Custom pipes can be created using the @Pipe decorator.
Answered by AI
Add your answer
Q4. Tell about Angular Components
Ans. 
Angular Components are the building blocks of Angular applications.
• Components are reusable and self-contained

• They have a template, styles, and logic

• They can communicate with other components using @Input and @Output decorators

• Examples include navbar, sidebar, login form, etc.
Answered by AI
Add your answer
Q5. Tell about Angular Routes
Ans. 
Angular Routes are used to navigate between different components and views in an Angular application.
• Routes are defined in the app-routing.module.ts file

• Each route maps a URL path to a component

• Routes can have parameters and child routes

• Navigation between routes can be done using routerLink directive or programmatically using Router service
Answered by AI
Add your answer
Q6. Tell about Observables
Ans. 
Observables are a way to handle asynchronous data streams in Angular.
• Observables are used extensively in Angular for handling events, HTTP requests, and other asynchronous operations.

• They are similar to Promises, but can emit multiple values over time.

• Observables can be transformed and combined using operators like map, filter, and merge.

• They can also be subscribed to, which allows you to receive and handle the emitted...read more
Answered by AI
Add your answer
Q7. Tell about Subjects in RXJS
Ans. 
Subjects are a type of Observable that can multicast to multiple Observers.
• Subjects act as both an Observable and an Observer

• They can emit values to multiple subscribers

• There are four types of Subjects: BehaviorSubject, ReplaySubject, AsyncSubject, and Subject

• Subjects can be used for event handling, state management, and more
Answered by AI
Add your answer

Data structures and computer fundamentals

Q1. Data structures
Add your answer
Q2. Medium leetcode
Add your answer

It was a psychometric , value based and coding test

It was a valued behaviour assessment

It has technical questions

Algorithms and data structures questions similar to leetcode

Q1. Here also data structures and Algorithms plus java questions
Add your answer

Q1. Questions asked based on end user perpective.
Add your answer

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
View 1 more amswer
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...read more
Answered by AI
Add your answer
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
Add your answer
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...read more
Answered by AI
Add your answer
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
View 1 more amswer
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
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer
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...read more
Answered by AI
Add your answer
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
Add your answer
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
Add your answer
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...read more
Answered by AI
Add your answer
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 ...read more
Answered by AI
View 1 more amswer

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 ...read more
Answered by AI
Add your answer
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
Add your answer
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 ...read more
Answered by AI
Add your answer
Q4. How you manage your time ?
Add your answer
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
Add your answer
Q6. Who are your stakeholders
Add your answer
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
Add your answer
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
Add your answer
Q9. What is your day to day activities
Add your answer