Meghmani Dyes and Intermediates Project Executive 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. Agile Related Questions
Add your answer
Q2. Scenario based questions
Add your answer

Q1. Managerial questions
Add your answer
Q2. Past project interview questions
Add your answer

Q1. Tell me about your current project architecture
Add your answer
Q2. How do you review codes
Ans. 
I review codes by conducting code reviews, using tools for static code analysis, and ensuring adherence to coding standards.
• Conduct regular code reviews with team members to identify bugs, improve code quality, and share knowledge

• Utilize tools like SonarQube or Checkmarx for static code analysis to identify potential issues

• Ensure that coding standards and best practices are followed in the codebase

• Provide constructive ...read more
Answered by AI
Add your answer

Q1. How do you make the communication efficient between modules
Ans. 
Efficient communication between modules can be achieved through clear documentation, regular meetings, use of communication tools, and establishing a communication plan.
• Create clear documentation outlining the interfaces and dependencies between modules

• Hold regular meetings to discuss progress, issues, and updates on each module

• Utilize communication tools such as project management software, messaging apps, and email f...read more
Answered by AI
Add your answer
Q2. How do you balance loads
Ans. 
Balancing loads involves prioritizing tasks, assigning resources efficiently, and adjusting schedules as needed.
• Prioritize tasks based on deadlines and importance

• Assign resources based on skill sets and availability

• Adjust schedules to accommodate changes in workload

• Use project management tools to track progress and allocate resources effectively
Answered by AI
Add your answer

Q1. Project management
Add your answer

Q1. Background experience
Add your answer

Q1. Background experience
Add your answer

Q1. They only ask about experience and project that you have been worked in previous organisations
Add your answer

Q1. What are your current roles and responsibitlies?
Add your answer
Q2. More questions about risk management, risk register, secondary risk and residual risk
Add your answer
Q3. Difficult stakeholder, decision that back fired, challenging project, conflict resolution
Add your answer

Q1. Tell me about yourself, current roles and responsibitlies
Add your answer
Q2. Why do you want to join WF? What do you look forward to?
Add your answer