ARCADIS Drainage Engineer Interview Questions and Answers

Q1. Basic for Core java
Add your answer
Q2. Basics of selenium
Add your answer

Q1. More on framework side
Add your answer
Q2. Few question on Manual testing
Add your answer

Q1. Intro about yourself
Ans. 
I am a Senior Engineer with 10+ years of experience in software development, specializing in backend systems and cloud technologies.
• 10+ years of experience in software development

• Specialize in backend systems and cloud technologies

• Strong problem-solving skills

• Experience with large-scale systems

• Proficient in programming languages like Java, Python, and SQL
Answered by AI
Add your answer
Q2. Discussion on Job role
Add your answer

Q1. Basics of Java OOPS
Add your answer

Q1. C++ fundamental
Add your answer
Q2. Reverse linked list
Add your answer

Project Management methods

Q1. Introduction about your pervious project
Add your answer

Q1. Project Management processes
Add your answer

Q1. Write code of palindrome
Ans. 
Code to check if a given string is a palindrome or not.
• Create a function that takes a string as input

• Remove all non-alphanumeric characters and convert to lowercase

• Compare the original string with its reverse to check for palindrome
Answered by AI
Add your answer
Q2. How to pass data in angular from component to component
Ans. 
Data can be passed in Angular from component to component using input properties, output properties, services, and state management libraries like NgRx.
• Use @Input decorator to pass data from parent to child component

• Use @Output decorator to emit events from child to parent component

• Use services to share data between components

• Use state management libraries like NgRx for complex data sharing scenarios
Answered by AI
Add your answer

Q1. Write a program Binary Search?
Ans. 
Binary search is a divide and conquer algorithm that efficiently finds the target value within a sorted array.
• Start by defining the low and high indices of the array.

• Calculate the middle index and compare the target value with the middle element.

• If the target value is less than the middle element, search the left subarray. If greater, search the right subarray.

• Repeat the process until the target value is found or the s
Answered by AI
View 1 more answer
Q2. What isCICD flow?
Ans. 
CI/CD flow stands for Continuous Integration/Continuous Deployment flow, which is a software development practice where code changes are automatically built, tested, and deployed.
• CI/CD flow involves automating the process of integrating code changes into a shared repository, running automated tests, and deploying the changes to production.

• Continuous Integration (CI) focuses on automating the build and testing of code c...read more
Answered by AI
View 1 more answer
Q3. How to handle Enum feature?
Ans. 
Enums are a feature in programming languages that allow you to define a set of named constants.
• Enums can be used to improve code readability by giving meaningful names to values

• Enums can be used in switch statements to handle different cases

• Enums can have associated values or raw values for more flexibility
Answered by AI
Add your answer
Q4. Singleton handles the Syncronized ?
Ans. 
Yes, Singleton handles synchronization by ensuring only one instance of a class is created and providing global access to that instance.
• Singleton pattern restricts the instantiation of a class to one object.

• It provides a global point of access to the instance.

• Synchronization can be implemented in the Singleton pattern to ensure thread safety.

• Example: Singleton pattern is commonly used in database connections to ensure
Answered by AI
Add your answer
Q5. What are external Libraries are used in project?
Ans. 
External libraries are pre-written code that can be imported and used in a project to provide additional functionality.
• External libraries help in reducing development time by providing ready-made solutions for common tasks.

• Examples include React for front-end development, NumPy for scientific computing in Python, and Retrofit for making network calls in Android apps.
Answered by AI
Add your answer

Q1. Basics quotation on informatica
Add your answer
Q2. Basic questions on sql
Add your answer
Q3. Basic questions on oracle
Add your answer

Q1. Basics about big data tools. Use case on Pyspark. How to add the new column and what is AQE benefits and Delta table optimisation tenchiques.
Add your answer
Q2. Basics about Azure resources like ADF, Azure Databricks. Explained the project architecture and sone questions on that.
Add your answer
Q3. Pyspark optimisation techniques explain and write scd type 2 sample code.
Ans. 
Optimisation techniques in Pyspark and sample code for SCD type 2
• Use broadcast variables to reduce data shuffling

• Partition data based on key columns to improve performance

• Use cache() or persist() to avoid recomputing data

• Use coalesce() or repartition() to reduce the number of partitions

• For SCD type 2, use merge() function to update or insert new records

• Example code for SCD type 2: https://github.com/awantik/pyspark-101
Answered by AI
Add your answer

Q1. How huge data your are working? What are toughest problem you faced and resolved it ?
Ans. 
I have worked with huge data sets in the past.
• I have experience working with data sets ranging from a few gigabytes to several terabytes.

• One of the toughest problems I faced was optimizing a query that was taking too long to execute.

• I resolved it by analyzing the query plan and identifying the bottleneck, then optimizing the query accordingly.

• Another challenge I faced was dealing with data inconsistencies, which I reso...read more
Answered by AI
Add your answer
Q2. Explain you project architecture ? Show some sample codes of the same.
Ans. 
Our project architecture follows a microservices approach with containerization using Docker and orchestration with Kubernetes.
• We have divided our application into smaller, independent services that communicate with each other through APIs.

• Each service is containerized using Docker, allowing for easy deployment and scaling.

• We use Kubernetes for orchestration, which automates the deployment, scaling, and management of o...read more
Answered by AI
Add your answer

Q1. Compensation decision and clear your doubts regarding organisation.
Add your answer