Sarvagram Fincare Interview Questions, Process, and Tips

Q1. Basic Java spring boot question
Add your answer

Q1. Basic MySQL query
Add your answer

Q1. Windows functions in SQL and use of Lag function
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to perform calculations on a set of rows related to the current row in a query result.

• The LAG function is a window function that allows you to access data from a previous row in the result set.

• Example: SELECT employee_id, salary, LAG(salary) OVER (ORDER BY hire_date) AS prev_salary FR
Answered by AI
Add your answer
Q2. Nested for loop for list example
Ans. 
Nested for loop used to iterate through a list of items
• Use a for loop to iterate through the main list

• Inside the first loop, use another for loop to iterate through each item in the sublist

• Example: for item in main_list: for sub_item in item: print(sub_item)
Answered by AI
Add your answer
Q3. What is data base and data warehouse
Ans. 
A database is a collection of structured data organized for easy access, while a data warehouse is a centralized repository for storing and analyzing large volumes of data.
• Database is used for transactional processing and storing current data.

• Data warehouse is used for analytical processing and storing historical data.

• Database is typically used for day-to-day operations.

• Data warehouse is used for decision-making and bu...read more
Answered by AI
Add your answer
Q4. Which are Joins in sql
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the righ...read more
Answered by AI
Add your answer
Q5. What is DAX in power bi
Ans. 
DAX (Data Analysis Expressions) is a formula language used in Power BI to create custom calculations and aggregations.
• DAX is similar to Excel formulas but designed for more complex data analysis tasks

• It can be used to create calculated columns, measures, and calculated tables in Power BI

• DAX functions include aggregation functions like SUM, AVERAGE, and COUNT, as well as logical functions and date functions

• Example: CALC...read more
Answered by AI
Add your answer

Just asking for previous work details

Very different and General marketing

Q1. Where is the location?
Add your answer
Q2. What is the benifits?
Ans. 
The benefits of being an MIS Executive include career growth opportunities, competitive salaries, and the ability to work with cutting-edge technology.
• Career growth opportunities: MIS Executives often have the chance to advance their careers through promotions and increased responsibilities.

• Competitive salaries: Due to the specialized nature of their work, MIS Executives typically receive competitive salaries compared ...read more
Answered by AI
Add your answer