Upload Button Icon Add office photos

Filter interviews by

Experian Data Management Analyst Interview Questions and Answers

Updated 2 Nov 2024

Experian Data Management Analyst Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Coding Test 

SQL Joins and Window functions in SQL
Asked about Stored Procedures and implementations
Tableau LOD's
Tableau Parameters

Interview Preparation Tips

Topics to prepare for Experian Data Management Analyst interview:
  • SQL
  • Database
  • Tableau
  • Excel
Interview preparation tips for other job seekers - Freshen up on the most anticipated questions in SQL and Tableau. Do not skip on the key topics and expect a question or two about coding

Interview questions from similar companies

I appeared for an interview in Dec 2016.

Interview Questionnaire 

5 Questions

  • Q1. Any thing which your friends hate about you?
  • Ans. 

    I tend to be too organized and structured, which can annoy my friends at times.

    • My friends sometimes find my need for planning and structure to be excessive

    • I can be inflexible when it comes to deviating from my plans

    • My attention to detail can come across as nitpicky to some

    • I prioritize efficiency over spontaneity, which can be frustrating for my more laid-back friends

  • Answered by AI
  • Q2. Revenue collected by the barbers of Kanpur in an year
  • Ans. 

    I don't have the available data to answer this question.

    • Need data on number of barbers in Kanpur

    • Need data on average revenue per barber

    • Need data on number of working days in a year

    • Need data on number of customers per barber per day

  • Answered by AI
  • Q3. If you are going to open an e-commerce website like Flipkart what will be the things that you will have to keep in mind.
  • Ans. 

    To open an e-commerce website like Flipkart, one must keep in mind various factors such as target audience, product range, user experience, logistics, and marketing.

    • Identify the target audience and their preferences

    • Offer a wide range of products to cater to different needs

    • Ensure a seamless user experience with easy navigation and quick loading time

    • Establish a robust logistics network for timely delivery and hassle-free...

  • Answered by AI
  • Q4. If given the other job profile will you accept it?
  • Ans. 

    It depends on the job profile and its alignment with my career goals.

    • I would consider the job profile and evaluate its alignment with my career goals.

    • I would assess the job responsibilities and the skills required for the role.

    • I would also consider the company culture and work environment.

    • If the job profile aligns with my career goals and offers growth opportunities, I would accept it.

    • However, if it does not align with...

  • Answered by AI
  • Q5. Any one decision you will like to change in course of these 4 years which could open a better career profile for you.
  • Ans. 

    I would have pursued a certification in data science earlier.

    • I should have taken a course in data science during my undergraduate studies.

    • I could have pursued a certification in data science while working as a business analyst.

    • Learning data science earlier would have opened up more opportunities for me in the field.

    • I could have gained more experience in data analysis and visualization.

    • I could have applied for more adva

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The question were tricky not conventional quant. Spend time on questions don't rush
Tips: CAT level preparation will be more than enough
Duration: 1 hour
Total Questions: 60

Round: HR Interview
Experience: Basic HR questions. Be confident and good communication skills will help

Round: Technical + HR Interview
Experience: There were 2 panelist one man and a woman. When they asked the revenue question, I asked the ma'am as to how many times do she go to a parlor and then how much does it cost each time. This lightened the mood and she was smiling throughout the interview. After listening to questions I was saying "Please give me 2 minutes to think over it" She finally said "Why do you want 2 minutes every time we ask a question" then i answered "I just want to come up with the best answer in 2 minutes and don't say anything irrelevant". They were very impressed said "Take as much time as you want "
Tips: Just be yourself. Confident with a smile. Workout the problem with them

Skills: Guesstimate Skills, HR Skills, Communication And Confidence, Ability To Handle Situations, Commitment
College Name: IIT Kanpur

Interview Questionnaire 

5 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.

    • Experienced in using statistical analysis tools such as Python, R, and SQL

    • Proficient in data visualization tools like Tableau and Power BI

    • Skilled in data cleaning, data mining, and data modeling techniques

    • Strong problem-solving and critical thinking skills

    • Effective communicator and team player

    • Example: I have w...

  • Answered by AI
  • Q2. Biggest hurdle you faced during the work you did t organise the tech fest of your college
  • Ans. 

    The biggest hurdle I faced during organizing the tech fest of my college was securing sponsorships.

    • Difficulty in convincing companies to sponsor the event

    • Limited budget for organizing a large-scale tech fest

    • Competition with other college events for sponsorships

    • Negotiating sponsorship deals and ensuring deliverables

    • Finding sponsors aligned with the theme and objectives of the tech fest

  • Answered by AI
  • Q3. Would you go for an MBA?
  • Ans. 

    Yes, pursuing an MBA can enhance my skills and open up new career opportunities.

    • An MBA can provide a strong foundation in business and management principles.

    • It can help develop analytical and problem-solving skills.

    • An MBA can broaden my network and provide access to valuable connections.

    • It can open up leadership roles and higher-level positions in organizations.

    • Having an MBA can increase earning potential and job prosp...

  • Answered by AI
  • Q4. Reliance fresh wants to open a store in north-eastern part of India. Should it or should it not?
  • Ans. 

    Yes, Reliance Fresh should open a store in the north-eastern part of India.

    • The north-eastern part of India has a growing population and increasing consumer demand.

    • Reliance Fresh can tap into the untapped market potential in the region.

    • Opening a store in the north-eastern part of India can help Reliance Fresh expand its presence and increase its market share.

    • Reliance Fresh can leverage its existing supply chain and dist...

  • Answered by AI
  • Q5. Guesstimate the number of people travelling by local metro in mumbai
  • Ans. 

    The number of people travelling by local metro in Mumbai is estimated to be in millions.

    • Mumbai has a population of over 20 million people.

    • The local metro is a popular mode of transportation in Mumbai.

    • During peak hours, the metro trains are usually crowded.

    • The metro network in Mumbai is extensive, covering various parts of the city.

    • The number of daily commuters on the metro can be estimated based on population density a

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: cpi above 7.0

Round: Test
Experience: Basic maths, shares related questions and english
Duration: 1 hour
Total Questions: 40

Round: Technical + HR Interview
Experience: Very easy round.

Skills: Aptitude, Communication, Quantitative Aptitude, Leadership Skills, Technical Skill
College Name: IIT Kanpur

Data Analyst Interview Questions & Answers

PayPal user image AKASH KUMAR SINGH

posted on 2 Dec 2016

I applied via Campus Placement and was interviewed in Dec 2016. There were 6 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. For this round he gave me lot of problems and asked to develop optimal algorithm to solve that. Problems were mainly on trees and number sequences
  • Q2. In this round he mainly discussed my projects and asked me how these can be put to use in Paypal. He also asked some basic questions from ML
  • Q3. HR round was just for formality
  • Q4. Probability , question on calculating expected number of trials and puzzles

Interview Preparation Tips

Round: Test
Experience: The coding question was:
Given a binary string containing 0's and 1's. You can split the string such that each partition should be a exponential of 5 (1,5,25,625...). You were asked to return minimum number of partition for the given string such each partition is exponential of 5. If no such partition exists return -1.
Examples: '101101101' Ans: 3 (101, 101, 101)
'111' Ans: 3 (1,1,1)
10101 Ans: -1
Tips: For MCQ's prepare DSA, OS and Networking. For DSA you can refer to cormen
For Coding question practice on either geeksforgeeks or from any of the coding platforms like hackerrank
The shortlist was mainly dependent on coding question
Duration: 1 hour 30 minutes

Round: Puzzle Interview
Tips: Do lot of puzzles from heard on the street, -----/ , Try to search for more. It will be helpful in other interviews as well

Round: Technical Interview
Tips: Practice algorithm section from geeksforgeeks. There are lot of standard problems. The given questions were slightly modified version of standard problems

Round: Technical Interview
Tips: For this round you need to be well prepared with your projects and resume.

College Name: IIT Madras

Interview Questionnaire 

6 Questions

  • Q1. Choosing between two car varieties based on various costs
  • Ans. 

    Choosing between two car varieties based on various costs

    • Consider upfront costs such as purchase price and financing options

    • Factor in ongoing costs such as fuel efficiency and maintenance

    • Evaluate potential resale value

    • Compare insurance rates

    • Consider any additional features or benefits of each car

    • Make a decision based on overall cost-effectiveness and personal preferences

  • Answered by AI
  • Q2. Choosing between in-branch and out-branch ATM's (factoring in various parameters)
  • Ans. 

    Choosing between in-branch and out-branch ATM's based on various parameters

    • Consider the location and accessibility of the ATM

    • Analyze the cost of installation and maintenance

    • Evaluate the security measures in place

    • Assess the customer demand and usage patterns

    • Factor in the availability of other banking services at the branch

    • Out-branch ATMs may be more cost-effective but in-branch ATMs offer better customer experience

  • Answered by AI
  • Q3. Choosing a marketing strategy for Capital One (Phone Calls or Letters)
  • Ans. 

    Phone calls are more effective for Capital One's marketing strategy.

    • Phone calls allow for immediate feedback and personalized communication.

    • Letters may be ignored or lost in the mail.

    • Capital One can track phone call success rates and adjust their strategy accordingly.

    • Phone calls can also be used to cross-sell and upsell products.

    • Letters may be more appropriate for certain types of communication, such as legal notices o

  • Answered by AI
  • Q4. Narrate a time when you sought the help of your peers and tell me the outcome
  • Ans. 

    I sought help from my peers when I faced a complex data analysis problem.

    • I explained the problem to my peers and asked for their suggestions.

    • We brainstormed and discussed various approaches to solve the problem.

    • One of my peers suggested a new tool that could simplify the analysis process.

    • I tried the tool and it worked perfectly, saving me a lot of time and effort.

    • The outcome was a successful completion of the project w

  • Answered by AI
  • Q5. Tell me a time when you overcome an obstacle in a project or task and the outcome
  • Ans. 

    Overcoming an obstacle in a project

    • During a software development project, we faced a challenge with integrating a third-party API

    • I researched and found a workaround by using a different API that provided similar functionality

    • I presented the solution to the team and we implemented it successfully

    • The outcome was that we were able to deliver the project on time and within budget

  • Answered by AI
  • Q6. Tell me of a time you learned something new for a project/work
  • Ans. 

    I learned about agile methodology for a project

    • Attended a training session on agile methodology

    • Implemented agile methodology in a project

    • Learned about sprints, backlogs, and daily stand-up meetings

    • Improved project efficiency and communication with team members

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: It was basic data interpretation questions. They gave us a graph or a couple of graphs and asked questions based on them. Calculators were permitted, so it was mostly about speed and application.
Tips: Solve CAT level questions for Data Interpretation, which is a more advanced level. That should make these questions relatively easy. Just practice sums as much as possible to crack this first round.
Duration: 35 minutes
Total Questions: 30

Round: Case Study Interview
Experience: The company basically looks for how logically you think as well as how effectively you can communicate while working on a problem. The question will be a relatively straightforward case with basic math involved. There are three rounds of Case Interviews, with varying problem statements, to test your thought and working process
Tips: Ensure you write everything systematically, and keep the conversation going with your interviewer. Tell him/her what you are doing constantly. Double check your work, ask questions and be calm and confident. The process is very relaxed so take your time. If you have a doubt, don't hesitate to get it clarified. Organise your workings clearly so you may come back to it easily. Don't get flustered if you make a mistake, check your working and correct it.

Round: Behavioural Interview
Experience: This was the last round of interviews. It was very relaxed. If you've made it this far then you have a very good chance of receiving an offer letter. It's more of an HR Interview with easy flowing conversation. It is to gauge your communication ability and to get a better understanding of what you've done previousy in terms of work, projects, etc.
Tips: Be calm. It's a very relaxed interview with a flowing conversation. Be confident. Don't be afraid to take a moment to think. Ensure you answer the questions in a manner that highlights previous work that you've done, or any other accomplishments. DON'T LIE. Be genuine and calm.

General Tips: I've already said all there is to say earlier. But I'll re-iterate. The interviewers are very nice and relaxed. So just be yourself. Communicate effectively and be organised in your thoughts and workings.
Skill Tips: Don't be nervous. The process is well organised and conducted. It is swift and interesting too. Just stay calm and don't be shy.
Skills: Analytic Thinking, Logic, Communication Ability
College Name: NIT Surathkal
Motivation: I loved the job profile and it was the first company I sat for on campus. I didn't want to continue with any tech related jobs. The company too, has a fantastic atmosphere in the work place.

Business Analyst Interview Questions & Answers

CapitalOne user image Shreyas Vishwanathan

posted on 1 Nov 2015

I applied via Campus Placement

Interview Questionnaire 

3 Questions

  • Q1. A case study to find out what is more profitable: monthly or daily bus membership
  • Ans. 

    To determine profitability between monthly and daily bus membership, conduct a cost-benefit analysis.

    • Gather data on the cost of monthly and daily bus passes

    • Determine the frequency of usage for each pass type

    • Calculate the total cost of using each pass type over a given period

    • Compare the costs to the benefits of each pass type, such as convenience and flexibility

    • Consider external factors, such as the availability of park...

  • Answered by AI
  • Q2. A case study with profitability of ATMs
  • Q3. Case study on choice of means of transport

Interview Preparation Tips

Round: Test
Experience: It was an easy test with basic DI and LR questions. There were around 18 questions to be done in 20 minutes.
Calculator is allowed so speed was not be a problem.
Tips: A great presence of mind and accuracy is needed. Try some CAT style DI/LR questions.

Round: Case Study Interview
Experience: Initially, the interviewer asked me a general question of what factors should be kept in mind while renting a new place near the office as well as if it is away from the office. Then the case study data was given, and various profit and loss questions were asked with some tricky conditions.
Tips: Maintaining one's cool and calm is a must. Try to solve the questions fast, but it is always better to give a late answer than a wrong answer.

Round: Case Study Interview
Experience: Some general financial knowledge was tested, as in what are the possible sources of income of commercial banks. Then the ATM case study was given, in which I had to ascertain the places in which setting up an ATM will be profitable. I was also asked to draw graphs for the profit/loss equations, and had to interpret some data from it too.
Tips: Strong mathematical skills and basic knowledge of economics will come in handy in such interviews.

Round: Case Study Interview
Experience: This was the final case study, and was similar to the previous ones, with a bit more tricky cases. Some HR questions were asked:
Why Capital One?
Why analytics?

And similar ones.

Skills: Case Analysis, Quantitative Aptitude, Economics, Quick Maths
Duration: 3
College Name: IIT Roorkee

Business Analyst Interview Questions & Answers

Paytm user image Rockey Maheshwari

posted on 8 Sep 2015

Interview Preparation Tips

Round: Test
Experience: It was a test of moderate level.

20 ques in 20 min.

Basic focus was speed and accuracy.

Tested calculation speed.
Tips: Try to decide which ques to answer and which ones to leave.

Its very important not to get stuck in any 1 ques and waste time. MOVE ON!
Duration: 20 minutes
Total Questions: 20

Round: Technical Interview
Experience: Hi ! i dont remember the question but I do remember that they were easy.

The interviewers are there to test you not to embarrass you. or humiliate you.
They dont expect you to answer every ques so no need to get frustrated if you get a couple of them wrong.
Tips: Go easy...
If you dont know answer to a ques , dont panic,. They are willing to qive you points for your approach.

General Tips: Relax at all times
Skill Tips: Just practice. Whenever you are on facebook solve a couple of brain teasers.


Skills: Aptitude
College Name: DTU
Motivation: Good Future prospects!

I applied via Approached by company and was interviewed in Aug 2021. There were 2 interview rounds.

Round 1 - Case Study 

Quant focussed Case Study (be prepared for calculations)

Round 2 - HR 

(1 Question)

  • Q1. Why are you looking for a change?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be quick and accurate with calculations
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 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 - Case Study 

New market launch strategy

Round 3 - Coding Test 

SQL intermediate level

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

I appeared for an interview before Feb 2024.

Round 1 - Technical 

(3 Questions)

  • Q1. Project Management Life cycle and Scrum principles, agile methodologies, scrum framework
  • Q2. Roles and Responsibilities of BA
  • Ans. 

    Business Analysts analyze business processes, gather requirements, and recommend solutions to improve efficiency and productivity.

    • Analyzing business processes to identify areas for improvement

    • Gathering and documenting business requirements from stakeholders

    • Creating and maintaining project documentation such as requirements documents, use cases, and process flows

    • Collaborating with stakeholders to prioritize requirements...

  • Answered by AI
  • Q3. General banking domain knowledge - Cards, Account onbaording - CA/SA/Deposits, Loans, Payments
Round 2 - One-on-one 

(2 Questions)

  • Q1. Previous work experience and your contribution
  • Ans. 

    I have 5 years of experience as a Business Analyst, where I led various projects and implemented process improvements.

    • Led cross-functional teams to analyze business processes and identify areas for improvement

    • Implemented new software systems to streamline operations and increase efficiency

    • Developed and presented reports to senior management with actionable insights

    • Collaborated with stakeholders to gather requirements a

  • Answered by AI
  • Q2. Banking domain questions
Round 3 - HR 

(3 Questions)

  • Q1. Tell me about yourself
  • Q2. Why I-Exceed?
  • Ans. 

    I-Exceed offers innovative solutions tailored to meet the unique needs of businesses, driving efficiency and growth.

    • I-Exceed provides cutting-edge technology solutions for businesses to streamline operations and enhance productivity.

    • Their focus on customization ensures that each client receives a solution that fits their specific requirements.

    • I-Exceed's track record of successful implementations and satisfied clients s

  • Answered by AI
  • Q3. Salary Discussion

Experian Interview FAQs

How many rounds are there in Experian Data Management Analyst interview?
Experian interview process usually has 1 rounds. The most common rounds in the Experian interview process are Coding Test.
How to prepare for Experian Data Management 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 Experian. The most common topics and skills that interviewers at Experian expect are Analytical skills, Auditing, Automation, Automation Testing and Billing.

Tell us how to improve this page.

Experian Data Management Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Paytm Interview Questions
3.3
 • 759 Interviews
PayPal Interview Questions
3.9
 • 212 Interviews
Fiserv Interview Questions
3.0
 • 175 Interviews
Visa Interview Questions
3.5
 • 141 Interviews
MasterCard Interview Questions
3.9
 • 139 Interviews
Revolut Interview Questions
2.5
 • 100 Interviews
CapitalOne Interview Questions
3.6
 • 79 Interviews
BharatPe Interview Questions
3.4
 • 38 Interviews
View all
Senior Software Engineer
95 salaries
unlock blur

₹18 L/yr - ₹41 L/yr

Software Engineer
59 salaries
unlock blur

₹10 L/yr - ₹27.3 L/yr

Senior Consultant
32 salaries
unlock blur

₹22 L/yr - ₹45 L/yr

Business Analyst
28 salaries
unlock blur

₹7 L/yr - ₹26.6 L/yr

Staff Engineer
25 salaries
unlock blur

₹26.4 L/yr - ₹43 L/yr

Explore more salaries
Compare Experian with

Paytm

3.3
Compare

Fiserv

3.0
Compare

Broadridge Financial Solutions

3.9
Compare

PayPal

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