Metro Global Continuous Improvement Lead Interview Questions and Answers

Some basic aptitube and reasoning problems were asked. Easily solvable.

They asked multiple choice questions on oracle sql and pl/sql emphasizing more on reading a code block ask output questions. These were of medium hardness.

Q1. They asked what you do on daily basis in your work. What is most complex thing you have implemented and some complex questions on multilevel plsql collection module. It lasted for 1.5 hrs
Add your answer

Q1. Questions regarding Oracle architecture and its component
Add your answer
Q2. Question on live implementation of multilevel collection, bulk collect and record limiting and bulk exception handleing.
Add your answer
Q3. Dml error logging functionality
Ans. 
DML error logging functionality allows for capturing errors during data manipulation language operations.
• DML error logging can be enabled at the table level using the LOG ERRORS clause in DML statements.

• It helps in identifying and resolving data issues without causing the entire transaction to fail.

• Errors are logged in a separate error table, allowing the main operation to continue processing.

• Example: INSERT INTO table...read more
Answered by AI
Add your answer
Q4. Query and join optimization
Add your answer

Q1. Related to salary and what benefits they provide.
Add your answer

Q1. Hadoop basics on computing
Add your answer
Q2. Distribution basics for processing the data
Add your answer

Q1. Architecture of bigdata systems
Ans. 
Bigdata systems architecture involves distributed storage, processing, and analysis of large volumes of data.
• Utilize distributed file systems like HDFS for storage

• Use parallel processing frameworks like Apache Spark or Hadoop for data processing

• Implement data pipelines for ETL processes

• Leverage NoSQL databases like Cassandra or MongoDB for real-time data querying

• Consider data partitioning and replication for fault tole
Answered by AI
Add your answer
Q2. How will the bigdata system distribution for storage andcompute happen
Ans. 
Big data system distribution for storage and compute involves partitioning data across multiple nodes for efficient processing.
• Data is partitioned across multiple nodes to distribute storage and processing load.

• Hadoop Distributed File System (HDFS) is commonly used for storage distribution.

• Apache Spark utilizes a cluster computing framework for distributed computing.

• Data locality is important to minimize data transfer ...read more
Answered by AI
Add your answer

Q1. Tell me about your self
Ans. 
I am a seasoned executive with over 20 years of experience in leading successful teams and driving business growth.
• I have a proven track record of delivering results and exceeding targets

• I am skilled in strategic planning, budgeting, and resource allocation

• I am a strong communicator and collaborator, able to build and maintain relationships with stakeholders at all levels

• I am passionate about developing and mentoring t...read more
Answered by AI
Add your answer
Q2. Why did you leave your previous job
Ans. 
Seeking new challenges and growth opportunities
• Desire for professional development

• Limited growth potential in previous role

• Looking for new challenges and experiences

• Company restructuring resulted in redundancy
Answered by AI
Add your answer
Q3. This salary you will satisfied
Add your answer

Q1. None of above queation
Add your answer
Q2. What do you know about our company's products and service
Ans. 
Your company offers a wide range of products and services to cater to various needs of customers.
• Your company offers products and services in multiple categories such as electronics, home appliances, fashion, and beauty.

• The company has a strong online presence and offers easy and secure online shopping experience to customers.

• The company also provides after-sales services such as repair and maintenance services for its...read more
Answered by AI
Add your answer

Q1. Financial knowledge / stock market basics
Add your answer

Q1. Your goals and your way of thinking
Add your answer

Q1. What are your salary expectations?
Add your answer
Q2. What is your family background?
Add your answer
Q3. Share details of your previous job.
Add your answer
Q4. Why should we hire you?
Add your answer
Q5. Why are you looking for a change?
Add your answer
Q6. What are your strengths and weaknesses?
Add your answer
Q7. Tell me about yourself.
Add your answer

Q1. Stock market related and sales related
Add your answer

A problem on portfolio optimization was given.

Q1. What is p-value and A/B testing
Ans. 
P-value is a statistical measure that helps determine the significance of results in hypothesis testing. A/B testing is a method of comparing two versions of a webpage or app to see which one performs better.
• P-value is the probability of obtaining a result as extreme or more extreme than the observed result, assuming the null hypothesis is true.

• A/B testing involves randomly dividing a sample into two groups and exposin...read more
Answered by AI
Add your answer
Q2. ARMA, ARIMA and stationarity in time series.
Ans. 
ARMA and ARIMA are models used for time series analysis. Stationarity refers to the statistical properties of a time series remaining constant over time.
• ARMA stands for Autoregressive Moving Average model and is used to model stationary time series data.

• ARIMA stands for Autoregressive Integrated Moving Average model and is used to model non-stationary time series data.

• Stationarity is an important concept in time series...read more
Answered by AI
Add your answer