Upload Button Icon Add office photos

Filter interviews by

eTrans Solutions Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. How to optimise php and mysql query
  • Ans. 

    Optimizing PHP and MySQL queries involves using indexes, optimizing queries, and reducing data transfer.

    • Use indexes to speed up data retrieval

    • Optimize queries by avoiding unnecessary joins and subqueries

    • Reduce data transfer by selecting only necessary columns

    • Use caching to avoid repetitive queries

    • Avoid using SELECT *

    • Use EXPLAIN to analyze query performance

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Self introduction

Interview Preparation Tips

Interview preparation tips for other job seekers - Arrange the interview immediately

Interview Questionnaire 

1 Question

  • Q1. About customer service???
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Jan 2024.

Round 1 - HR 

(2 Questions)

  • Q1. Only salf introduced
  • Q2. Have you reduced it before or not
  • Ans. 

    Yes, I have reduced it before in previous projects by implementing cost-saving measures.

    • Implemented cost-saving measures to reduce expenses

    • Streamlined processes to increase efficiency

    • Negotiated better deals with vendors to lower costs

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

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

Round 1 - Technical 

(1 Question)

  • Q1. Vlookup, index match,
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What are the different type of projects I have worked upon?
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 - One-on-one 

(2 Questions)

  • Q1. Something about yourself
  • Q2. Projects and improvements
Round 2 - One-on-one 

(1 Question)

  • Q1. People related questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Mar 2023.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on Django middleware, models and queries
Round 2 - Technical 

(1 Question)

  • Q1. Design an algorithm to efficiently to send office bus to all location in the city
  • Ans. 

    Use a greedy algorithm to send the office bus to all locations in the city efficiently.

    • Start from the office location and pick the nearest location to visit next.

    • Continue picking the nearest unvisited location until all locations are covered.

    • Repeat the process until all locations are visited.

    • Consider using Dijkstra's algorithm or a similar approach for finding the nearest location.

    • Optimize the route by considering traf

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

(1 Question)

  • Q1. Round with CTO, mostly behavioural and expected pay

Skills evaluated in this interview

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

I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Resume Based, Job description and work
  • Q2. Project details and question on project
Round 2 - Technical 

(2 Questions)

  • Q1. Simple Guesstimate problems
  • Q2. Simple case study about market entry
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Nov 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

The basic questions asked in an interview .

Round 2 - Coding Test 

DP, graph, and array questions asked in 2nd round also asked my company project

Interview Preparation Tips

Interview preparation tips for other job seekers - please prepare for the DSA and system design round and basic computer concept

eTrans Solutions Interview FAQs

How to prepare for eTrans Solutions 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 eTrans Solutions. The most common topics and skills that interviewers at eTrans Solutions expect are Postgresql, MongoDB, JSON, Java and Design.

Tell us how to improve this page.

eTrans Solutions Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Delhivery Interview Questions
3.8
 • 464 Interviews
ElasticRun Interview Questions
3.5
 • 250 Interviews
BlackBuck Interview Questions
3.8
 • 178 Interviews
GATI-KWE Interview Questions
3.9
 • 88 Interviews
FarEye Interview Questions
3.1
 • 27 Interviews
LOCUS Interview Questions
2.9
 • 5 Interviews
Vamaship Interview Questions
3.1
 • 1 Interview
View all

eTrans Solutions Reviews and Ratings

based on 30 reviews

4.5/5

Rating in categories

4.1

Skill development

4.2

Work-life balance

3.8

Salary

4.3

Job security

4.4

Company culture

3.7

Promotions

4.1

Work satisfaction

Explore 30 Reviews and Ratings
Full Stack Java Developer

Kolkata

1-2 Yrs

Not Disclosed

Sales Executive

Kolkata,

Mumbai

2-3 Yrs

Not Disclosed

Project Coordinator and Customer Support Liaison

Kolkata,

Mumbai

+5

2-4 Yrs

Not Disclosed

Explore more jobs
System Analyst
7 salaries
unlock blur

₹1.6 L/yr - ₹4 L/yr

System Executive
5 salaries
unlock blur

₹1.2 L/yr - ₹4.5 L/yr

Hardware Design Engineer
5 salaries
unlock blur

₹2.2 L/yr - ₹3 L/yr

Business Development Head
5 salaries
unlock blur

₹8 L/yr - ₹11 L/yr

Lab Assistant
5 salaries
unlock blur

₹2.1 L/yr - ₹2.2 L/yr

Explore more salaries
Compare eTrans Solutions with

BlackBuck

3.8
Compare

Delhivery

3.8
Compare

Shadowfax Technologies

3.6
Compare

LogiNext Solutions

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