AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Barclays Shared Services Analyst BA4 Interview Questions and Answers
Barclays Shared Services Analyst BA4 Interview Experiences
1 interview found
I was interviewed in Aug 2017.
Interview Questionnaire
4 Questions
- Q1. Tell something about SOX(Sarbanes Oxley Act)
- Ans.
The Sarbanes-Oxley Act (SOX) is a US federal law enacted in 2002 to protect investors by improving the accuracy and reliability of corporate disclosures.
SOX was introduced in response to accounting scandals such as Enron and WorldCom.
It requires public companies to establish and maintain internal controls to ensure accurate financial reporting.
SOX mandates independent audits of financial statements by external auditors...
- Q2. Something about integrity, behavior
- Q3. Bank reconciliation statement
- Q4. Some case studies
Interview Preparation Tips
Experience: VP, Barclays was coordinating the GD.
He didn't speak a single word during GD regardless that discussion was getting out of the way.
Tips: Always listen to instructions carefully.
In my case there were many candidates who spoke good but not related to financial planning of bank and they were not selected
Duration: 20 minutes
Skills: Technical Questions
College Name: Icai
Top trending discussions
Interview questions from similar companies
RISHABH Pal
Selected
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
The Aptitude Test session accesses mathematical and logical reasoning abilities
(6 Questions)
- Q1. What is Vlookup
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
Vlookup stands for 'Vertical Lookup'
It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column
Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...
- Q2. Some IF else Question in Excel
- Q3. What does your day in your previous organization look like?
- Ans.
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
Reviewing and cleaning large datasets to ensure accuracy
Creating visualizations and reports to communicate insights
Collaborating with team members to identify trends and patterns
Presenting findings to stakeholders in meetings or presentations
- Q4. Could you share the technical skills you possess?
- Ans.
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
Proficient in programming languages such as Python, R, SQL
Skilled in statistical analysis and data modeling techniques
Experience with data visualization tools like Tableau, Power BI
Knowledge of machine learning algorithms and techniques
- Q5. Can you explain what a Pivot Table is?
- Ans.
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.
Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.
Pivot tables are commonly used in Excel and other spreadsheet program...
- Q6. Find the Highest-paid employee in each department along with their salary and department name.
- Ans.
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
Group employees by department
Find the employee with the highest salary in each group
Retrieve the employee's name, salary, and department name
Interview Preparation Tips
- SQL
- Excel
- Problem Solving
- PowerBI
- SQL Queries
Be prepared to discuss past challenges and how did you overcome.
Selected
I was interviewed in Dec 2024.
(1 Question)
- Q1. What can you expect from the first round of the interview, which involves a group discussion where you are given a topic to discuss in English for five minutes?
A basic aptitude test includes logical reasoning questions and percentage problems, comprising a total of ten questions, along with two paragraph-based questions.
(1 Question)
- Q1. Worst interview I have ever experienced, instead of asking questions about the role they are asking unwanted questions which are not related to the job. They are wantedly searching for a reason to reject y...
Interview Preparation Tips
Selected
I applied via Campus Placement
The test level is moderate
(2 Questions)
- Q1. Difference between c and java
- Ans.
C is a procedural language while Java is an object-oriented language.
C is a low-level language, closer to the hardware, while Java is a high-level language.
C requires manual memory management, while Java has automatic garbage collection.
C is compiled directly to machine code, while Java is compiled to bytecode and runs on a virtual machine.
C supports pointers, while Java does not.
C is used for system programming, embed...
- Q2. Excel shortcuts
(1 Question)
- Q1. Can you provide a self-introduction?
(2 Questions)
- Q1. What is the importance of data analysis?
- Ans.
Data analysis is crucial for making informed decisions, identifying trends, and solving complex problems.
Helps in making informed decisions based on data-driven insights
Identifies trends and patterns that can lead to strategic business decisions
Aids in solving complex problems by analyzing data to find root causes
Improves efficiency and effectiveness of processes through data-driven optimizations
- Q2. What steps should be taken to become a data analyst?
- Ans.
To become a data analyst, one should focus on acquiring relevant education, gaining experience with data analysis tools, and developing strong analytical and problem-solving skills.
Obtain a degree in a related field such as statistics, mathematics, computer science, or data science.
Gain experience with data analysis tools such as SQL, Python, R, and Excel.
Develop strong analytical and problem-solving skills by working ...
(2 Questions)
- Q1. Do you have any experience in writing user stories for system API definitions?
- Q2. What would your test scenario be for verifying the success of data migration?
Business Analyst Interview Questions & Answers
Sutherland Global Services
Anonymous
posted on 14 Nov 2024
I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.
Good and got time to keep my point
(2 Questions)
- Q1. What is your weakness
- Q2. How well you know python
- Ans.
I have a strong understanding of Python and have used it extensively in my previous projects.
Proficient in Python programming language
Experience in using Python for data analysis and visualization
Familiar with popular Python libraries such as Pandas, NumPy, and Matplotlib
Have developed scripts and automation tools using Python
Skills evaluated in this interview
(1 Question)
- Q1. Questions related to projects
(1 Question)
- Q1. Questions related to projects and some scenario based questions
Business Analyst Interview Questions & Answers
BNP Paribas India Solutions
Anonymous
posted on 9 May 2024
(1 Question)
- Q1. Which product do tou consider you have the strongest knowledge about and explain its product life cycle
(3 Questions)
- Q1. What have you done in your past role
- Q2. Your previous salary and expiration
- Q3. When can you join
Interview Preparation Tips
Business Analyst Interview Questions & Answers
Optum Global Solutions
Anonymous
posted on 11 Sep 2024
They start with sequel then slide you move to python
Start with aptitude test and asking to detail regarding the study case
Barclays Shared Services Interview FAQs
Tell us how to improve this page.
Barclays Shared Services Interviews By Designations
- Barclays Shared Services Process Advisor Interview Questions
- Barclays Shared Services Business Analyst Interview Questions
- Barclays Shared Services Senior Process Advisor Interview Questions
- Barclays Shared Services Accounts Manager Interview Questions
- Barclays Shared Services AML Analyst Interview Questions
- Barclays Shared Services Analyst Interview Questions
- Barclays Shared Services Analyst BA4 Interview Questions
- Barclays Shared Services Assistant Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Analyst Interview Questions
- Business Analyst Interview Questions
- Data Analyst Interview Questions
- Senior Analyst Interview Questions
- Financial Analyst Interview Questions
- Quality Analyst Interview Questions
- Investment Banking Analyst Interview Questions
- Programmer Analyst Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Barclays Shared Services Analyst BA4 Reviews and Ratings
based on 1 review
Rating in categories
|
Process Advisor
685
salaries
|  ₹1 L/yr - ₹7.1 L/yr |
|
Assistant Manager
508
salaries
| ₹7 L/yr - ₹20 L/yr |
|
Assistant Vice President
441
salaries
| ₹13.5 L/yr - ₹40.1 L/yr |
|
Senior Analyst
343
salaries
| ₹3.8 L/yr - ₹11.5 L/yr |
|
Process Associate
176
salaries
| ₹1 L/yr - ₹6.7 L/yr |
HSBC Group
JPMorgan Chase & Co.
Standard Chartered
Deutsche Bank
- Home >
- Interviews >
- Barclays Shared Services Interview Questions >
- Barclays Shared Services Analyst BA4 Interview Questions
