ePack Durables Solutions Senior Data Management Analyst Interview Questions and Answers

Q1. Azure Scenario based questions
Add your answer
Q2. Pyspark Coding based questions
Add your answer

Q1. ADF, Databricks related question
Add your answer
Q2. Spark Performance problem and scenarios
Ans. 
Spark performance problems can arise due to inefficient code, data skew, resource constraints, and improper configuration.
• Inefficient code can lead to slow performance, such as using collect() on large datasets.

• Data skew can cause uneven distribution of data across partitions, impacting processing time.

• Resource constraints like insufficient memory or CPU can result in slow Spark jobs.

• Improper configuration settings, su...read more
Answered by AI
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. 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

Q1. Basic Recommendation System Questions
Add your answer
Q2. A B Testing Questions
Add your answer

Q1. Python Lambda Function
Add your answer
Q2. What are pods in Kubernetes
Ans. 
Pods are the smallest deployable units in Kubernetes, consisting of one or more containers.
• Pods are used to run and manage containers in Kubernetes

• Each pod has its own unique IP address within the Kubernetes cluster

• Pods can contain multiple containers that share resources and are scheduled together

• Pods are ephemeral and can be easily created, destroyed, or replicated

• Pods can be managed and scaled using Kubernetes contr
Answered by AI
Add your answer

Data entry is the process of entering, updating, or maintaining information into a computer system, database, or spreadsheet. It's a fundamental part of data management, ensuring that information is accurate, organized, and accessible.

Q1. Windows function of sql?
Ans. 
Windows function in SQL is used to perform calculations across a set of table rows related to the current row.
• Windows functions are used to calculate values based on a specific window or subset of rows within a table.

• They allow for aggregation and ranking functions to be applied to a specific set of rows.

• Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer

Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.

Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
Answered Anonymously
View 1 more answer
Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
Add your answer