Premium Employer

i

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

Lloyds Technology Centre

Compare button icon Compare button icon Compare
3.5

based on 60 Reviews

Filter interviews by

Lloyds Technology Centre Senior Data Analyst Interview Questions and Answers

Updated 1 Oct 2024

Lloyds Technology Centre Senior Data Analyst Interview Experiences

2 interviews found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Previous experiance and challenges
  • Ans. 

    I have over 5 years of experience as a Data Analyst, working on various projects and overcoming challenges.

    • Experience in analyzing large datasets and extracting valuable insights

    • Challenges include dealing with incomplete or messy data, and finding creative solutions to data-related problems

    • Proficient in using tools like SQL, Python, and Tableau to manipulate and visualize data

    • Experience in presenting findings to stakeh

  • Answered by AI
  • Q2. How well we handle situation in a team
  • Ans. 

    I excel in handling situations in a team by fostering open communication, collaboration, and problem-solving.

    • I prioritize open communication within the team to ensure everyone is on the same page.

    • I encourage collaboration and teamwork to leverage diverse perspectives and skills.

    • I am adept at problem-solving and conflict resolution to address any challenges that may arise.

    • I remain calm under pressure and strive to maint...

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Coding Test 

Multiple choice questions test assessment

Senior Data Analyst Interview Questions Asked at Other Companies

Q1. What is the difference between Least Squares Method and the maxim ... read more
Q2. How do you improve the performance of Linear Regression
asked in Proftware
Q3. Imagine you are presented with a complex dataset from a multinati ... read more
Q4. How do you handle overfitting and underfitting in Decision Trees
Q5. What metrics do you use to evaluate classification models

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 - Aptitude Test 

Questions mainly based on capital market

Round 3 - Technical 

(5 Questions)

  • Q1. Question mainly based on 3 financial statements
  • Q2. Link between 3 financial statements
  • Ans. 

    The link between the 3 financial statements (Income Statement, Balance Sheet, Cash Flow Statement) is that they are interconnected and provide a comprehensive view of a company's financial performance.

    • Income Statement shows the company's revenues and expenses over a period of time, which affects the company's net income.

    • Balance Sheet shows the company's assets, liabilities, and equity at a specific point in time, which...

  • Answered by AI
  • Q3. What is Interest coverage ratio
  • Ans. 

    Interest coverage ratio measures a company's ability to pay interest on its debt with its earnings.

    • Interest coverage ratio is calculated by dividing a company's earnings before interest and taxes (EBIT) by its interest expenses.

    • A higher interest coverage ratio indicates that a company is more capable of meeting its interest obligations.

    • A lower interest coverage ratio may signal financial distress and an increased risk ...

  • Answered by AI
  • Q4. What is GAAP & Non-GAAP EPS
  • Ans. 

    GAAP EPS is based on generally accepted accounting principles, while Non-GAAP EPS excludes certain expenses or income that are not considered part of normal operations.

    • GAAP EPS follows accounting standards set by regulatory bodies like SEC

    • Non-GAAP EPS excludes items like one-time expenses or gains to provide a clearer picture of ongoing business performance

    • Investors often consider both GAAP and Non-GAAP EPS when evalua

  • Answered by AI
  • Q5. What is amortisation
  • Ans. 

    Amortisation is the process of spreading out the cost of an intangible asset over its useful life.

    • Amortisation is similar to depreciation, but it is used for intangible assets such as patents, copyrights, and trademarks.

    • It helps in matching the expense of the intangible asset with the revenue it generates over time.

    • The amortisation expense is recorded on the income statement and reduces the value of the intangible asse...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Good communication will help and be confident
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Basic & intermediate SQL questions
  • Q2. Second highest salary of employee
  • Q3. DBMS key concepts and explation with examples of use case
  • Ans. 

    DBMS key concepts and examples of use cases

    • DBMS stands for Database Management System

    • Key concepts include data modeling, query optimization, transaction management

    • Use cases include online transaction processing (OLTP), data warehousing, customer relationship management (CRM)

    • Examples: MySQL for OLTP, Oracle for data warehousing, Salesforce for CRM

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

(1 Question)

  • Q1. Techno business related questions

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Jsjwkqnsnns.hejwkqp hsowpa bsoqla bspam

Round 2 - Assignment 

Bsppq hspals bsoak nspal bdoa a

Round 3 - Group Discussion 

Hsoaks bspapa bosoaks bospmwa bosoebs

Round 4 - One-on-one 

(2 Questions)

  • Q1. Jspwpaknsbe jsos heopw
  • Q2. Jsppq jepwl jspam
Round 5 - Case Study 

Hdosm jspwl jspwla bqiq heowwo hsowoa

Round 6 - One-on-one 

(2 Questions)

  • Q1. Hslwla jwpwpq belwp
  • Q2. Bspwlw noslw nspq a
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. SQL Window functions
  • Q2. Excel computed fields in pivot tables
  • Ans. 

    Excel pivot tables allow users to create computed fields using formulas.

    • In Excel pivot tables, computed fields are created by adding a new field with a formula.

    • Formulas can be simple arithmetic operations or more complex calculations.

    • Computed fields can be used to perform calculations on existing data in the pivot table.

    • Examples: calculating profit margin by dividing revenue by cost, calculating average sales per month

  • Answered by AI
  • Q3. Difference in precision and recall
  • Ans. 

    Precision is the ratio of correctly predicted positive observations to the total predicted positives, while recall is the ratio of correctly predicted positive observations to the all observations in actual class.

    • Precision focuses on the accuracy of positive predictions, while recall focuses on the proportion of actual positives that were correctly identified.

    • Precision = TP / (TP + FP)

    • Recall = TP / (TP + FN)

    • Example: In...

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

(2 Questions)

  • Q1. About past experience
  • Q2. Past project details

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Technical.purely
Round 2 - One-on-one 

(1 Question)

  • Q1. Purely tech..and then you present a dashboard on power bi
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Top 7 th employee salary
Find Duplicates

Round 2 - Technical 

(3 Questions)

  • Q1. Trigger Stored procedure
  • Ans. 

    A trigger is a special type of stored procedure that is automatically executed when certain events occur in a database.

    • Triggers are used to enforce business rules, maintain data integrity, and automate tasks.

    • They can be set to execute before or after INSERT, UPDATE, or DELETE operations on a table.

    • For example, a trigger can be created to update a log table whenever a new record is inserted into a main table.

  • Answered by AI
  • Q2. Gateway Different modes in power bi
  • Ans. 

    Power BI has different modes like View, Edit, and Data Source.

    • View mode allows users to interact with reports and dashboards

    • Edit mode enables users to modify existing reports and create new ones

    • Data Source mode allows users to connect to and manipulate data sources

  • Answered by AI
  • Q3. Nothing to get importance no words

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Join and window functions
  • Q2. Python questions and puzzles
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. NANANANANANANANA
  • Q2. NANANANANANANANANA
Round 2 - One-on-one 

(2 Questions)

  • Q1. NANANANAANANANA
  • Q2. NANANANANANANANANANA

Lloyds Technology Centre Interview FAQs

How many rounds are there in Lloyds Technology Centre Senior Data Analyst interview?
Lloyds Technology Centre interview process usually has 1 rounds. The most common rounds in the Lloyds Technology Centre interview process are Technical and Coding Test.

Tell us how to improve this page.

Lloyds Technology Centre Senior Data Analyst Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more
Join Lloyds Technology Centre We're changing financial services and we want you to join us
Lloyds Technology Centre Senior Data Analyst Salary
based on 20 salaries
₹14.3 L/yr - ₹26.7 L/yr
59% more than the average Senior Data Analyst Salary in India
View more details
Software Engineer
68 salaries
unlock blur

₹9 L/yr - ₹24.8 L/yr

Senior Software Engineer
61 salaries
unlock blur

₹14.3 L/yr - ₹45.7 L/yr

Quality Engineer
21 salaries
unlock blur

₹8 L/yr - ₹13 L/yr

Senior Data Analyst
20 salaries
unlock blur

₹14.3 L/yr - ₹26.8 L/yr

Senior Quality Engineer
14 salaries
unlock blur

₹15 L/yr - ₹32.5 L/yr

Explore more salaries
Compare Lloyds Technology Centre with

HSBC Group

4.0
Compare

Standard Chartered Plc

3.0
Compare

Barclays PLC

3.9
Compare

JPMorgan Chase & Co.

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