Upload Button Icon Add office photos

Filter interviews by

Firstsource Solutions Senior Technology Executive Interview Questions and Answers

Updated 9 Jul 2022

Firstsource Solutions Senior Technology Executive Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed in Jan 2022. There were 3 interview rounds.

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

(1 Question)

  • Q1. Have you knowledge in oracle's sql and pl sql
  • Ans. 

    Yes, I have extensive knowledge in Oracle's SQL and PL/SQL.

    • I have worked with Oracle databases for over 10 years

    • I am proficient in writing complex SQL queries and stored procedures using PL/SQL

    • I have experience in performance tuning and optimization of SQL queries

    • I have worked with Oracle's database tools such as SQL Developer and Toad

    • I have also trained and mentored junior developers in SQL and PL/SQL

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. What is join,store procedure, store functions, real-time work
  • Ans. 

    Join, stored procedures, stored functions, and real-time work are all related to database management and programming.

    • Join is used to combine data from two or more tables based on a related column.

    • Stored procedures are pre-written SQL codes that can be executed with a single command.

    • Stored functions are similar to stored procedures but return a value.

    • Real-time work refers to processing data as it is received, without de

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Firstsource Solutions Senior Technology Executive interview:
  • Oracle
Interview preparation tips for other job seekers - 1st learn more deeply then started interviews.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I was interviewed in Jul 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Coding related questions mostly
  • Q2. Interview taken on dc
Round 2 - HR 

(2 Questions)

  • Q1. Interview taken on cl
  • Q2. Coding related theoretical questions

Interview Preparation Tips

Interview preparation tips for other job seekers - nothing dont join if you want to pursue good career in development,
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Assignment 

Essay question based on credit cards and advantages and disadvantages

Round 2 - Group Discussion 

Discussion about thoughts

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

(1 Question)

  • Q1. Explain completed project details

Interview Preparation Tips

Interview preparation tips for other job seekers - Explain your existing projects
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2023. There were 4 interview rounds.

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

(2 Questions)

  • Q1. Discussion on current organisation and linux
  • Q2. What I am doing in my current company as platform administrator
Round 3 - Technical 

(1 Question)

  • Q1. Basic question on Linux
Round 4 - Technical 

(1 Question)

  • Q1. Basics of Hadoop
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Oct 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. List the aggregate and window function in oracle
  • Ans. 

    Aggregate functions perform calculations on a set of values and return a single value. Window functions perform a calculation across a set of table rows.

    • Aggregate functions: SUM, AVG, COUNT, MAX, MIN

    • Window functions: ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD

  • Answered by AI
  • Q2. How to load flat file
  • Ans. 

    To load a flat file, use a data loading tool or script to import the file into a database or application.

    • Use a data loading tool like SQL Loader, Informatica, or Talend to load the flat file into a database.

    • Write a script in a programming language like Python, Java, or Perl to read the flat file and insert the data into a database.

    • Ensure the flat file is properly formatted and matches the schema of the database or appl

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
More than 8 weeks
Result
-

I applied via Recruitment Consulltant and was interviewed before Mar 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Interview pattern was nyc
  • Q2. Many interview questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Many interview questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep concentrate on technical side and prepare well
Interview experience
4
Good
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I applied via campus placement at Graphic Era University, Dehradun and was interviewed before Mar 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

High level English, Aptitude questions mcq based.

Round 2 - Technical 

(1 Question)

  • Q1. Project related questions were asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Know basics of what u have added in the resume.
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 
Round 3 - Technical 

(1 Question)

  • Q1. How to do test a perticuler application if we dont have any requirement
  • Ans. 

    Testing an application without requirements

    • Explore the application to understand its functionality

    • Create test cases based on the observed behavior

    • Use exploratory testing to uncover any hidden defects

    • Collaborate with stakeholders to gather requirements if possible

    • Consider industry standards and best practices for similar applications

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. How to do testing if we dont have any requirement
  • Ans. 

    Testing without requirements

    • Identify the purpose of the system or application

    • Create test cases based on common user scenarios

    • Use exploratory testing to uncover issues

    • Collaborate with stakeholders to gather requirements

    • Consider industry standards and best practices

    • Document any assumptions made during testing

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Make resume best so HR can easily find

Skills evaluated in this interview

I applied via Company Website and was interviewed in Oct 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Tell me your day to day activity
Round 3 - HR 

(2 Questions)

  • Q1. What are your salary expectations?
  • Q2. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't sceard to give any interview you should give frank mind to give any interview

Firstsource Solutions Interview FAQs

How many rounds are there in Firstsource Solutions Senior Technology Executive interview?
Firstsource Solutions interview process usually has 3 rounds. The most common rounds in the Firstsource Solutions interview process are Resume Shortlist, HR and Technical.
What are the top questions asked in Firstsource Solutions Senior Technology Executive interview?

Some of the top questions asked at the Firstsource Solutions Senior Technology Executive interview -

  1. What is join,store procedure, store functions, real-time w...read more
  2. Have you knowledge in oracle's sql and pl ...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.3k Interviews
Accenture Interview Questions
3.9
 • 8.1k Interviews
Infosys Interview Questions
3.7
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Firstsource Solutions Senior Technology Executive Salary
based on 4 salaries
₹6.2 L/yr - ₹11 L/yr
106% more than the average Senior Technology Executive Salary in India
View more details

Firstsource Solutions Senior Technology Executive Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

4.0

Skill development

5.0

Work-life balance

2.0

Salary

4.0

Job security

3.0

Company culture

2.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Senior Analyst
2.2k salaries
unlock blur

₹2 L/yr - ₹7.3 L/yr

Analyst
1.7k salaries
unlock blur

₹1.9 L/yr - ₹6 L/yr

Customer Service Associate
1.1k salaries
unlock blur

₹0.9 L/yr - ₹5 L/yr

Associate
1k salaries
unlock blur

₹1.5 L/yr - ₹5.2 L/yr

Senior Customer Service Associate
947 salaries
unlock blur

₹1 L/yr - ₹5.6 L/yr

Explore more salaries
Compare Firstsource Solutions with

Infosys

3.7
Compare

Wipro

3.7
Compare

TCS

3.7
Compare

HCLTech

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