Upload Button Icon Add office photos
Engaged Employer

i

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

insightsoftware Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 89 Reviews

Filter interviews by

insightsoftware Technical Consultant Interview Questions and Answers

Updated 20 Mar 2024

insightsoftware Technical Consultant Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Details about Inner joins and outer joins.
  • Q2. PL/SQL queries using where clause.
  • Ans. 

    PL/SQL queries using where clause allow filtering of data based on specified conditions.

    • Use WHERE clause to specify conditions for filtering data

    • Conditions can include comparisons, logical operators, and functions

    • Example: SELECT * FROM table_name WHERE column_name = 'value'

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Are flexible to work in EST shift ?
  • Q2. Checking communication skill.

Skills evaluated in this interview

Technical Consultant Jobs at insightsoftware

View all

Interview questions from similar companies

I applied via Referral and was interviewed in Jan 2022. There were 2 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. SQL, Unix , Oracle
  • Q2. SQL, Oracle, unix
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jun 2024. There were 4 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Coding with design fundamentals on BST and DP
Round 2 - Technical 

(2 Questions)

  • Q1. Coding test with BST, DP
  • Q2. LLD, HLD on telecom. SOLID principles, Design patterns, System design
Round 3 - One-on-one 

(1 Question)

  • Q1. One on one round with Architect and Manager. What do we know about SIP, SS7, Diameter.
Round 4 - HR 

(1 Question)

  • Q1. Usual HR questions

Interview Preparation Tips

Topics to prepare for Mobileum Technical Lead interview:
  • Dynamic programing
  • Binary Search Tree
  • Kafka
  • Rabbitmq
  • Java
  • C++
  • JUnit
Interview preparation tips for other job seekers - Prepare yourselves to get the call back after the scheduled interviews after a month or so if you are selected.

If you get the offer letter, please do not join this company.

Not very considerate people, though the policies are there. No WLB, politics, poor product and project management. Architects know the stuff but they don't have the documents about the products, no KT.

Again please seriously take this advice, if you get one offer, please do not join the company.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Online Exam - 10 MCQ and 2 coding questions

Round 2 - Technical 

(1 Question)

  • Q1. Project Discussion
Interview experience
5
Excellent
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 - Technical 

(1 Question)

  • Q1. Explain Oops Concept
  • Ans. 

    Oops Concept is a programming paradigm that focuses on objects and their interactions to solve complex problems.

    • Oops Concept stands for Object-Oriented Programming

    • It is based on the principles of encapsulation, inheritance, and polymorphism

    • Encapsulation allows bundling of data and methods into a single unit called an object

    • Inheritance enables the creation of new classes by inheriting properties and behaviors from exist...

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Explain ACID property in SQL
  • Ans. 

    ACID property ensures that database transactions are processed reliably.

    • ACID stands for Atomicity, Consistency, Isolation, and Durability.

    • Atomicity ensures that a transaction is treated as a single unit of work, either all or none of its operations are executed.

    • Consistency ensures that a transaction brings the database from one valid state to another.

    • Isolation ensures that concurrent transactions do not interfere with ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself?
  • Q2. How much experience do you have ?

I applied via Referral and was interviewed in Jan 2022. There were 2 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. SQL, Unix , Oracle
  • Q2. SQL, Oracle, unix
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain Telco Security alongwith Protocols
  • Ans. 

    Telco security involves protecting telecommunications networks and data from cyber threats. It includes protocols like SSL, IPSec, and VPN.

    • Telco security focuses on securing telecommunications networks and data from cyber attacks

    • Protocols like SSL (Secure Sockets Layer), IPSec (Internet Protocol Security), and VPN (Virtual Private Network) are commonly used in telco security

    • Encryption and authentication are key compone...

  • Answered by AI

Skills evaluated in this interview

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

Normal coding test on DSA and LLD.

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

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

Round 1 - Technical 

(1 Question)

  • Q1. Java palindrome questiin
Round 2 - Technical 

(1 Question)

  • Q1. Brush up on algo and data engineer

insightsoftware Interview FAQs

How many rounds are there in insightsoftware Technical Consultant interview?
insightsoftware interview process usually has 2 rounds. The most common rounds in the insightsoftware interview process are Technical and HR.
How to prepare for insightsoftware Technical Consultant 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 insightsoftware. The most common topics and skills that interviewers at insightsoftware expect are Agile Coaching, Data Mapping, Downstream Processing, SAP Data Migration and SDLC.
What are the top questions asked in insightsoftware Technical Consultant interview?

Some of the top questions asked at the insightsoftware Technical Consultant interview -

  1. PL/SQL queries using where clau...read more
  2. Details about Inner joins and outer joi...read more
  3. Checking communication ski...read more

Tell us how to improve this page.

insightsoftware Technical Consultant Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

IBM Interview Questions
4.0
 • 2.4k Interviews
Oracle Interview Questions
3.7
 • 897 Interviews
SAP Interview Questions
4.2
 • 308 Interviews
Salesforce Interview Questions
4.1
 • 271 Interviews
Adobe Interview Questions
4.0
 • 249 Interviews
Intuit Interview Questions
3.6
 • 88 Interviews
Mobileum Interview Questions
3.3
 • 36 Interviews
Entrata Interview Questions
4.4
 • 34 Interviews
View all
insightsoftware Technical Consultant Salary
based on 23 salaries
₹4.4 L/yr - ₹15.5 L/yr
8% less than the average Technical Consultant Salary in India
View more details

insightsoftware Technical Consultant Reviews and Ratings

based on 2 reviews

2.7/5

Rating in categories

2.7

Skill development

3.2

Work-life balance

2.1

Salary

1.0

Job security

3.2

Company culture

1.0

Promotions

3.2

Work satisfaction

Explore 2 Reviews and Ratings
Technical Consultant

Hyderabad / Secunderabad

7-11 Yrs

Not Disclosed

Senior Consultant Technical (*Informatica,Azure Data Factory)

Hyderabad / Secunderabad

5-13 Yrs

Not Disclosed

Explore more jobs
Software Engineer
57 salaries
unlock blur

₹9 L/yr - ₹24 L/yr

Senior Software Engineer
45 salaries
unlock blur

₹13.5 L/yr - ₹43 L/yr

Senior Technical Support Engineer
25 salaries
unlock blur

₹12 L/yr - ₹20 L/yr

Technical Consultant
23 salaries
unlock blur

₹4.4 L/yr - ₹15.5 L/yr

Associate Software Engineer
17 salaries
unlock blur

₹4.2 L/yr - ₹11.4 L/yr

Explore more salaries
Compare insightsoftware with

SAP

4.2
Compare

Oracle

3.7
Compare

Microsoft Corporation

4.0
Compare

Salesforce

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