Senior Developer Analyst

Senior Developer Analyst Interview Questions and Answers

Updated 3 Jul 2025

Asked in FNZ

6d ago

Q. Create a class Employees with fields FirstName, LastName, DoB, and Gender. Return the average age of employees, and return the average age by genders.

Ans.

Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.

Create a class Employees with fields FirstName, LastName, DoB, and Gender
Calculate the average age of all employees
Calculate the average age by genders

Asked in FNZ

4d ago

Q. Have you ever read an SQL Execution Plan?

Ans.

Yes, I have read SQL Execution Plans to optimize query performance.

I have analyzed SQL Execution Plans to identify bottlenecks in queries.
I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.
I have made query optimization recommendations based on SQL Execution Plans.
I have experience with tools like SQL Server Management Studio to view and analyze Execution Plans.

Asked in FNZ

2d ago

Q. What types of indexes are you familiar with?

Ans.

Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.

Clustered index: Physically reorders the data in the table based on the index key.
Non-clustered index: Contains a sorted list of references to the table data rows.
Unique index: Ensures that no two rows have the same values in the indexed columns.
Composite index: Index that is created on multiple columns.
Filtered index: Index that includes only a subset of rows based on a filter conditio...read more

Asked in FNZ

1d ago

Q. What design patterns do you know?

Ans.

I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.

Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and updated automatically.
MVC (Model-View-Controller) pattern se...read more

Are these interview questions helpful?

Asked in Prudent Tech IT Solutions

5d ago

Q. How do you optimize SQL Queries?

Ans.

Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.

Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate joins and subqueries

Asked in Accenture

3d ago

Q. Write a YAML pipeline for setting up a build process.

Ans.

YAML pipeline for setting up building

Define variables for build environment
Specify build steps and commands
Configure build triggers and conditions
Define artifact publishing
Set up notifications for build status

Senior Developer Analyst Jobs

FNZ is Hiring For Senior Analyst Developer (Dot Net) in Gurgaon • 5-9 years

FNZ Group

•

2.8

Gurgaon / Gurugram

Senior Analyst Developer (Dot Net) • 5-9 years

FNZ Group

•

2.8

Gurgaon / Gurugram

Senior Analyst Developer • 2-6 years

FNZ Group

•

2.8

Gurgaon / Gurugram

View all Senior Developer Analyst jobs

Asked in Accenture

1d ago

Q. Installation of agent and agent groups

Ans.

Installation of agent and agent groups

Agents are installed on servers to collect data and send it to a central location
Agent groups are used to organize agents based on their function or location
Agents can be installed manually or through automated deployment tools
Agent groups can be created and managed through the monitoring software
Proper naming conventions should be used for agents and agent groups