Exponentia.ai Interview Questions, Process, and Tips

Q1. Explain any 1 of your Project.
Add your answer
Q2. SQL: Explain difference between Delete, Truncate and Drop. Difference between Group by and Having. Asked to write a update query.
Add your answer
Q3. Python: Difference between Set and Dictionary. Can we update key in dictionary? Write solution for given python question (nums = [1,2,3,4,5,7,10] target = 9 output = [1,5])
Ans. 
Set is a collection of unique elements, while dictionary is a collection of key-value pairs. Keys in dictionary can be updated.
• Set does not allow duplicate elements, while dictionary allows duplicate values but not duplicate keys.

• Dictionary uses key-value pairs for storing data, while set only stores individual elements.

• Example: Set - {1, 2, 3}, Dictionary - {'a': 1, 'b': 2}

• Yes, keys in dictionary can be updated by ass
Answered by AI
Add your answer

Q1. Explain projects where you have implemented ETL. Difference between aws lambda and aws glue
Add your answer
Q2. Non-Technical questions
Add your answer

Q1. On which Talend version u are working ?
Ans. 
I am currently working on Talend version 7.3.1.
• Working on Talend version 7.3.1

• Familiar with the features and updates in this version

• Experience in developing ETL processes using this version
Answered by AI
Add your answer
Q2. How to do parallel processing in Talend with examples?
Ans. 
Parallel processing in Talend allows for executing multiple tasks simultaneously, improving performance.
• Use tParallelize component to run subjobs in parallel

• Enable parallel execution in job settings

• Utilize tFlowToIterate to process data in parallel

• Implement parallel processing for large data sets to optimize performance
Answered by AI
Add your answer

Q1. Questions regarding basic Spark architecture
Add your answer

Sicario based questions in Databricks and azure data factory

Q1. Conflict resolution in team, and regarding my current role
Add your answer

Q1. General HR questions, Why do you want our join our company
Add your answer

Q1. What do you know about PMS
Add your answer