Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by OSI Digital Team. If you also belong to the team, you can get access from here

OSI Digital Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

OSI Digital Data Engineer Interview Questions and Answers

Updated 28 May 2024

OSI Digital Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 28 May 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. 1. Lead and lag based questions
  • Q2. 2. Coleasce and repartition in spark
  • Ans. 

    Coalesce reduces the number of partitions in a DataFrame, while repartition reshuffles the data across a specified number of partitions in Spark.

    • Coalesce is used to reduce the number of partitions in a DataFrame without shuffling the data

    • Repartition is used to increase or decrease the number of partitions in a DataFrame by shuffling the data across the specified number of partitions

    • Coalesce is more efficient than repar...

  • Answered by AI
  • Q3. 3. Some sql questions

Interview Preparation Tips

Topics to prepare for OSI Digital Data Engineer interview:
  • SQL
  • Spark

Skills evaluated in this interview

Interview questions from similar companies

I applied via Company Website and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Are you updating day by day yourself in technology ?
  • Q2. Yes, means you will definitely placed in technosoft.

Interview Preparation Tips

Interview preparation tips for other job seekers - I had done certification and learn the skill day by day, waiting for the opening in technosoft. I had attended three round of interview, if you have real skill and self confidence you will definitely placed in technosoft global services

I applied via Naukri.com and was interviewed before Sep 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. Do you have knowledge of Hadoop data ware house?
  • Ans. 

    Yes, I have knowledge of Hadoop data warehouse.

    • I have experience in designing and implementing Hadoop-based data warehouses.

    • I am proficient in Hadoop ecosystem technologies such as HDFS, MapReduce, Hive, and Pig.

    • I have worked with large-scale data processing and storage using Hadoop.

    • I am familiar with data warehousing concepts such as ETL, data modeling, and data integration.

    • I have used Hadoop to build data warehouses

  • Answered by AI
  • Q2. SQl questions using joins.
  • Q3. Have you used python scripts in your testing?
  • Ans. 

    Yes, I have used Python scripts extensively in my testing.

    • I have used Python scripts for automated testing of web applications.

    • I have also used Python scripts for unit testing of backend code.

    • Python's unittest module is particularly useful for this purpose.

    • I have also used Python scripts for load testing and performance testing.

    • Python's requests library is very helpful for testing APIs.

    • I have also used Python scripts f

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. What is your current ctc and what is your expected ctc?

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare the SQL for ETL job role and apexon interviews would be a easy one to crack.

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. Difference between Hashtable and hashmap?
  • Ans. 

    Hashtable is synchronized while hashmap is not.

    • Hashtable is thread-safe while hashmap is not.

    • Hashtable does not allow null keys or values while hashmap allows one null key and multiple null values.

    • Hashtable is slower than hashmap due to synchronization.

    • Hashtable is a legacy class while hashmap is a newer implementation.

  • Answered by AI
  • Q2. Difference between hashmap and concurrent hashmap?
  • Ans. 

    Hashmap is not thread-safe while Concurrent Hashmap is thread-safe.

    • Hashmap is not suitable for multi-threaded environments as it can lead to race conditions and data inconsistencies.

    • Concurrent Hashmap allows multiple threads to access and modify the map concurrently without any data inconsistencies.

    • Concurrent Hashmap uses a technique called lock striping to achieve thread-safety.

    • Concurrent Hashmap is slower than Hashma...

  • Answered by AI
  • Q3. Jdbc step
  • Q4. Spring ioc

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was average they asked questions from core java spring hibernate... And so on..

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Apr 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic python list tuples set dictionary related questions
  • Q2. Decorators generator and django rest framework

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on logical and basic python fundamental

I applied via Campus Placement and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Dsa java oops dbms networking

Interview Preparation Tips

Interview preparation tips for other job seekers - Good interview experience.
You have to be very strong in DSA.

Interview Questionnaire 

1 Question

  • Q1. Basic javascript questions , clouser, promise

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepared well on basic of javascript

I applied via Naukri.com and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basic questions on javascript, angular, html,css
  • Q2. Questions on localstorage , tokens, security, interceptors

Interview Preparation Tips

Interview preparation tips for other job seekers - be confident and u will rock

I applied via LinkedIn and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basics Of JS

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 6 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops concepts with examples, SQL query to find second highest salary, diff between fail fast and fail safe, how did u implement security in your app, etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basic Java concepts

OSI Digital Interview FAQs

How many rounds are there in OSI Digital Data Engineer interview?
OSI Digital interview process usually has 1 rounds. The most common rounds in the OSI Digital interview process are Technical.
What are the top questions asked in OSI Digital Data Engineer interview?

Some of the top questions asked at the OSI Digital Data Engineer interview -

  1. 2. Coleasce and repartition in sp...read more
  2. 1. Lead and lag based questi...read more
  3. 3. Some sql questi...read more

Tell us how to improve this page.

OSI Digital Data Engineer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
OSI Digital Data Engineer Salary
based on 4 salaries
₹3.4 L/yr - ₹7.5 L/yr
53% less than the average Data Engineer Salary in India
View more details
Software Engineer
166 salaries
unlock blur

₹3.3 L/yr - ₹13 L/yr

Senior Software Engineer
161 salaries
unlock blur

₹6.2 L/yr - ₹23 L/yr

Associate Software Engineer
130 salaries
unlock blur

₹3 L/yr - ₹7.5 L/yr

Associate Technical Leader
57 salaries
unlock blur

₹10 L/yr - ₹24 L/yr

System Engineer
49 salaries
unlock blur

₹3.3 L/yr - ₹10 L/yr

Explore more salaries
Compare OSI Digital with

Xoriant

4.1
Compare

Photon Interactive

4.1
Compare

CitiusTech

3.3
Compare

Iris Software

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