Upload Button Icon Add office photos
Engaged Employer

i

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

GEMINI SOFTWARE SOLUTIONS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

GEMINI SOFTWARE SOLUTIONS Interview Questions, Process, and Tips

Updated 10 Dec 2024

Top GEMINI SOFTWARE SOLUTIONS Interview Questions and Answers

GEMINI SOFTWARE SOLUTIONS Interview Experiences

Popular Designations

3 interviews found

Senior SQL Developer Interview Questions & Answers

user image Priviya Paulraj

posted on 10 Dec 2024

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

Performance tuning
Maintainace work on the db

Senior SQL Developer Interview Questions asked at other Companies

Q1. write an sp to with 5 input var and one output var,all int and display the max of input variables
View answer (1)

SQL Developer Interview Questions & Answers

user image Priviya Paulraj

posted on 16 Oct 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected

I applied via Naukri.com and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. What is magic table?
  • Ans. 

    Magic table is a virtual table in SQL Server that stores the data affected by DML statements.

    • Magic table is used in triggers to access the data before and after the triggering DML operation.

    • In SQL Server, INSERTED and DELETED are examples of magic tables used in triggers.

    • INSERTED table stores the new data for INSERT and UPDATE operations, while DELETED table stores the old data for UPDATE and DELETE operations.

  • Answered by AI
  • Q2. Query tuning in sql?
  • Ans. 

    Query tuning in SQL involves optimizing SQL queries to improve performance.

    • Identify slow queries using tools like query execution plans

    • Optimize queries by using indexes, avoiding unnecessary joins, and rewriting complex queries

    • Consider factors like data volume, indexing, and server resources

    • Test query performance after tuning to ensure improvements

  • Answered by AI
  • Q3. Isnull() in sql?
  • Ans. 

    ISNULL() is a SQL function used to replace NULL values with a specified value.

    • ISNULL() function is used to replace NULL values with a specified default value.

    • Syntax: ISNULL(expression, replacement_value)

    • Example: SELECT ISNULL(column_name, 'N/A') FROM table_name;

  • Answered by AI
  • Q4. Project experience?
  • Q5. Query writing with joins
  • Ans. 

    Query writing with joins involves combining data from multiple tables based on a common column.

    • Use JOIN keyword to combine tables based on a common column

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Specify the columns to select from each table and the join condition in the query

  • Answered by AI

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)
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Ds and also were asked in the rounds

Software Engineer Interview Questions asked at other Companies

Q1. Bridge and torch problem : Four people come to a river in the night. There is a narrow bridge, but it can only hold two people at a time. They have one torch and, because it's night, the torch has to be used when crossing the bridge. Person... read more
View answer (197)

Jobs at GEMINI SOFTWARE SOLUTIONS

View all

Interview questions from similar companies

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

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

Round 1 - HR 

(1 Question)

  • Q1. Hr ask about basic introduction
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - HR 

(2 Questions)

  • Q1. Why did you selected this job
  • Ans. 

    I selected this job because of my passion for analyzing data and using insights to drive decision-making.

    • Passion for data analysis

    • Opportunity to use insights for decision-making

    • Interest in working with data-driven technologies

  • Answered by AI
  • Q2. Why should I select you
  • Ans. 

    I have a strong background in data analysis, excellent problem-solving skills, and a proven track record of delivering actionable insights.

    • I have a degree in data science and have completed multiple data analysis projects during my studies.

    • I am proficient in various data analysis tools such as Python, R, and SQL.

    • I have experience in interpreting complex data sets and presenting findings to stakeholders in a clear and c

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare self introduction well .

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.

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.

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

Interview Preparation Tips

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

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
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

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SOLID principals, oops, c# basics, SQL server, azure, design pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear basics of oops and design pattern

I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions only ... regarding job and experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident ... always say the truth ... never try to fake your details

GEMINI SOFTWARE SOLUTIONS Interview FAQs

How many rounds are there in GEMINI SOFTWARE SOLUTIONS interview?
GEMINI SOFTWARE SOLUTIONS interview process usually has 1 rounds. The most common rounds in the GEMINI SOFTWARE SOLUTIONS interview process are Coding Test and Technical.
How to prepare for GEMINI SOFTWARE 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 GEMINI SOFTWARE SOLUTIONS. The most common topics and skills that interviewers at GEMINI SOFTWARE SOLUTIONS expect are C#, Javascript, SQL Server, HTML and Angular.
What are the top questions asked in GEMINI SOFTWARE SOLUTIONS interview?

Some of the top questions asked at the GEMINI SOFTWARE SOLUTIONS interview -

  1. What is magic tab...read more
  2. Isnull() in s...read more
  3. Query writing with jo...read more

Tell us how to improve this page.

GEMINI SOFTWARE SOLUTIONS Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Mphasis Interview Questions
3.4
 • 791 Interviews
View all

GEMINI SOFTWARE SOLUTIONS Reviews and Ratings

based on 28 reviews

4.2/5

Rating in categories

3.5

Skill development

4.3

Work-life balance

4.0

Salary

4.0

Job security

3.9

Company culture

3.5

Promotions

4.0

Work satisfaction

Explore 28 Reviews and Ratings
Software Developer

Thiruvananthapuram

3-4 Yrs

Not Disclosed

Service Delivery Analyst

Thiruvananthapuram

1-3 Yrs

Not Disclosed

Service DeliveryAnalyst (L1)

Thiruvananthapuram

1-3 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Service Delivery Executive
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Service Delivery Engineer
6 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare GEMINI SOFTWARE SOLUTIONS with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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