Credera Lead Consultant Interview Questions and Answers

Q1. Find the manager name with respective employee name from a table.
Ans. 
The answer to the question is to perform a join operation on the table to retrieve the manager name with respective employee name.
• Use a SQL query to join the table on the manager ID

• Select the manager name and employee name from the joined table

• Display the manager name with respective employee name
Answered by AI
Add your answer
Q2. How to find the 3rd highest salary of any Employee from a table?
Ans. 
To find the 3rd highest salary of any Employee from a table, we can use the SQL query with the 'ORDER BY' and 'LIMIT' clauses.
• Write an SQL query to select the distinct salaries from the table in descending order.

• Use the 'LIMIT' clause to limit the result to the third row.

• The selected salary will be the 3rd highest salary of any employee.
Answered by AI
Add your answer

Q1. About how my day to day looks like.
Add your answer

Q1. About my job roles and the work around.
Add your answer

Q1. Date of joining
Add your answer

Multiple Question and Answers in various levels

Any Programming skill evaluation along with the logic and coding standards

Q1. General HR related questions job fitment other
Add your answer
Q2. Why Sirius ? what do you know about Sirius?
Ans. 
Sirius is a leading technology and consulting firm.
• Sirius provides IT solutions and services to clients across various industries.

• They specialize in cloud, data center, security, and analytics solutions.

• Sirius has partnerships with major technology vendors like IBM, Microsoft, and Cisco.

• They have won numerous awards for their services and expertise.

• Sirius has a strong focus on customer satisfaction and building long-te
Answered by AI
Add your answer

In the first round, a set of 20 MCQ were asked related to general aptitude.

Q1. In the panel there were 2 interviewers, they asked about previous experience. Technical questions were related to Database: Diff between drop and delete, basic sql commands. Asked how to handle the client...read more
Add your answer

Q1. JS basincs in depth and react js
Ans. 
JS basics and React JS are essential for web development.
• JS basics include variables, data types, functions, and control structures.

• React JS is a popular JavaScript library for building user interfaces.

• React components, state, and props are important concepts to understand.

• JSX is a syntax extension used in React to write HTML-like code.

• React Router is a library used for client-side routing in React applications.
Answered by AI
Add your answer

Q1. ES6 and promises and virtual dom. Reactjs in depth
Add your answer

Q1. Expectation of salary
Add your answer