Torry Harris Integration Solutions Data Engineer Interview Questions and Answers

Based on SQL , statistics , python , cognitive

Q1. Based on AI/Ml and based on cv
Add your answer
Q2. Based on projects
Add your answer

Q1. How to handle toxic work culture?
Ans. 
Address toxic work culture by open communication, setting boundaries, seeking support, and considering leaving if necessary.
• Open communication with colleagues and management about issues

• Set boundaries to protect your mental and emotional well-being

• Seek support from HR, a mentor, or a therapist if needed

• Consider leaving the toxic work environment if the situation does not improve
Answered by AI
Add your answer
Q2. 5 strength and weakness
Add your answer

Q1. Spark basic question , hive related questions.
Add your answer

Q1. Questions on Pyspark
Add your answer
Q2. Questions on SQL
Add your answer
Q3. Transformations
Add your answer
Q4. Questions on Sql optimizations
Add your answer
Q5. Questions About my current Project
Add your answer

Q1. Incremental load in pyspark
Ans. 
Incremental load in pyspark refers to loading only new or updated data into a dataset without reloading the entire dataset.
• Use the 'delta' function in pyspark to perform incremental loads by specifying the 'mergeSchema' option.

• Utilize the 'partitionBy' function to optimize incremental loads by partitioning the data based on specific columns.

• Implement a logic to identify new or updated records based on timestamps or uni...read more
Answered by AI
Add your answer
Q2. Drop duplicates
Add your answer

Technical Assessment Test (MCQs) - 30 mins.

Q1. Basic Questions on: 1.Python 2.SQL 3.Spark
Add your answer
Q2. Python: Replace all occurrences of word: "apple" with "froot" and count no.of occurrences of word: "apple" - in a given string (multiple lines) SQL: 1. Retrieve employee details, drawing the maximum salar...read more
Add your answer
Q3. Convert string (multiple lines) to list
Ans. 
Use the split() method to convert a string with multiple lines into a list of strings.
• Use the split() method with the newline character '\n' as the delimiter to split the string into a list of strings.

• Example: 'Hello\nWorld\n' -> ['Hello', 'World']
Answered by AI
Add your answer
Q4. Convert string of multiple lines with 'n' words to multiple arrays of fixed size: k, with no overlap of elements accross arrays.
Ans. 
Convert a string of multiple lines with 'n' words to multiple arrays of fixed size without overlap.
• Split the string into individual words

• Create arrays of fixed size 'k' and distribute words evenly

• Handle cases where the number of words is not divisible by 'k'
Answered by AI
Add your answer

Java and sql questions

Simple java program for find factorial and prime number

Basic aptitude and three levels of coding (easy,medium,hard)

Q1. Sql and java programming question
Add your answer

Q1. Advanced questions on sql and programming
Add your answer

Q1. Normal hobbies and communication skills
Add your answer