Filter interviews by
An SQL query retrieves data from a database using specific criteria and commands.
SELECT statement: Used to select data from a database. Example: SELECT * FROM employees;
WHERE clause: Filters records based on specified conditions. Example: SELECT * FROM employees WHERE age > 30;
JOIN operation: Combines rows from two or more tables based on a related column. Example: SELECT * FROM orders JOIN customers ON orders....
A testing framework is a set of guidelines, coding standards, concepts, processes, practices, project artifacts, tools, and templates used to create and execute automated tests.
Provides a structure for organizing test scripts and test data
Offers reusable components for test automation
Helps in managing test execution and reporting
Examples: Selenium, JUnit, TestNG
As a Software Development Engineer, my day involves coding, collaborating, and problem-solving to deliver high-quality software solutions.
Start the day by reviewing project requirements and prioritizing tasks based on deadlines and team goals.
Engage in daily stand-up meetings to discuss progress, roadblocks, and coordinate with team members.
Write and review code, ensuring adherence to best practices and coding sta...
Addressing unequal leave approval requires communication, understanding, and professionalism to resolve the situation effectively.
Request a private meeting with the manager to discuss the leave request and understand their reasoning.
Express your concerns about the perceived unfairness and how it affects your morale and productivity.
Provide context for your leave request, such as personal commitments or health issu...
Use SQL JOIN to combine 3 tables with a specific condition.
Use INNER JOIN to combine the tables based on a common column
Specify the condition in the ON clause of the JOIN statement
You can also use LEFT JOIN or RIGHT JOIN depending on your requirement
Functions are used to perform specific tasks and return a value, while stored procedures are used to perform a series of actions.
Functions return a single value, while stored procedures can return multiple values or no value at all.
Functions can be called from within SQL statements, while stored procedures are called using the EXECUTE statement.
Functions are used for calculations or data manipulation, while stored...
Write DB queries for given condition
Use SELECT statement to retrieve data from database
Use WHERE clause to specify the condition for filtering data
Use JOIN clause if data needs to be retrieved from multiple tables
I want to join Fiserv to contribute to innovative financial solutions and enhance quality assurance processes in a dynamic environment.
Fiserv is a leader in financial technology, and I am excited about the opportunity to work with cutting-edge solutions.
The company's commitment to innovation aligns with my passion for continuous improvement in quality assurance practices.
I admire Fiserv's focus on customer satisfa...
A Java program to print pyramid patterns using loops and arrays.
Use nested loops: Outer loop for rows, inner loop for spaces and stars.
Example: For a 5-row pyramid, outer loop runs 5 times.
Inner loop prints spaces: ' ' for alignment before stars.
Inner loop prints stars: '*' to form the pyramid shape.
Use arrays to store pyramid levels if needed for complex patterns.
Yes, I can work night shifts and understand the importance of flexibility in quality assurance roles.
I have previously worked night shifts in my last role, ensuring quality checks were completed on time.
I understand that night shifts may require adjustments in my routine, and I'm prepared to manage that effectively.
I believe working at night can provide a quieter environment, allowing for more focused quality asse...
I appeared for an interview in Jan 2025.
I applied via Referral and was interviewed in Nov 2024. There was 1 interview round.
I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.
AI vs Human what is best
In 5 years, I see myself as a senior Process Associate leading a team and contributing significantly to the growth of the company.
Continuing to excel in my role as a Process Associate
Taking on additional responsibilities and leadership roles within the team
Contributing innovative ideas to improve processes and efficiency
Mentoring and training new team members
Building strong relationships with clients and stakeholders
I have 5 years of experience as a Sales Training Manager in the technology industry.
Developed and implemented sales training programs for new hires and existing employees
Utilized various training methods such as role-playing, workshops, and online modules
Analyzed sales performance data to identify training needs and areas for improvement
Our client base consists of a diverse range of industries including technology, healthcare, finance, and retail.
Clients come from various industries such as technology, healthcare, finance, and retail
We work with both small businesses and large corporations
Our clients are located both domestically and internationally
I handle clients by building strong relationships and providing exceptional service.
I prioritize communication and actively listen to clients' needs
I personalize solutions to meet each client's unique requirements
I follow up regularly to ensure client satisfaction
I address any issues promptly and effectively to maintain trust and loyalty
I continuously seek feedback to improve services and exceed expectations
Yes, I am archiving the target as per company norms.
Yes, I ensure that all sales targets are archived according to company guidelines.
I maintain detailed records of sales targets achieved and missed.
Regularly review and update archived targets to track progress and performance.
Provide reports on archived targets to management for analysis and decision-making.
Yes, I am willing to do open market cold calling as part of my job as a Sales Training Manager.
I have experience in cold calling and understand its importance in generating leads and sales.
I am confident in my communication skills and ability to build rapport with potential clients over the phone.
I am willing to put in the effort and time required to make successful cold calls and achieve sales targets.
Order By is used to sort the result set in ascending or descending order, while Group By is used to group the result set by one or more columns.
Order By is used with SELECT statement to sort the result set based on specified column(s)
Group By is used with SELECT statement to group the result set based on specified column(s)
Order By can be used with or without Group By, but Group By requires an aggregate function like C...
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down data into smaller, more manageable tables
It reduces data redundancy by eliminating duplicate data
Normalization helps maintain data integrity by ensuring data is stored in a consistent manner
There are different levels of normalization, such as First Normal Form (1NF), Second ...
Primary key uniquely identifies a record in a database table, while a unique key ensures that all values in a column are different.
Primary key is used to uniquely identify each record in a table
Primary key does not allow NULL values
Unique key ensures that all values in a column are different
Unique key can have NULL values, but only one NULL per column
Types of inheritance include single, multiple, multilevel, hierarchical, hybrid, and so on.
Single inheritance: a class inherits from only one base class.
Multiple inheritance: a class inherits from more than one base class.
Multilevel inheritance: a class inherits from a class which in turn inherits from another class.
Hierarchical inheritance: multiple classes inherit from a single base class.
Hybrid inheritance: a combin...
It was online test on hackerrank platform there were 2-3 programming questions and you have to clear all of the test cases
Write DB queries for given condition
Use SELECT statement to retrieve data from database
Use WHERE clause to specify the condition for filtering data
Use JOIN clause if data needs to be retrieved from multiple tables
I applied via Approached by Company and was interviewed in Mar 2024. There were 3 interview rounds.
I have extensive experience in release engineering, including managing release cycles, coordinating with cross-functional teams, and ensuring smooth deployments.
Managed release cycles for multiple software products
Coordinated with development, QA, and operations teams to plan and execute releases
Implemented release automation tools to streamline the release process
Ensured compliance with release management best practic...
Branching strategy is decided based on project complexity, team size, release frequency, and risk tolerance.
Consider project complexity - simple projects may only need a main branch, while complex projects may require feature branches.
Take team size into account - larger teams may benefit from feature branches to work on separate tasks concurrently.
Evaluate release frequency - frequent releases may warrant a branching ...
I manage the release process by coordinating with development, testing, and operations teams to ensure smooth deployment.
Coordinate with development, testing, and operations teams to plan release schedule
Ensure all necessary documentation and release notes are prepared
Perform risk assessment and mitigation strategies
Use version control systems to track changes and releases
Communicate with stakeholders about release sta...
I have experience using tools like Jenkins, Git, Docker, and Ansible for release management.
Jenkins
Git
Docker
Ansible
Nexus is a repository manager that allows you to proxy, collect, and manage dependencies of many different types.
Nexus is used to store and manage software artifacts such as JARs, WARs, and Docker images.
It helps in controlling access to repositories and ensures that only approved artifacts are used in builds.
Nexus can also act as a proxy to other repositories, reducing build times and improving reliability.
It provides...
Deployment strategies include blue-green deployment, canary deployment, rolling deployment, and feature toggles.
Blue-green deployment involves running two identical production environments and switching between them.
Canary deployment gradually rolls out changes to a small subset of users before deploying to the entire infrastructure.
Rolling deployment updates a subset of servers at a time, ensuring continuous availabil...
I prepare release documentation by creating detailed release notes, updating user guides, and communicating changes to stakeholders.
Create detailed release notes outlining new features, bug fixes, and any known issues
Update user guides to reflect changes in the new release
Communicate release changes to stakeholders through emails, meetings, or documentation
Ensure all documentation is clear, concise, and easily accessib...
Recommend prioritizing the critical bug fix and delaying the release for the application
Prioritize the critical bug fix for the application that is not widely used
Coordinate with QA and dev teams to ensure the bug fix is thoroughly tested
Communicate with stakeholders about the delay in release and the reasons behind it
Top trending discussions
Some of the top questions asked at the Fiserv interview -
The duration of Fiserv interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 131 interview experiences
Difficulty level
Duration
based on 2.6k reviews
Rating in categories
Technical Lead
1.5k
salaries
| ₹11 L/yr - ₹40 L/yr |
Senior Associate
555
salaries
| ₹3.6 L/yr - ₹13.7 L/yr |
Specialist
532
salaries
| ₹8.2 L/yr - ₹29.3 L/yr |
Senior Software Engineer
439
salaries
| ₹6.9 L/yr - ₹29 L/yr |
Professional
385
salaries
| ₹5.8 L/yr - ₹20 L/yr |
Global Payments
Paytm
FIS
PhonePe