OneAssist Consumer Solutions Business Intelligence Developer Interview Questions and Answers

Basic aptitude questions and 2 hard DP questions in the Online Test .

Q1. Basic SQL queries
Add your answer
Q2. OOP questions Java
Add your answer
Q3. Puzzles from Geeksforgeeks
Add your answer
Q4. DSA questions - medium level
Add your answer

Q1. DSA and array manipulation
Add your answer

Q1. ReactJS features
Add your answer

Q1. Type of Joins, Syntax of Join
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Syntax of join: SELECT columns FROM table1 JOIN table2 ON table1.column = table2.column

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer

Q1. Introduction , knowledge about capital market
Add your answer

Nothing as such just basic

Q1. What are your salary expectations?
Add your answer

Q1. Tell me something about your self
Ans. 
I am a dedicated and experienced professional with a strong background in project management and team leadership.
• Over 10 years of experience in project management

• Proven track record of successfully leading cross-functional teams

• Strong communication and interpersonal skills

• Certified in project management (e.g. PMP)

• Passionate about driving results and exceeding goals
Answered by AI
Add your answer
Q2. Where you see in next 5 year
Ans. 
In the next 5 years, I see myself advancing to a managerial role within the company, leading a team and contributing to the growth and success of the organization.
• Continuing to excel in my current role and taking on additional responsibilities

• Participating in leadership development programs to enhance my skills

• Building strong relationships with colleagues and stakeholders to foster collaboration and teamwork

• Seeking opp...read more
Answered by AI
Add your answer

Q1. Experience, salary expectations.
Add your answer

Q1. What is commodity, derivatives, expiry. What is spot and futures.
Add your answer