Add office photos
Filter interviews by
Fiserv Software Development Engineer 3 Interview Questions, Process, and Tips
Fiserv Software Development Engineer 3 Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed before Aug 2020. There were 5 interview rounds.
Interview Questionnaire
6 Questions
- Q1. How to define a parameterized cursor in PLSQL , how to open and close it
- Ans.
Defining and using a parameterized cursor in PL/SQL
Declare a cursor variable with parameters
Open the cursor using the OPEN statement and pass in the parameter values
Fetch rows from the cursor using the FETCH statement
Close the cursor using the CLOSE statement
- Q2. Write a query to delete duplicate records from a table
- Ans.
Query to delete duplicate records from a table
Use GROUP BY to group the records by the columns that define duplicates
Use HAVING to filter out groups with count greater than 1
Use DELETE to remove the duplicate records
- Q3. What is Rownum ? Is expression Rownum >4 correct ?
- Ans.
Rownum is a pseudocolumn in Oracle that assigns a unique number to each row returned by a query.
Rownum starts with 1 and increments by 1 for each row returned by the query.
The expression Rownum > 4 is correct and will return all rows with a Rownum greater than 4.
Rownum can be used to limit the number of rows returned by a query, for example, 'SELECT * FROM table WHERE Rownum <= 10'.
- Q4. What is the difference between procedure and function
- Ans.
Procedure is a set of instructions that performs a specific task, while function returns a value after performing a specific task.
Procedure does not return a value, while function returns a value
Procedure can modify the values of input parameters, while function cannot
Functions can be called from within a procedure, but procedures cannot be called from within a function
- Q5. What are triggers , where can they be used ? What is a mutating trigger problem , how can it be solved?
- Ans.
Triggers are database objects that execute automatically in response to certain events. Mutating trigger problem occurs when a trigger tries to read or modify a table that is already being modified by the same transaction.
Triggers can be used to enforce business rules, audit changes, and maintain referential integrity.
They can be used to automatically update a table when a related table is updated.
Mutating trigger prob...
- Q6. How to define user defined exceptions ?
- Ans.
User defined exceptions can be defined by creating a new class that extends the Exception class.
Create a new class that extends the Exception class
Add constructors to the class to initialize the exception
Throw the exception using the 'throw' keyword
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
(3 Questions)
- Q1. Search in a sorted matrix
- Ans.
Search for a target value in a sorted matrix efficiently.
Start from the top right corner and move left or down based on comparison with target value
Utilize the sorted nature of the matrix to eliminate certain rows or columns
Implement binary search for more efficient search in each row or column
- Q2. Rotting orange graph
- Q3. Database Indexing and SQL
(3 Questions)
- Q1. Design Patterns
- Q2. Medium level Binary tree question
- Q3. Previous work discussion
Skills evaluated in this interview
Aditya Gautam
I applied via campus placement at National Institute of Technology (NIT), Raipur and was interviewed in Nov 2024. There were 3 interview rounds.
The DSA round happens with pseudo code
(2 Questions)
- Q1. Question asked from my resume
- Q2. How I implemented everything
(2 Questions)
- Q1. Why you want to join
- Q2. Where do you see yourself in five years
Interview Preparation Tips
Software Engineer Interview Questions & Answers
Broadridge Financial Solutions
Anonymous
posted on 3 Jan 2025
I applied via Campus Placement
A test that covers all fundamental topics, including networking, object-oriented programming (OOP), and data structures and algorithms (DSA).
(2 Questions)
- Q1. Write code for quick sort
- Q2. Puzzle
(2 Questions)
- Q1. Java Fundamentals
- Q2. System Design
(2 Questions)
- Q1. Previous experience
- Q2. Spring boot
(2 Questions)
- Q1. Offer discussion
- Q2. Onboarding process
I applied via Job Portal
(2 Questions)
- Q1. Explain the react lifecycle functions and how they work
- Ans.
React lifecycle functions are methods that are automatically called at specific points in a component's life cycle.
Mounting: constructor, render, componentDidMount
Updating: render, componentDidUpdate
Unmounting: componentWillUnmount
- Q2. Css box model, difference between padding and margin
- Ans.
Padding is the space inside the border of an element, while margin is the space outside the border.
Padding is used to create space between the content and the border of an element.
Margin is used to create space between the border of an element and other elements.
Padding affects the size of the content area, while margin affects the positioning of the element.
Example: padding: 10px will create 10 pixels of space inside ...
(2 Questions)
- Q1. What are your salary expectations in CTC and variables?
- Q2. Will you relocate to the location required?
Interview Preparation Tips
Skills evaluated in this interview
Rajamani S
I applied via Referral and was interviewed in Nov 2024. There were 3 interview rounds.
Data structures and algo. 2 ques were asked in hackerrank
(1 Question)
- Q1. Questions related to System design
(1 Question)
- Q1. Basic question related to Spring and Java
Senior Software Engineer Interview Questions & Answers
Experian
Sayantan Biswas
posted on 28 Dec 2024
Selected
I applied via LinkedIn and was interviewed in Jun 2024. There were 5 interview rounds.
Java coding questions, basic Java questions.
(2 Questions)
- Q1. Java basics questions.
- Q2. Live coding.
(2 Questions)
- Q1. Discussion on previous experience and projects.
- Q2. System design question
(2 Questions)
- Q1. Questions on SQL, Java advanced, personal projects, Java frameworks, UI based questions, Agile methodologies.
- Q2. Interview discussion with the whole team.
(2 Questions)
- Q1. Benefits discussion.
- Q2. Salary discussion.
I applied via campus placement at Visveswaraiah Technological University (VTU) and was interviewed in Aug 2024. There were 2 interview rounds.
Simple aptitude questions and multiple choice coding questions were asked.
(3 Questions)
- Q1. Explanation about project
- Ans.
I have worked on a project to develop a mobile application for tracking fitness activities and providing personalized workout plans.
Developed user-friendly interface for inputting and tracking fitness data
Implemented algorithms to generate personalized workout plans based on user's goals and progress
Integrated with wearable devices to automatically sync activity data
Conducted thorough testing to ensure accuracy and rel...
- Q2. SQL queries which were easy
- Q3. Linked list and arrays
Interview Preparation Tips
(1 Question)
- Q1. LLD/Machine coding - Design a social media application with users, posts, comments, likes, etc. There is also an admin who needs to approve post creation and can delete any post they want. Create appropria...
(1 Question)
- Q1. High-level design - Design a chat-based application like WhatsApp with only user-to-user chat feature (no group chats). Explain and draw out the E2E design by mentioning all the components and design decis...
(1 Question)
- Q1. Hiring Manager - basic questions like why Razorpay, what are your career goals, what does career growth look like for you, etc.
Fiserv Interview FAQs
Some of the top questions asked at the Fiserv Software Development Engineer 3 interview -
Tell us how to improve this page.
Fiserv Interviews By Designations
- Fiserv Technology Analyst Interview Questions
- Fiserv Software Engineer Interview Questions
- Fiserv Software Developer Interview Questions
- Fiserv Specialist Interview Questions
- Fiserv Technical Lead Interview Questions
- Fiserv Project Manager Interview Questions
- Fiserv Associate Interview Questions
- Fiserv Configuration Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Software Developer Interview Questions
- Senior Software Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Softwaretest Engineer Interview Questions
- Senior Software Developer Interview Questions
- Software Tester Interview Questions
- Software Engineer Trainee Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
|
Technical Lead
1.4k
salaries
|  ₹11 L/yr - ₹36 L/yr |
|
Senior Associate
527
salaries
| ₹3.5 L/yr - ₹15 L/yr |
|
Specialist
477
salaries
| ₹10.2 L/yr - ₹29 L/yr |
|
Senior Software Engineer
454
salaries
| ₹7 L/yr - ₹28.5 L/yr |
|
Professional
366
salaries
| ₹5.2 L/yr - ₹19.4 L/yr |
Global Payments
FIS
Broadridge Financial Solutions
NCR Corporation
Calculate your in-hand salary
- Home >
- Interviews >
- Fiserv Interview Questions >
- Fiserv Software Development Engineer 3 Interview Questions
