Ellison Oilfield Services Interview Questions and Answers

Depending on the role which U applied 2 or
3 rounds of online test will come

Q1. This is the final interview with HR and after If U selected they will contact via mail
Add your answer
Q2. Self introduction
Add your answer
Q3. Project Explanation mentioned in the resume
Add your answer
Q4. Additionally depending on the Interviewer/HR some may ask hypthothetical questions
Add your answer

Q1. Could you elaborate on your roles and responsibilities in your previous employment?
Add your answer
Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
Add your answer
Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
Add your answer
Q4. Guesstimates like how many traffic signals are there in Noida.
Add your answer
Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Add your answer

Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...read more
Add your answer

Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Add your answer

Q1. Final round will be an HR round.
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Techincal questions
Add your answer

General knowlege and communication

Q1. Walk me through your resume
Add your answer
Q2. Why to choose this job
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Technical question
Add your answer

Basic quant and reasoning questions
Selenium MCQ
Java programs with MCQ

Q1. Tell me about yourself
Add your answer
Q2. Where you initialise driver
Ans. 
The driver is typically initialized in the setup method of a test automation framework.
• Driver initialization is usually done in a setup method before test execution.

• Commonly used methods for driver initialization include WebDriverManager, System.setProperty, and driver instantiation.

• Example: WebDriverManager.chromedriver().setup();
Answered by AI
Add your answer
Q3. Driver is static or non static
Ans. 
Driver can be both static and non-static depending on the context of its usage.
• Driver class can be static if it is used to initiate the WebDriver instance in a test automation framework.

• Driver class can be non-static if it is used as an instance variable within a test class.

• Static driver can be accessed directly without creating an object of the class.

• Non-static driver requires an object of the class to be created befo
Answered by AI
Add your answer
Q4. Difference between static and non static
Ans. 
Static variables belong to the class itself, while non-static variables belong to instances of the class.
• Static variables are shared among all instances of a class

• Non-static variables are unique to each instance of a class

• Static variables are initialized only once, at the start of the program

• Non-static variables are initialized separately for each instance of the class
Answered by AI
Add your answer
Q5. Disadvantages of static and non static
Ans. 
Static and non-static have their own disadvantages in QA automation testing.
• Static methods cannot be overridden or inherited, making it difficult to create flexible test cases.

• Non-static methods require an instance of the class to be created, which can lead to increased memory usage.

• Static methods can lead to tight coupling between classes, making it harder to maintain and update the code.

• Non-static methods may have de...read more
Answered by AI
Add your answer
Q6. Parallel execution in TestNG
Ans. 
TestNG allows parallel execution of test cases to save time and improve efficiency.
• TestNG provides the 'parallel' attribute in the testng.xml file to specify the level of parallelism for test execution.

• Parallel execution can be achieved at the test level, class level, method level, or suite level.

• TestNG also supports parallel execution of tests across multiple classes or suites using the 'parallel' attribute in the sui...read more
Answered by AI
Add your answer
Q7. Write the code for Parallel testing in TestNG
Ans. 
Parallel testing in TestNG allows running tests concurrently for faster execution.
• Use 'parallel' attribute in testng.xml file to specify parallel execution mode.

• Set 'parallel' attribute to 'methods', 'classes', or 'tests' based on the level of parallelism needed.

• Example: <suite name='MySuite' parallel='tests'>

• Use 'thread-count' attribute to specify the number of threads to use for parallel execution.
Answered by AI
Add your answer
Q8. Difference between parallel methods and parallel tests
Ans. 
Parallel methods run multiple methods concurrently within a single test, while parallel tests run multiple tests concurrently.
• Parallel methods execute multiple methods within a single test class concurrently.

• Parallel tests execute multiple test classes concurrently.

• Parallel methods are useful for speeding up the execution of a single test, while parallel tests are useful for running multiple tests faster.

• Example: Runni...read more
Answered by AI
Add your answer
Q9. Upload file using rest assured
Ans. 
Use Rest Assured to upload a file
• Use the given file path to create a File object

• Use MultiPartSpecBuilder to build the request with the file

• Send the request using Rest Assured's given(), when(), and post() methods
Answered by AI
Add your answer
Q10. Postman basic questions
Add your answer
Q11. Parameter for post method in postman
Ans. 
The parameter for a POST method in Postman is typically sent in the request body.
• Parameters are sent in the request body in key-value pairs

• Parameters can be sent as form-data, x-www-form-urlencoded, or raw JSON

• Example: {"key": "value"}
Answered by AI
Add your answer
Q12. BDD Framework cucumber
Add your answer
Q13. Cucumber execution process
Add your answer
Q14. How cucumber know step defination file placed
Ans. 
Cucumber knows the step definition file based on the annotations provided in the feature files.
• Cucumber uses annotations like @Given, @When, @Then to map steps in feature files to corresponding step definition methods.

• Step definition files are typically placed in a separate package or directory within the project structure.

• Cucumber scans the project directory for step definition files based on the package structure and
Answered by AI
Add your answer
Q15. Parameters used in cucumber
Ans. 
Parameters used in cucumber are used to pass values to the step definitions in feature files.
• Parameters are defined in feature files using < > syntax

• Parameters can be passed to step definitions using Regular Expressions

• Parameters can be used to make scenarios more reusable and dynamic
Answered by AI
Add your answer
Q16. Datatable in cucumber
Ans. 
Datatable in Cucumber is used to pass multiple sets of data to a step definition in a scenario.
• Datatables are defined using pipes (|) to separate values

• Each row in the datatable represents a set of data passed to the step definition

• Datatables can be used for parameterization and data-driven testing
Answered by AI
Add your answer
Q17. Have u created the testplan document when porject was started
Ans. 
Yes, I have created the test plan document at the start of the project.
• Yes, I always create a test plan document at the beginning of a project to outline the testing approach and strategy.

• The test plan document includes details on scope, objectives, resources, schedule, and test cases.

• It helps in ensuring that all stakeholders are aligned on the testing process and expectations.

• For example, in my previous project, I cr...read more
Answered by AI
Add your answer
Q18. Testing cycle when project was on initial level
Ans. 
During the initial testing cycle of a project, focus is on establishing test cases, setting up test environments, and identifying potential issues.
• Creating test cases based on requirements

• Setting up test environments

• Identifying potential issues and risks

• Executing test cases and reporting defects

• Collaborating with developers to resolve issues
Answered by AI
Add your answer
Q19. Risk management and risk based testing
Add your answer
Q20. Which estimate technique you follow , if fibonacci then why it is in 1 2 3 5 8 13 ?? Not in 12345678
Ans. 
Fibonacci sequence is a mathematical pattern where each number is the sum of the two preceding ones.
• Fibonacci sequence is a series of numbers where each number is the sum of the two preceding ones.

• The sequence starts with 1, 2, then each subsequent number is the sum of the two previous numbers (1+2=3, 2+3=5, 3+5=8, and so on).

• This sequence is used in estimating because it reflects natural growth patterns found in natur
Answered by AI
Add your answer
Q21. What is testing matrix and automation ROI
Ans. 
Testing matrix is a tool used to track test coverage and automation ROI is the return on investment from implementing automation testing.
• Testing matrix is a visual representation of test cases, test scenarios, and their coverage across different platforms, browsers, devices, etc.

• Automation ROI is the measure of the benefits gained from automation testing compared to the costs incurred in implementing and maintaining th...read more
Answered by AI
Add your answer
Q22. Cicd tool
Add your answer
Q23. Handle team ?
Add your answer

Q1. My family details
Add your answer
Q2. My home location
Add your answer
Q3. Present time working this job
Add your answer
Q4. What are this work titles
Add your answer
Q5. What are my company post
Add your answer

Q1. I have 4.6 years experience, 2 years supervisor, middle mail experience in flipkart, 1 year fast mile zepto shift incharge, 8 months FRN, Large flipkart, blue colour. Current time working zepto shift incha...read more
Add your answer
Q2. Do you need employees like us?
Ans. 
Yes, we are always looking for talented and dedicated employees to join our team.
• We are constantly seeking individuals with the right skills and experience to contribute to our organization.

• Having employees like you who are motivated and passionate about their work is essential for our success.

• We value diversity and are committed to creating a supportive and inclusive work environment.

• Examples: We are currently hiring ...read more
Answered by AI
Add your answer
Q3. I have 4.6 years of experience, do you need it?
Ans. 
Yes, your 4.6 years of experience is relevant to the position.
• Your experience can bring valuable skills and knowledge to the role.

• Highlight specific achievements or projects from your 4.6 years of experience.

• Demonstrate how your experience aligns with the requirements of the position.

• Emphasize how your experience can contribute to the success of the team or organization.
Answered by AI
Add your answer
Q4. I pass fast mail and middle mile and last mail rider tema handlein team worki experience do you need it
Add your answer

Q1. What is the architecture of the Java Virtual Machine (JVM)?
Ans. 
The Java Virtual Machine (JVM) is an abstract computing machine that enables a computer to run Java programs.
• JVM is platform-independent and converts Java bytecode into machine code.

• It consists of class loader, runtime data areas, execution engine, and native method interface.

• JVM memory is divided into method area, heap, stack, and PC register.

• Examples of JVM implementations include Oracle HotSpot, OpenJ9, and GraalVM.
Answered by AI
Add your answer
Q2. What is the default connection pooling in Spring Boot, and how can it be customized?
Ans. 
The default connection pooling in Spring Boot is HikariCP, which can be customized through properties in the application.properties file.
• HikariCP is the default connection pooling library in Spring Boot, known for its high performance and low overhead.

• To customize the connection pooling, you can modify properties like 'spring.datasource.hikari.*' in the application.properties file.

• For example, you can set maximum pool ...read more
Answered by AI
Add your answer
Q3. What are the best practices for optimizing a Spring Boot application?
Ans. 
Best practices for optimizing a Spring Boot application
• Use Spring Boot Actuator to monitor and manage application performance

• Implement caching mechanisms like Spring Cache to reduce database calls

• Optimize database queries and indexes for better performance

• Use asynchronous processing with Spring's @Async annotation for non-blocking operations

• Profile and analyze application performance using tools like VisualVM or JProfi
Answered by AI
Add your answer
Q4. What is a heap dump, and how can it be used to identify memory leaks?
Ans. 
A heap dump is a snapshot of the memory usage of a Java application at a specific point in time.
• Heap dumps can be generated using tools like jmap or VisualVM.

• They provide detailed information about objects in memory, their sizes, and references.

• Analyzing a heap dump can help identify memory leaks by pinpointing objects that are consuming excessive memory.

• Common signs of memory leaks in a heap dump include a large numbe...read more
Answered by AI
Add your answer
Q5. How can you diagonally iterate through and print the elements of a 2D array?program
Ans. 
Diagonally iterate through and print elements of a 2D array of strings.
• Use nested loops to iterate through rows and columns of the 2D array.

• Calculate the diagonal elements by incrementing row and column indices together.

• Print the elements as you iterate through the diagonal of the array.
Answered by AI
Add your answer

A technical interview that evaluates a candidate's programming abilities.

Evaluate a candidate's skills and abilities in areas such as logical reasoning, problem-solving, and verbal communication.

Q1. What programming languages are you proficient in?
Add your answer
Q2. What is your area of expertise?
Add your answer
Q3. Artificial intelligence
Add your answer

Current affairs, business matters, and abstract subjects.

Q1. Can you provide a brief overview of your background and experience
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer

Group discussion is a very important tool in addressing various problems.

Q1. What is the count of different types of vernier calipers?
Add your answer
Q2. What is the count of measurements in micrometers?
Add your answer
Q3. QQC Information About the world
Add your answer

Q1. What the Quality
Add your answer
Q2. What are the steps involved in Quality Control (QQC)?
Add your answer