S R Infotech Product Specialist Interview Questions and Answers

Q1. Finance marketing based questions
Add your answer
Q2. Equity and fixed income products related questions
Add your answer

Q1. Introduction and previous experience
Add your answer
Q2. What data points to cover for underwriting?
Ans. 
Data points for underwriting include financial history, credit score, employment status, and insurance claims.
• Financial history (income, assets, debts)

• Credit score

• Employment status

• Insurance claims history
Answered by AI
Add your answer

1 hour, wage question, not related to mention technology.

Q1. Oops related queries
Add your answer
Q2. Discussion around last project
Add your answer

Q1. 1. About oil industry and what products we have worked and explain some product / feature which are new / different
Add your answer

Comprises many questions related to MTM, Costing methods, price changes, in transit oil price calculations with a case history.

Q1. 1. Questions based on case study 2. Questions related to past experience with DB, technology we have worked, related to product management
Add your answer

Q1. 1. More of a culture fit questions
Add your answer

Q1. Asked About what we know about Sapient, Why we are leaving the previous org etc.
Add your answer

Assignment given by senior executives to solve in interview

Case study round by senior executives

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Share details of your previous job.
Add your answer
Q4. Why should we hire you?
Add your answer
Q5. Where do you see yourself in 5 years?
Add your answer
Q6. What are your strengths and weaknesses?
Add your answer
Q7. Tell me about yourself.
Add your answer

Q1. Facets tables and their work flow
Ans. 
Facets tables are used to organize and display data in a structured manner, facilitating easy access and analysis.
• Facets tables are used to categorize data into different sections based on specific criteria.

• They help in organizing and presenting data in a structured format for easy analysis.

• Facets tables are commonly used in e-commerce websites to display product attributes and specifications.

• They can also be used in d...read more
Answered by AI
Add your answer

Q1. Claims Tables and the table names
Add your answer

Q1. Why do you leave your previous organization?
Add your answer

About current project and roles and resposibilities etc

Q1. SQL COMPLEX QUERIES and PL SQL, CRON JOBS, SERVICE NOW
Add your answer
Q2. What are difference between SQL and PL SQL
Ans. 
SQL is a standard language for managing relational databases, while PL/SQL is a procedural language extension for SQL.
• SQL is a standard language for querying and manipulating data in relational databases.

• PL/SQL is a procedural language extension for SQL, allowing for more complex programming logic.

• SQL is used for data manipulation and retrieval, while PL/SQL is used for writing stored procedures and functions.

• SQL state...read more
Answered by AI
Add your answer
Q3. Explain types of joins?
Ans. 
Types of joins are used in databases to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is at least one match in both tables.

• Left Join (or Left Outer Join): Returns all rows from the left table and the matched rows from the right table.

• Right Join (or Right Outer Join): Returns all rows from the right table and the matched rows from the left table.

• Full Join...read more
Answered by AI
Add your answer
Q4. Diffence between correlated and non correlated subquary?
Ans. 
Correlated subquery refers to a subquery that is dependent on the outer query, while non-correlated subquery can be executed independently.
• Correlated subquery is executed for each row processed by the outer query, while non-correlated subquery is executed only once.

• Correlated subquery is slower in performance compared to non-correlated subquery.

• Example: SELECT * FROM table1 WHERE column1 = (SELECT MAX(column2) FROM tab
Answered by AI
Add your answer
Q5. Find departement wise total sal?
Ans. 
To find department wise total salary, sum up the salaries of employees in each department.
• Group employees by department

• Calculate total salary for each department

• Display department wise total salary
Answered by AI
Add your answer