Futurense Technologies Interview Questions, Process, and Tips

On python and sql code and meq on python and sql

Q1. Basic python and sql
Add your answer
Q2. Duplicate in list ,variable length arguments
Add your answer

Q1. Yet to done i dont have any knolage on this
Add your answer

Q1. Sql - List top 3 youngest ages of employees dept wise
Ans. 
List top 3 youngest ages of employees dept wise using SQL.
• Use GROUP BY to group employees by department.

• Use ORDER BY to sort ages in ascending order.

• Use LIMIT to get top 3 youngest ages.

• Use MIN to get the youngest age in each department.
Answered by AI
View 3 more answers
Q2. Sql - List employees whose age is greater than average age of all employees
Ans. 
List employees whose age is greater than average age of all employees using SQL.
• Calculate the average age of all employees using AVG() function.

• Use WHERE clause to filter out employees whose age is greater than the average age.

• Join the employee table with the age table to get the age of each employee.

• Example: SELECT * FROM employees WHERE age > (SELECT AVG(age) FROM employees);
Answered by AI
View 1 more answer
Q3. Python - sum of digits till the result becomes single digit Ex: 479 - 20 - 2
Ans. 
Python program to find the sum of digits till the result becomes a single digit.
• Convert the number to a string and iterate through each digit.

• Add the digits and store the result.

• Repeat the process until the result becomes a single digit.

• Return the single digit result.
Answered by AI
View 7 more answers

Q1. Basic HR questions like why futurense, qualities that get you into futurense
Add your answer

Q1. Total and relevant exp
Add your answer
Q2. Notice period, Current and exp CTC
Add your answer
Q3. Job portals worked on
Ans. 
I have worked on various job portals such as LinkedIn, Indeed, Glassdoor, and Monster.
• LinkedIn

• Indeed

• Glassdoor

• Monster
Answered by AI
Add your answer
Q4. Selection and joiners ratio
Add your answer

Mettel Python SQL general python

Q1. Sql concepts some queries on window functions
Add your answer

Both Aptitude and coding

Q1. Basic Java questions
Add your answer

Q1. Salary discussion only
Add your answer

20 MCQ's on SQL and Python. 2 coding questions one from Python and SQL.
Level: Intermediate.

Focus more on Subqueries, Window functions.
Pandas and Numpy in Python.

Q1. How to you deal a problematic employee working for the same project.
Ans. 
To deal with a problematic employee, address the issue directly, provide clear expectations, offer support and guidance, and consider disciplinary actions if necessary.
• Address the issue directly and communicate concerns

• Provide clear expectations and goals for the project

• Offer support and guidance to help the employee improve

• Consider disciplinary actions if the problem persists

• Document incidents and maintain a record of
Answered by AI
Add your answer

Aptitude test on their own application

Q1. Different interview questions for Data Engineers and for Java DEVELOPERS
Add your answer

Q1. Basic question for joining etc
Add your answer