Hexaware Technologies Interview Questions, Process, and Tips

Creating a dataframe in adb using struct type

• Use the 'CREATE TABLE' statement to define the schema of the dataframe

• Define the struct type using 'STRUCT' keyword

• Insert data into the dataframe using 'INSERT INTO' statement

Code to find max and second highest salary department wise

• Iterate through the list of employees and store max and second highest salary for each department

• Use a hashmap to store department wise salaries

• Sort the salaries in descending order to find max and second highest

You can call a variable from one notebook to another in adb by using the %run magic command.

• Use the %run magic command followed by the path to the notebook containing the variable you want to access.

• Make sure the notebook containing the variable is in the same directory or provide the full path.

• Once you run the %run command, the variables from the other notebook will be available in the current notebook.

Incremental load in ADF is achieved by using watermark columns to track the last loaded data and only loading new or updated records.

• Use watermark columns to track the last loaded data

• Compare the watermark column value with the source data to identify new or updated records

• Use a filter condition in the source query to only select records with a timestamp greater than the watermark value

• Update the watermark column value

I am a dedicated and empathetic Customer Care Executive with a passion for helping customers resolve their issues and providing excellent service.

• I have over 5 years of experience in customer service roles, including handling inquiries, complaints, and escalations.

• I am skilled in active listening, problem-solving, and conflict resolution.

• I strive to create positive customer experiences by going above and beyond to meet

I am from New York City, known for its diverse culture and iconic landmarks.

• Born and raised in the bustling city of New York

• Grew up surrounded by a mix of cultures and traditions

• Familiar with famous landmarks like the Statue of Liberty and Central Park

I am a dedicated and empathetic customer care executive with a passion for helping customers resolve their issues.

• I have over 5 years of experience in customer service roles

• I am skilled in active listening and problem-solving

• I have a track record of exceeding customer satisfaction goals

• I am proficient in using CRM software to manage customer interactions

Yes, I am comfortable with night shifts as I have prior experience working in such shifts.

• I have previous experience working night shifts in my previous job.

• I am a night owl and feel more productive during night hours.

• I am willing to adjust my schedule to accommodate night shifts.

• I understand the importance of providing customer support round the clock.

• I am aware of the challenges of working night shifts and am prepare