Barclays Global Service Centre
30+ Barclays Global Service Centre Interview Questions and Answers
Q1. What is Live Vs Extract in Tableau? What is the file generated during extract and why is it faster than Live?
Live vs Extract in Tableau and why Extract is faster
Live connection directly queries the data source while Extract creates a static snapshot of the data
Extracts are faster because they reduce the amount of data transferred over the network
Extracts can be scheduled to refresh at specific intervals
Extracts can be compressed to reduce file size and improve performance
Q2. How to show Top 10 and Bottom 10 Rankings in single Worksheet
Use a parameter to filter data and create two separate tables, then combine them using a union.
Create a parameter to select the number of top and bottom rankings to display
Create a table for the top rankings using the parameter and the RANKX function
Create a table for the bottom rankings using the parameter and the RANKX function
Combine the two tables using a union
Add a column to differentiate between top and bottom rankings
Q3. What are Dashboard Actions and what are the steps to apply Dashboard actions?
Dashboard Actions are interactive elements that allow users to interact with the data on a dashboard.
Dashboard Actions are used to filter, highlight, or navigate to other dashboards or web pages.
Steps to apply Dashboard Actions include selecting the element to apply the action to, choosing the type of action, and configuring the action settings.
Examples of Dashboard Actions include clicking on a chart to filter the data displayed on other charts, hovering over a data point to...read more
Q4. What is the difference between Relationships and Joins in Tableau?
Relationships are used to connect tables in Tableau Prep while Joins are used to combine tables in Tableau Desktop.
Relationships are used in Tableau Prep to connect tables based on common fields.
Joins are used in Tableau Desktop to combine tables based on common fields.
Relationships are used to create a flow of data between tables in Tableau Prep.
Joins are used to create a single table from multiple tables in Tableau Desktop.
Relationships are used to reduce data duplication a...read more
Q5. How can you improve speed of Data Extractions in Tableau?
Optimize data source, reduce number of rows/columns, use extracts, optimize queries, use filters.
Optimize data source by removing unnecessary columns and rows
Reduce number of rows and columns to only necessary data
Use extracts instead of live connections
Optimize queries by using custom SQL or aggregating data
Use filters to limit the amount of data being extracted
Q6. How do you handle large data extracts in Tableau?
Large data extracts in Tableau are handled by optimizing data sources, using filters, and aggregating data.
Optimize data sources by removing unnecessary columns and filtering data before extracting.
Use filters to limit the amount of data extracted.
Aggregate data to reduce the number of rows and columns.
Consider using Tableau's data engine to improve performance.
Use incremental extracts to only extract new or updated data.
Schedule extracts to run during off-peak hours.
Consider...read more
Q7. Is it possible to update data in Tableau Extract?
Yes, it is possible to update data in Tableau Extract.
Tableau Extracts can be refreshed to update data
Data can be added, removed or modified in the data source and then refreshed in Tableau
Extracts can be set to refresh automatically or manually
Q8. What is difference between Sets and Group?
Sets are a collection of unique values while groups are a collection of related values.
Sets contain only unique values while groups can have repeated values.
Sets are used for filtering data while groups are used for aggregating data.
Sets are used in Tableau for creating custom fields while groups are used for creating hierarchies.
Example of a set: a set of customers who have made a purchase in the last month.
Example of a group: grouping sales data by region or product categor...read more
Q9. What are the types of risks faced by an organisation?
Organisations face various types of risks that can impact their operations and success.
Financial risks such as market fluctuations, credit risks, and liquidity risks
Operational risks such as system failures, supply chain disruptions, and human errors
Reputational risks such as negative publicity, loss of customer trust, and legal issues
Compliance risks such as regulatory changes, data privacy laws, and anti-corruption laws
Strategic risks such as competition, technological adva...read more
Q10. How is ROTE calculatef. What is Debt Equity ratio
ROTE is calculated by dividing net income by average shareholder's equity. Debt Equity ratio is calculated by dividing total debt by shareholder's equity.
ROTE stands for Return on Tangible Equity
ROTE is a measure of a company's profitability
Debt Equity ratio indicates the proportion of debt and equity used to finance a company's assets
A high Debt Equity ratio indicates a company is relying more on debt to finance its operations
ROTE and Debt Equity ratio are important financia...read more
Q11. What is governance? Enterprise wide Risk Framework
Governance is the process of managing and controlling an organization to achieve its objectives and ensure compliance with laws and regulations.
Governance involves setting policies, procedures, and guidelines for decision-making and accountability.
It includes monitoring and evaluating performance, managing risks, and ensuring compliance with laws and regulations.
An enterprise-wide risk framework is a structured approach to identifying, assessing, and managing risks across an ...read more
Q12. Describe the Barclays values in your words and rank them according to you
Barclays values include respect, integrity, service, excellence, and stewardship.
Respect - treating others with dignity and consideration
Integrity - being honest and transparent in all actions
Service - putting clients and customers first
Excellence - striving for the highest quality in everything
Stewardship - taking responsibility for the impact on society and the environment
Q13. What do you know about barclays?
Barclays is a British multinational investment bank and financial services company.
Barclays was founded in 1690 in London, England.
It is one of the largest banks in the world, with operations in over 40 countries.
Barclays offers a wide range of financial services including retail banking, investment banking, and wealth management.
The bank has faced controversies in the past, such as the Libor scandal in 2012.
Q14. Describe the 5 Barclays values in your words and rank them according to you
Barclays values include Respect, Integrity, Service, Excellence, and Stewardship. I rank them as Integrity, Excellence, Respect, Service, and Stewardship.
Integrity - Upholding honesty and ethical behavior in all actions
Excellence - Striving for the highest quality and performance in everything
Respect - Valuing diversity, inclusion, and treating others with dignity
Service - Putting clients and customers at the heart of everything
Stewardship - Taking responsibility for the long...read more
Q15. What do you understand by risk and control
Risk refers to potential events or circumstances that may have a negative impact on an organization, while control refers to measures put in place to mitigate or manage those risks.
Risk is the possibility of harm or loss arising from internal or external factors.
Controls are procedures, policies, or mechanisms implemented to reduce the likelihood or impact of risks.
Examples of risks include financial fraud, cybersecurity breaches, and regulatory non-compliance.
Examples of con...read more
Q16. Explain a situation where you had to convince stakeholder to modify original requirement as per technology need
Convincing stakeholders to modify requirements based on technology needs.
Identify the technology limitations or opportunities
Gather data and evidence to support the need for modification
Communicate the benefits and risks of modifying the requirement
Collaborate with stakeholders to find a mutually agreeable solution
Ensure proper documentation and communication of the modified requirement
Q17. Which SIEM you have worked on and tell the architecture
I have worked on Splunk SIEM which follows a distributed architecture with forwarders, indexers, and search heads.
Splunk SIEM follows a distributed architecture with forwarders, indexers, and search heads.
Forwarders collect and forward log data to indexers for storage and analysis.
Indexers store and index the data for fast search and retrieval.
Search heads provide a user interface for searching and analyzing the indexed data.
Q18. Design patterns and their applications in Java frameworks
Design patterns are reusable solutions to common software problems. Java frameworks use various design patterns to improve code quality and maintainability.
Java frameworks like Spring and Hibernate use the Singleton pattern to ensure only one instance of a class is created.
The Factory pattern is used to create objects without exposing the creation logic to the client.
The Observer pattern is used to notify multiple objects when a change occurs in a subject object.
The Decorator...read more
Q19. Technologies you are good at including automation tools
I am proficient in automation tools such as Selenium, Appium, and JMeter.
Proficient in Selenium for web automation
Experience with Appium for mobile automation
Skilled in JMeter for performance testing
Familiar with Jenkins for continuous integration
Knowledgeable in Git for version control
Q20. What is leverage?
Leverage refers to the use of borrowed funds to increase the potential return on an investment.
Leverage allows investors to make larger investments than they would be able to with their own funds.
It can amplify both gains and losses.
Common examples of leverage include margin trading and using options contracts.
High levels of leverage can be risky and lead to significant losses.
Leverage is often used in real estate investing to purchase properties with a small down payment.
Q21. What is RWA?
RWA stands for Risk Weighted Assets, which is a measure of the risk that a bank's assets pose to its solvency.
RWA is used to determine the amount of capital that a bank must hold to cover its risks.
It takes into account the credit risk, market risk, and operational risk of a bank's assets.
Higher risk assets have a higher RWA, which means the bank must hold more capital to cover those risks.
RWA is calculated using a standardized approach or an internal ratings-based approach.
R...read more
Q22. How good with escalation handling and prioritization
I have extensive experience in handling escalations and prioritizing tasks effectively.
I have a proven track record of successfully managing escalations by identifying root causes and implementing solutions in a timely manner.
I prioritize tasks based on urgency, impact, and stakeholder needs to ensure efficient delivery of projects.
I communicate effectively with stakeholders to manage expectations and provide regular updates on escalations and priorities.
I have experience usi...read more
Q23. How do we test IFC
IFC can be tested through automated and manual testing methods.
Automated testing can be done using tools like BIMTester and Solibri Model Checker.
Manual testing involves reviewing the IFC file for compliance with industry standards.
Testing should cover aspects like geometry, data, and relationships between objects.
Testing should also ensure that the IFC file can be imported and exported without errors.
Q24. 2. How multiple requests are handled in API call
Q25. Values of Barclays
Barclays values include respect, integrity, service, excellence, and stewardship.
Respect for all individuals
Integrity in all actions
Service to customers and communities
Excellence in everything they do
Stewardship of the environment and society
Q26. Design a car parking System
A car parking system that efficiently manages parking spaces and payments.
Utilize sensors to detect available parking spaces
Implement a payment system for users
Include a mobile app for users to check availability and reserve spots
Use barriers or gates to control access to the parking lot
Q27. Difference between impairment and depreciation
Impairment is a sudden decrease in the value of an asset, while depreciation is the gradual decrease in value over time.
Impairment is usually caused by external factors such as market conditions or physical damage.
Depreciation is a systematic allocation of the cost of an asset over its useful life.
Impairment is recognized when the carrying amount of an asset exceeds its recoverable amount.
Depreciation is calculated based on factors like the asset's cost, salvage value, and us...read more
Q28. Create accordion
An accordion is a UI component that expands and collapses content sections when clicked.
Use HTML, CSS, and JavaScript to create the accordion
Each section should have a header and content that can be toggled
Utilize event listeners to handle the click event and toggle the visibility of content
Q29. 1. Internal working of collections
Q30. how to automatr microservices
Automating microservices involves using tools like Docker, Kubernetes, and CI/CD pipelines.
Use containerization tools like Docker to package microservices into containers.
Utilize orchestration tools like Kubernetes to manage and scale microservices.
Implement CI/CD pipelines to automate testing, deployment, and monitoring of microservices.
Use tools like Jenkins, GitLab CI, or CircleCI for continuous integration and delivery.
Leverage monitoring tools like Prometheus and Grafana...read more
Q31. 3. Working of Java Container
Q32. What is DNS and DDNS
DNS stands for Domain Name System, which translates domain names to IP addresses. DDNS is Dynamic DNS, which automatically updates DNS records.
DNS is a system that translates domain names to IP addresses to locate resources on the internet
DDNS is a type of DNS that automatically updates DNS records when an IP address changes
DNS is essential for browsing the web, sending emails, and other internet activities
DDNS is commonly used for remote access to devices with changing IP ad...read more