WESCO 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. How would you optimize joins
Add your answer
Q2. What are different Join strategies
Add your answer

Q1. Interviewer asked me basic SQL questions
Add your answer
Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
Add your answer

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Q1. Coding round with mix questions on machine learning
Add your answer
Q2. Computer vision and nlp based questions
Add your answer

Q1. Tel me about your family background
Ans. 
I come from a close-knit family with a diverse background.
• My parents are both immigrants from different countries, which has given me a unique perspective on different cultures.

• I have two siblings, one older and one younger, who have always been supportive of my career choices.

• Family gatherings are always filled with laughter and delicious homemade food.

• My family has always emphasized the importance of education and ha
Answered by AI
Add your answer
Q2. Why do you want to join us
Ans. 
I am excited about the innovative projects and collaborative team at your company.
• I am impressed by the cutting-edge technology and data-driven approach of your company.

• I believe my skills and experience align well with the challenges and opportunities at your company.

• I am eager to work with a talented team and contribute to impactful projects.

• Your company's reputation for fostering a culture of learning and growth is
Answered by AI
Add your answer

Q1. Tell me about your projects?
Add your answer
Q2. How do you approach the project if you are using logistic regression model?
Ans. 
Approach involves data preprocessing, model training, evaluation, and interpretation.
• Perform data preprocessing such as handling missing values, encoding categorical variables, and scaling features.

• Split the data into training and testing sets.

• Train the logistic regression model on the training data.

• Evaluate the model using metrics like accuracy, precision, recall, and F1 score.

• Interpret the model coefficients to under...read more
Answered by AI
Add your answer

Q1. What are you future goals?
Add your answer
Q2. What would you do if your interested field doesnt have any work in the company?
Ans. 
I would seek opportunities to apply my skills in related fields within the company.
• Explore other departments or teams within the company that may have projects related to my field of interest

• Offer to collaborate with colleagues in different departments to bring a new perspective to their projects

• Seek out professional development opportunities to expand my skills and knowledge in related areas
Answered by AI
Add your answer

Coding test with multiple questions around DSA

Q1. Dot net questions
Add your answer
Q2. Oops questions
Add your answer

I was hiring drive. First round was coding test with medium to advanced SQL, data modelling and python questions

Q1. Data model e commerce application
Add your answer
Q2. Higest nth rank and lowest rank if no of employees less than 2
Ans. 
If number of employees is less than 2, highest and lowest rank will be the same.
• If there are less than 2 employees, both highest and lowest rank will be the same.

• For example, if there is only 1 employee, their rank will be 1 which is both the highest and lowest rank.
Answered by AI
Add your answer
Q3. Event session data modeling
Add your answer

Q1. Sql-self join, non equi join, window funtion, consecutive seats, data modeling, stock market maximum profit sql question
Add your answer

Q1. This was hiring manager round. Detailed discussions on project and previous experience
Add your answer

Q1. Strength, weakness and why myntra
Add your answer