SG Analytics Data Engineer Interview Questions and Answers

Round duration - 45 Minutes
Round difficulty - Medium

Q1. 
Find the Second Largest Element
Given an array or list of integers 'ARR', identify the second largest element in 'ARR'.
If a second largest element does not exist, return -1.
Example:
Input:
ARR = [2,...read more
Ans. 
Find the second largest element in an array of integers.
• Iterate through the array to find the largest and second largest elements.

• Handle cases where all elements are identical.

• Return -1 if a second largest element does not exist.
Answered by AI
Add your answer

Round duration - 20 Minutes
Round difficulty - Easy

It was a data set and my task was to find oit the different types of sales trend weekly, monthly, city wise and gender wise.

Q1. It was technical interview related to different types of tools and trchnology related, like differnt types of questions relatedcto ml, python, tableau, powerbi, excel and many more
Add your answer

Q1. It was another technical interview based on project and mid level tools and tecjnology related discussion
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Why should we hire you?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. How can you explain your work experience and describe how you can contribute to the organization?
Ans. 
I have extensive experience in analyzing data to provide valuable insights and drive decision-making. I can contribute by leveraging my skills to improve processes and optimize performance.
• I have worked with various data analysis tools and techniques to extract, clean, and analyze data sets.

• I have experience in creating visualizations and reports to communicate findings to stakeholders.

• I have a track record of identify...read more
Answered by AI
Add your answer

Q1. Self introduction
Add your answer
Q2. Knowledge of data handling
Add your answer

Critical question in maths

General topic about current situation

Q1. About ourselves and resume
Add your answer

Easy to intermediate level questions

Q1. 1.Basic sql commands. 2. Basic to advance excel. 3.how was your past experience with company.
Add your answer
Q2. 4.why you left the previous organization?
Ans. 
Seeking new challenges and growth opportunities.
• Looking for a more challenging role to enhance my skills.

• Seeking career growth and advancement.

• Wanted to explore new industries and gain diverse experience.

• Company restructuring led to a change in job responsibilities.

• Relocated to a different city or country.

• Personal reasons or family commitments.

• Better work-life balance.

• Unfavorable work environment or culture.
Answered by AI
Add your answer

Prepare the assignment in attractive manner and maintain the flow

Q1. Learn the basic concepts and explain your project in detailed manner
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Why are you looking for a change?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. SQL questions mostly around CTE
Add your answer