Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Employer? Claim Account for FREE

Infogain Technologies

Compare

3.7

based on 15 Reviews

Filter interviews by

Infogain Technologies Interview Questions and Answers

Updated 25 Sep 2024

Infogain Technologies Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

Archna Sharma

posted on 25 Sep 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

No response

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

Round 1 - Technical

(3 Questions)

Q1. How to get 5th highest salary of an employee

Ans.

Use SQL query with ORDER BY and LIMIT to get the 5th highest salary of an employee.

Use ORDER BY clause to sort the salaries in descending order
Use LIMIT 1 OFFSET 4 to get the 5th highest salary

Answered by AI

Add your answer

Q2. How to insert data only if table exists

Ans.

Use conditional logic to check if table exists before inserting data.

Check if table exists using system tables like information_schema.tables
Use dynamic SQL to conditionally insert data if table exists
Handle errors gracefully if table does not exist

Answered by AI

Add your answer

Q3. Query to show total experience from the date of DOJ 4 years, 2 months,3days

Ans.

Use DATEDIFF function to calculate total experience from DOJ

Use DATEDIFF function to calculate the difference between current date and DOJ
Convert the result into years, months, and days format
Consider leap years and varying month lengths in the calculation

Answered by AI

Add your answer

Skills evaluated in this interview

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)

View answer (4)

Top trending discussions

View All

Interview Tips & Stories

5d (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours. Seriously, they didn't even acknowledge me until 10. Then this HR lady calls me in, and she's totally unprofessional. She's like, on her phone, making personal calls while I'm sitting right there. And then she starts asking me these really weird questions, like what my nickname is, and what my dad does for a living. It got really uncomfortable when she started pressing for details about where my dad works. I mean, what does that have to do with anything? So I politely told her I didn't want to answer, and she actually said, "Then we can't continue this interview." I was honestly shocked. But instead of arguing, I just stood up and said, “Alright then.” And walked out. I left feeling pissed. Not only did they waste an hour of my time, but the HR rep was also rude and unprofessional..

Got a question about Infogain Technologies?

Ask anonymously on communities.

Interview questions from similar companies

Senior Software Engineer Interview Questions & Answers

Tech Mahindra

Anonymous

posted on 14 May 2022

I applied via Naukri.com and was interviewed before May 2021. There was 1 interview round.

Round 1 - One-on-one

(1 Question)

Q1. Discuss 4 case study related to supply chain management.

Add your answer

Interview Preparation Tips

Topics to prepare for Tech Mahindra Senior Software Engineer interview:

Supply Chain Management

Interview preparation tips for other job seekers - Develop some case study of your own and also deep analysis for each.

Senior Associate Interview Questions & Answers

Wipro

Anonymous

posted on 29 Apr 2021

I applied via Walk-in and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire

1 Question

Q1. What is Excel what is vlookup what is your strength and weakness

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest and bold

Software Engineer Interview Questions & Answers

Wipro

Anonymous

posted on 16 Sep 2021

I was interviewed before Sep 2020.

Round 1 - Coding Test

(1 Question)

Round duration - 140 minutes
Round difficulty - Medium

Test timing was at 2:00 pm , it was conducted in a college and the environment was good for the test. Camera was a primary part of test, so no suspicious activity.

Q1.

Sum of Two Numbers Represented as Arrays

Given two numbers in the form of two arrays where each element of the array represents a digit, calculate the sum of these two numbers and return this sum as an ar...

Ans.

Given two numbers represented as arrays, calculate their sum and return the result as an array.

Iterate through the arrays from right to left, adding digits and carrying over if necessary
Handle cases where one array is longer than the other by considering the remaining digits
Ensure the final sum array does not have any leading zeros

Answered by AI

Add your answer

Round 2 - Face to Face

Round duration - 20 minutes
Round difficulty - Easy

The round was conducted at around 12 p.m. I was called at the college location and then it was conducted. The interviewer was quite polite and frank.

Round 3 - HR

Round duration - 8 minutes
Round difficulty - Easy

This round was conducted right after finishing and clearing the technical round at the same place and on the same day.

Interview Preparation Tips

Eligibility criteriaAbove 60 %Wipro Limited interview preparation:Topics to prepare for the interview - OOPS, Data Structures, Database Concepts, Coding problemsTime required to prepare for the interview - 2-3 monthsInterview preparation tips for other job seekers

Tip 1 : Practice atleast 2-3 Coding problems daily so your logic building becomes stronger.
Tip 2 : Exercise problems based on OOPS concepts and others too.
Tip 3 : If you can have your own project built, then it's the major point and will act as a plus point.

Application resume tips for other job seekers

Tip 1 : Your resume should be in standard form, short and simple will be more effective.
Tip 2 : Whatever you have learned, you need to mention it in your resume as that will be your primary source of selection and having project on your resume is important.

Final outcome of the interviewSelected