Exl India Data Engineer Interview Questions and Answers for Freshers

Python, SQL, Aptitude

Q1. SQL - A table EmployeeSkills was given having two columns EmpID & Skills. There can be multiple for an employee id with skills he possess. You need to find the EmpID having skills in Python and SQL
Add your answer
Q2. PowerBI - Create Bookmarks in Power BI
Ans. 
Bookmarks in Power BI allow users to save the state of a report, including filters, slicers, and visuals.
• Bookmarks can be created by selecting 'View' and then 'Bookmarks' in the Power BI toolbar.

• Users can add bookmarks by selecting 'Add' and then naming the bookmark.

• Bookmarks can be applied by selecting the desired bookmark from the 'Bookmarks' pane.

• Bookmarks can be used to save different views of a report for easy acc
Answered by AI
Add your answer
Q3. SQL - Find cumulative Profit sum in a given table.
Ans. 
Use SQL query with window function to find cumulative profit sum in a given table.
• Use window function like SUM() with ORDER BY clause to calculate cumulative profit sum.

• Example: SELECT date, profit, SUM(profit) OVER (ORDER BY date) AS cumulative_profit FROM table_name;

• Ensure the table has a column for date and profit to order and calculate cumulative sum.
Answered by AI
Add your answer

SQL, Python and Power BI

First round was aptitude test,duration is of 25 minutes involves SQL,PowerBI,Python, Qunatitative Aptitude,SAS skillset

Q1. The interviewer asked about the projects that i have done.
Add your answer
Q2. Tell me about some of the projects that you have done.
Add your answer

Q1. Detailed questions on probability. Statistical questions.
Add your answer

SQL, Python Coding & MCQ test

Behavioural questions mostly, they tey ro find approach.

Q1. Salary negotiations
Add your answer
Q2. Location preference
Add your answer

Q1. Initially there was phone screening round. After I was informed there were 3 rounds. First round is Technical Round 1. Second round is Technical Round 2/Behavioral Round. Third Round is HR round. There wer...read more
Add your answer
Q2. First Technical Round includes Scenario based SQl questions on joins, subquery, rank, dense_rank,etc Python code questions . Concepts of sql optimizatinos, current exp and project
Add your answer
Q3. Second Technical Round includes advanced sql scenario based questions, python code based questions, optimizations techniques. Behavioral included why fedex and fedex related questions
Add your answer