Geovista Technologies Interview Questions and Answers

A standardized assessment that measures a person's skills, cognitive abilities, and potential to perform in a specific role.

Q1. Technical interview questions at Automatic Data Processing (ADP) may cover topics such as programming, databases, and software development.
Add your answer
Q2. They may also ask about problem-solving and how you approach challenging tasks.
Add your answer
Q3. Emphasize a structured method that involves clearly defining the issue, gathering relevant information, brainstorming potential solutions, evaluating options carefully, implementing the chosen solution, an...read more
Add your answer
Q4. Data structures, algorithms, SQL querying, object-oriented programming principles, software development lifecycle, database concepts (relational vs. NoSQL), coding challenges in relevant languages (like Py...read more
Add your answer

Q1. May ask about your background, skills, and how you handle challenges
Add your answer
Q2. Background questions Tell me about yourself, What are your career goals, What are your strengths and weaknesses, What do you know about ADP, and Why do you want to work at ADP.
Add your answer

It occurred on HackerRank.

Q1. DSA questions related to strings , graphs , array
Add your answer
Q2. CS fundamentals ....OOPS , DBMS , CN (little)
Add your answer
Q3. Projects discussion
Add your answer

Q1. About hobbies , interest in comp. about hacakthons
Add your answer
Q2. Why i want to become SDE
Add your answer

Basic self evaluation test.

Q1. What project I have completed and follow-up questions on that?
Add your answer
Q2. How to handle class imbalance.
Ans. 
Handling class imbalance involves techniques like resampling, using different algorithms, and adjusting class weights.
• Use resampling techniques like oversampling or undersampling to balance the classes.

• Utilize algorithms that are robust to class imbalance, such as Random Forest, XGBoost, or SVM.

• Adjust class weights in the model to give more importance to minority class.

• Use evaluation metrics like F1 score, precision, r...read more
Answered by AI
Add your answer
Q3. Basic Python coding questions.
Add your answer

Q1. Data-related questions.
Add your answer
Q2. ML Ops questions.
Add your answer

Q1. PLM configurations and SAP systems landscapes
Add your answer

Q1. What types of problem-solving skill test questions are typically asked in a managerial round?
Add your answer

Q1. Why have you chosen to pursue a career in SAP, and what does that career path look like to you?
Add your answer

Q1. What is difference between rank and dense rank?
Add your answer
Q2. What is RLS in Power Bi?
Add your answer

Q1. How would you identify time for any project?
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Arrays and strings - 90 mins

Create Modules, railway reservation system - 60 mins

Q1. Difference between hashmap and hasptable
Add your answer
Q2. Why typescript over javascript
Add your answer
Q3. Find the percentage of increace in the quantity of item after making it price 20% extra
Add your answer
Q4. What is normalization
Add your answer
Q5. Date and time api available
Add your answer