Upload Button Icon Add office photos

Tredence

Compare button icon Compare button icon Compare

Filter interviews by

Tredence Analyst Interview Questions and Answers

Updated 22 Jan 2025

7 Interview questions

An Analyst was asked
Q. Rate your proficiency in SQL and Python.
Ans. 

I rate myself highly in SQL and Python.

  • I have extensive experience in writing complex SQL queries and optimizing database performance.

  • I am proficient in Python and have used it for data analysis, automation, and web scraping.

  • I have worked on various projects where I utilized both SQL and Python together to extract, transform, and load data.

  • I am familiar with popular SQL databases like MySQL, PostgreSQL, and Oracle...

An Analyst was asked 12mo ago
Q. Applications of data science in other industries. 1 guestimate and puzzel
Ans. 

Data science is used in various industries like finance, marketing, healthcare, and transportation to analyze trends, make predictions, and optimize processes.

  • Finance: Predictive analytics for stock market trends and risk assessment.

  • Marketing: Customer segmentation and targeted advertising campaigns.

  • Healthcare: Predictive modeling for disease diagnosis and treatment.

  • Transportation: Route optimization and demand fo...

Analyst Interview Questions Asked at Other Companies

asked in Capgemini
Q1. N-th Fibonacci Number Problem Statement Given an integer ‘N’, you ... read more
asked in Deloitte
Q2. Reverse a Number Problem Statement Given an integer 'N', write a ... read more
Q3. A 10x10x10 cube is made up of 1x1x1 cubes. Its outer surface is p ... read more
Q4. Ninja and the Game of Words In this game, Ninja is provided with ... read more
asked in Capgemini
Q5. What will be the output of the following pseudocode? #include Int ... read more
An Analyst was asked
Q. How you reduce error in model Which kind of matrix used in your model How you map data
Ans. 

To reduce error in a model, I use techniques like cross-validation, regularization, and feature selection. I use matrices like confusion matrix and correlation matrix. Data is mapped using techniques like normalization and encoding.

  • Reduce error in model by using techniques like cross-validation, regularization, and feature selection

  • Use matrices like confusion matrix to evaluate classification models and correlatio...

An Analyst was asked 11mo ago
Q. Custom reports in Salesforce
Ans. 

Custom reports in Salesforce allow users to create personalized reports based on specific criteria.

  • Custom reports can be created by selecting the desired fields, filters, and grouping criteria.

  • Users can also add charts, graphs, and tables to visualize the data in the report.

  • Custom reports can be scheduled to run at specific times and be shared with other users.

  • Examples of custom reports include sales performance b...

An Analyst was asked 11mo ago
Q. Brief overview of implementations in Salesforce
Ans. 

Salesforce is a CRM platform used for various implementations like sales, marketing, customer service, etc.

  • Sales Cloud for sales automation

  • Service Cloud for customer service management

  • Marketing Cloud for marketing automation

  • Community Cloud for building online communities

  • Einstein Analytics for data analysis

An Analyst was asked
Q. How do you change the data type and push the data into a database?
Ans. 

To change data type and push data into a database, use data conversion functions and SQL queries.

  • Use data conversion functions like CAST or CONVERT to change data type before pushing into the database.

  • Write SQL INSERT or UPDATE queries to push the data into the database.

  • Ensure the data being pushed matches the data type of the database column to avoid errors.

An Analyst was asked
Q. What is your guesstimate on how many people use mobile phones in India?
Ans. 

It is estimated that over 800 million people use mobile phones in India.

  • India has a population of over 1.3 billion people.

  • The mobile phone penetration rate in India is around 80%.

  • Majority of the population use mobile phones for communication, internet access, and entertainment.

  • The number of mobile phone users in India is constantly increasing due to affordable smartphones and data plans.

Are these interview questions helpful?

Tredence Analyst Interview Experiences

23 interviews found

Analyst Interview Questions & Answers

user image Anonymous

posted on 15 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

3 hours, Basic aptitude questions, 3 coding questions, MCQ programming questions

Round 2 - Technical 

(1 Question)

  • Q1. Applications of data science in other industries. 1 guestimate and puzzel
  • Ans. 

    Data science is used in various industries like finance, marketing, healthcare, and transportation to analyze trends, make predictions, and optimize processes.

    • Finance: Predictive analytics for stock market trends and risk assessment.

    • Marketing: Customer segmentation and targeted advertising campaigns.

    • Healthcare: Predictive modeling for disease diagnosis and treatment.

    • Transportation: Route optimization and demand forecas...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Where do you see yourself in 5 years.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for puzzels and guestimates
Prepare any one language perfectly (sql, python) cover basic concepts that should be suffiecient

Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Mar 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Write a VLOOKUP Formula.
Simple Join Questions in SQL

Round 2 - Case Study 

Guesstimate - How many white maruti swift car is available in Delhi?

Round 3 - One-on-one 

(2 Questions)

  • Q1. Describe any over Forecasting Methodology
  • Ans. 

    Over Forecasting Methodology involves predicting higher values than the actual outcome.

    • Over forecasting can lead to excess inventory and increased costs.

    • It can also result in missed sales opportunities due to inaccurate predictions.

    • Common causes of over forecasting include relying on outdated data or not considering external factors.

    • For example, a company may over forecast demand for a product leading to excess stock t...

  • Answered by AI
  • Q2. A/B Testing Case Discussion

Interview Preparation Tips

Topics to prepare for Tredence Analyst interview:
  • Advanced Excel
  • SQL

Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Feb 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Around 60 questions were asked including aptitude and basic coding in 2:30 hrs.

Round 2 - Technical 

(3 Questions)

  • Q1. Basic questions on python, sql and project related discussion.
  • Q2. Rate yourself in sql and python
  • Ans. 

    I rate myself highly in SQL and Python.

    • I have extensive experience in writing complex SQL queries and optimizing database performance.

    • I am proficient in Python and have used it for data analysis, automation, and web scraping.

    • I have worked on various projects where I utilized both SQL and Python together to extract, transform, and load data.

    • I am familiar with popular SQL databases like MySQL, PostgreSQL, and Oracle, as ...

  • Answered by AI
  • Q3. Tell me about your projects

Skills evaluated in this interview

Analyst Interview Questions & Answers

user image Pratish

posted on 4 Oct 2024

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

Basic aptitude, verbal, and coding tests with one program to run and execute. The remaining questions are multiple-choice questions and one guestimate question.

Analyst Interview Questions & Answers

user image Anonymous

posted on 11 Aug 2023

Interview experience
4
Good
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 

Aptitude test consist of 4 segment
1. Quantitative aptitude
2.verbal ability
3. Data interpretation
4. Short written ( who is better gifted or hard worker..??) this question ask to me AND second question is on guesstimating (how much car sold in India in 2018 ) solved based on assumption and calculations.
5. It was consign round which has 3 questions 1 easy 1 moderate 1 tough of 20,20,50 marks respectively

Round 3 - English fluency 

(1 Question)

  • Q1. This round has 3 section 1. Read sentence and speak loudly and record it You can record only once 2. Second listen audio clip and speak loudly and record it you can listen audio clip once only 3 listen a...
Round 4 - Technical 

(2 Questions)

  • Q1. It is totally technical interview totally based on resume it means whatever you have written in your resume you have to know everything in deep my interview was last for 35 min totally on machine learning....
  • Q2. How you reduce error in model Which kind of matrix used in your model How you map data
  • Ans. 

    To reduce error in a model, I use techniques like cross-validation, regularization, and feature selection. I use matrices like confusion matrix and correlation matrix. Data is mapped using techniques like normalization and encoding.

    • Reduce error in model by using techniques like cross-validation, regularization, and feature selection

    • Use matrices like confusion matrix to evaluate classification models and correlation mat...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Whatever you write or tell about yourself in interview like any project or any internship so you must have deep knowledge on it

Skills evaluated in this interview

Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Jul 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. Deal closing process
  • Q2. Custom reports in Salesforce
  • Ans. 

    Custom reports in Salesforce allow users to create personalized reports based on specific criteria.

    • Custom reports can be created by selecting the desired fields, filters, and grouping criteria.

    • Users can also add charts, graphs, and tables to visualize the data in the report.

    • Custom reports can be scheduled to run at specific times and be shared with other users.

    • Examples of custom reports include sales performance by reg...

  • Answered by AI
  • Q3. PMO work experience
  • Ans. 

    Experienced PMO professional with a focus on project governance, resource management, and process improvement.

    • Managed a portfolio of projects, ensuring alignment with organizational goals and strategic objectives.

    • Implemented project management methodologies, such as Agile and Waterfall, to enhance project delivery efficiency.

    • Facilitated communication between project teams and stakeholders, ensuring transparency and tim...

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Brief overview of implementations in Salesforce
  • Ans. 

    Salesforce is a CRM platform used for various implementations like sales, marketing, customer service, etc.

    • Sales Cloud for sales automation

    • Service Cloud for customer service management

    • Marketing Cloud for marketing automation

    • Community Cloud for building online communities

    • Einstein Analytics for data analysis

  • Answered by AI
  • Q2. Explaining company's expectations
  • Ans. 

    Company's expectations should be clearly communicated to employees to ensure alignment and success.

    • Clearly outline job responsibilities and performance metrics

    • Provide regular feedback and opportunities for growth

    • Encourage open communication and collaboration within teams

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Know more about the company and what they do apart from Salesforce, need to know how their business works, should know role of PMO

Skills evaluated in this interview

Analyst Interview Questions & Answers

user image Anonymous

posted on 27 Mar 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What are different optimisation techniques you have used so far in databricks
  • Ans. 

    I have used techniques like hyperparameter tuning, feature engineering, and model selection in Databricks for optimization.

    • Hyperparameter tuning using GridSearchCV or RandomizedSearchCV

    • Feature engineering to create new features or transform existing ones

    • Model selection using techniques like cross-validation or ensemble methods

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. What is your salary expectations
  • Q2. What drives you to switch from previous company

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good in technical stuff you mention in your resume

Analyst Interview Questions & Answers

user image Anonymous

posted on 25 Apr 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic focus on aptitude questions

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic guessestimates

Analyst Interview Questions & Answers

user image Anonymous

posted on 7 Sep 2023

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

Easy to crack, just focus on basics

Round 2 - One-on-one 

(1 Question)

  • Q1. Easy questions from SQL , computer fundamentals

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice coding

Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Jan 2025

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

I appeared for an interview before Jan 2024.

Round 1 - Aptitude Test 

The test has Python, SQL and aptitude

Round 2 - Technical 

(1 Question)

  • Q1. Question about my internship mentioned in my resume

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Tredence?
Ask anonymously on communities.

Tredence Interview FAQs

How many rounds are there in Tredence Analyst interview?
Tredence interview process usually has 2-3 rounds. The most common rounds in the Tredence interview process are Technical, Aptitude Test and HR.
How to prepare for Tredence 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 Tredence. The most common topics and skills that interviewers at Tredence expect are Data Management, Data Mining, Machine Learning, Data Visualization and GCP.
What are the top questions asked in Tredence Analyst interview?

Some of the top questions asked at the Tredence Analyst interview -

  1. Puzzle: Given two hour glass, one measuring 4 mins and the other 7 mins, how to...read more
  2. 1.) Case Study: How Many people will drink tea on a certain d...read more
  3. How you reduce error in model Which kind of matrix used in your model How you ...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4.2/5

based on 13 interview experiences

Difficulty level

Easy 17%
Moderate 83%

Duration

Less than 2 weeks 80%
2-4 weeks 20%
View more
Tredence Analyst Salary
based on 292 salaries
₹6 L/yr - ₹10.4 L/yr
14% more than the average Analyst Salary in India
View more details

Tredence Analyst Reviews and Ratings

based on 45 reviews

3.5/5

Rating in categories

3.8

Skill development

2.7

Work-life balance

2.9

Salary

3.5

Job security

3.2

Company culture

2.9

Promotions

3.1

Work satisfaction

Explore 45 Reviews and Ratings
Associate Manager
445 salaries
unlock blur

₹18 L/yr - ₹31.2 L/yr

Consultant
426 salaries
unlock blur

₹11.5 L/yr - ₹20 L/yr

Data Engineer
303 salaries
unlock blur

₹6.5 L/yr - ₹18.6 L/yr

Analyst
292 salaries
unlock blur

₹6 L/yr - ₹10.4 L/yr

Senior Business Analyst
250 salaries
unlock blur

₹6.5 L/yr - ₹17 L/yr

Explore more salaries
Compare Tredence with

ITC Infotech

3.7
Compare

CitiusTech

3.3
Compare

HTC Global Services

3.5
Compare

Xoriant

4.1
Compare
write
Share an Interview