Upload Button Icon Add office photos

Filter interviews by

Open Access Technology India Software Engineer Interview Questions and Answers

Updated 3 Jun 2021

Open Access Technology India Software Engineer Interview Experiences

1 interview found

Interview Questionnaire 

1 Question

  • Q1. Types of partitioning in hive, bucketing in hive, hoq to dedup data, what RDDs and dataframes, difference between spark session and context, prwtty json format
  • Ans. 

    Answering questions related to Hive, Spark, and JSON format.

    • Types of partitioning in Hive: static and dynamic

    • Bucketing in Hive: used for efficient sampling and joins

    • Deduplication in Hive: using DISTINCT keyword or GROUP BY clause

    • RDDs and DataFrames: both are distributed collections in Spark, but DataFrames have a schema

    • Difference between Spark Session and Context: Session is a higher-level API that includes Context

    • Pret...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Coding Test 

90 min MCQ +coding test on hackerrank.

Round 2 - Technical 

(2 Questions)

  • Q1. Sort colors DSA question
  • Q2. Detect cycle in a linked list
  • Ans. 

    Use Floyd's Tortoise and Hare algorithm to detect cycle in a linked list.

    • Initialize two pointers, slow and fast, at the head of the linked list.

    • Move slow pointer by one step and fast pointer by two steps.

    • If they meet at some point, there is a cycle in the linked list.

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Was asked about why you want to join the company,my experience etc.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Oops concept ? SQL Queries ?
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in May 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

About front end , html, css, reasoning,

Round 2 - Technical 

(1 Question)

  • Q1. What.is let , var, const
Round 3 - Technical 

(2 Questions)

  • Q1. What is angular
  • Q2. Services in angular
Round 4 - HR 

(1 Question)

  • Q1. Communication skills.

Interview Preparation Tips

Interview preparation tips for other job seekers - Good for freshers
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is angular
  • Ans. 

    Angular is a popular open-source front-end web application framework developed by Google.

    • Angular is used for building dynamic web applications.

    • It allows for the creation of single-page applications.

    • Angular uses TypeScript for building applications.

    • It provides features like data binding, dependency injection, and routing.

    • Angular has a large community and ecosystem with many libraries and tools available.

  • Answered by AI
  • Q2. What is an angular
  • Ans. 

    Angular is a popular open-source web application framework developed by Google.

    • Angular is used for building dynamic web applications.

    • It allows for the creation of single-page applications.

    • Angular uses TypeScript for building applications.

    • It provides features like data binding, dependency injection, and routing.

    • Angular has a large community and ecosystem with many libraries and tools available.

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Very easy question to medium level qustions

Round 2 - Coding Test 

Easy to medium level questions

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Lamda experience
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Find repeated nos in arrays
  • Ans. 

    Find repeated numbers in arrays of strings

    • Iterate through each string in the array

    • Convert each string to an array of numbers

    • Use a hash map to track the frequency of each number

    • Identify and return the repeated numbers

  • Answered by AI
Round 2 - Behavioral 

(1 Question)

  • Q1. Current company work, reason for change, etc.

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Case study of last project

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Regarding SQL, PostgreSQL

Tell us how to improve this page.

Open Access Technology India Software Engineer Salary
based on 8 salaries
₹3.2 L/yr - ₹12 L/yr
At par with the average Software Engineer Salary in India
View more details
Software Developer
51 salaries
unlock blur

₹2.4 L/yr - ₹8 L/yr

Senior Software Developer
49 salaries
unlock blur

₹3.1 L/yr - ₹12.6 L/yr

Quality Analyst
36 salaries
unlock blur

₹3 L/yr - ₹7.2 L/yr

Associate Software Developer
28 salaries
unlock blur

₹2.2 L/yr - ₹4.5 L/yr

Business Analyst
26 salaries
unlock blur

₹3.8 L/yr - ₹8.5 L/yr

Explore more salaries
Compare Open Access Technology India with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview