Upload Button Icon Add office photos

Filter interviews by

Datsy Associate Data Engineer Interview Questions and Answers

Updated 2 Mar 2022

Datsy Associate Data Engineer Interview Experiences

1 interview found

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 - Aptitude Test 

Some basic aptidude questions easy to solve.

Round 3 - Technical 

(3 Questions)

  • Q1. In this round they ask all technical things regarding phyton.
  • Q2. What is constructor?
  • Ans. 

    A constructor is a special method that is used to initialize objects in a class.

    • Constructors have the same name as the class they belong to.

    • They are called automatically when an object is created.

    • They can take parameters to initialize the object's properties.

    • If a class does not have a constructor, a default constructor is created.

    • Constructors can be overloaded to provide multiple ways to initialize objects.

  • Answered by AI
  • Q3. Types of Methods in python?
  • Ans. 

    Python has two types of methods: built-in methods and user-defined methods.

    • Built-in methods are pre-defined methods in Python, such as print() and len().

    • User-defined methods are created by the programmer to perform specific tasks.

    • Methods can be called on objects, such as strings or lists, using dot notation.

    • Methods can also take arguments, which are passed in parentheses after the method name.

    • Methods can return values

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. In this round they ask about ML & it's Algorithms, Data Science concepts,,,ect

Interview Preparation Tips

Interview preparation tips for other job seekers - It will quite easier, just go through with your knowledge and skills, definitely will get job. Thank you.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via campus placement at RC Patel College of Education, Shirpur and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

There are some general aptitude questions.

Round 2 - Coding Test 

There were two simple codes from which we need to pass the test case for at least one code

Round 3 - HR 

(3 Questions)

  • Q1. Tell me about your project
  • Q2. What was the difficut subject in college
  • Ans. 

    The most difficult subject in college was Advanced Calculus.

    • Advanced Calculus involved complex mathematical concepts and required a deep understanding of calculus principles.

    • The subject required a lot of practice and problem-solving skills to master the concepts.

    • Topics such as multivariable calculus, differential equations, and vector calculus were particularly challenging.

    • The abstract nature of the subject made it dif...

  • Answered by AI
  • Q3. Tell me about yourself
  • Ans. 

    I am a recent graduate with a degree in Computer Science and a passion for data engineering.

    • Graduated with a degree in Computer Science

    • Strong interest in data engineering

    • Completed internships in data analysis and database management

  • Answered by AI

I applied via Company Website

Round 1 - Aptitude Test 

Prepare verval, LRDI, Quant moderate like using RS agarwal best book for prepare aptitude

Round 2 - Coding Test 

Practice pseudo code minmum 100 pseudo code and for coding using code chef platform best for preparation

Round 3 - Technical 

(1 Question)

  • Q1. 1.What programing language i know rate yourself ? 2.Oops concept and explaine . 3.Which project i had completed in my final year ? 4.What my responsibility in project ?
Round 4 - HR 

(1 Question)

  • Q1. How to manage tram conflict ?

Interview Preparation Tips

Interview preparation tips for other job seekers - 1.Firstly focus on aptitude test and prepare hardly 2 months for varc,lrdi,quant after that focus on coding and interview round .
2. Learn any one language according to which one easy for you .
3. Go throw youtube videos interviews questions what type of questions interviewer ask.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Tell me about yourself
  • Q2. Explain about your recent project
  • Q3. Oops concepts question

Interview Questionnaire 

5 Questions

  • Q1. How to find 3rd Highest salary in Sql.
  • Q2. How to delete duplicate rows in Sql
  • Ans. 

    Deleting duplicate rows in SQL

    • Use the DISTINCT keyword in SELECT statement to retrieve unique rows

    • Use GROUP BY clause to group rows with same values and then use aggregate functions to select one row

    • Use the ROW_NUMBER() function to assign a unique number to each row and then delete the rows with duplicate numbers

  • Answered by AI
  • Q3. Datastge - How will you remove Header and trailer from Sequential data file
  • Ans. 

    To remove header and trailer from a sequential data file in Datastage.

    • Use Sequential File stage in Datastage.

    • Set the 'Skip Rows' property to the number of header rows to be skipped.

    • Set the 'Trailer Rows' property to the number of trailer rows to be skipped.

    • Use a Transformer stage to remove any remaining header or trailer rows.

    • Use the 'Remove' function in the Transformer stage to remove the rows.

  • Answered by AI
  • Q4. How would you kill any job in Datastage
  • Ans. 

    To kill a job in Datastage

    • Stop the job manually from the Director client

    • Terminate the job from the command line using the dsjob command

    • Kill the job process from the operating system level

    • Delete the job from the Datastage repository

  • Answered by AI
  • Q5. How to find process id in linux
  • Ans. 

    To find process id in Linux, use the command 'ps -aux | grep '

    • Open the terminal

    • Type 'ps -aux' to list all running processes

    • Use 'grep ' to filter the process you are looking for

    • The process id (PID) will be listed in the second column

Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

6 Questions

  • Q1. Basics of HIVE AND SPARK
  • Q2. SQL QUERIES WITH WINDOW FUNCTION
  • Ans. 

    SQL queries with window functions

    • Window functions perform calculations across a set of rows that are related to the current row

    • Common window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE

    • Window functions are used with the OVER() clause to define the window or subset of rows to perform the calculation on

  • Answered by AI
  • Q3. SORT BY ORDER BY CLUSTER BY DISTRIBUTE BY
  • Ans. 

    SORT BY, ORDER BY, CLUSTER BY, and DISTRIBUTE BY are SQL clauses used for data sorting and partitioning.

    • SORT BY is used to sort the result set in ascending or descending order based on one or more columns.

    • ORDER BY is used to sort the result set in ascending or descending order based on one or more columns. It is similar to SORT BY but can be used with other clauses like LIMIT and OFFSET.

    • CLUSTER BY is used to group data...

  • Answered by AI
  • Q4. SPARK OOM ISSUE
  • Q5. SMALL FILE PROBLEM
  • Ans. 

    Small file problem refers to the issue of having a large number of small files in a storage system.

    • Small files can cause inefficiencies in storage and processing.

    • Solutions include consolidating small files into larger ones or using a different storage system.

    • Examples include Hadoop's SequenceFile format and Amazon S3's object size optimization.

  • Answered by AI
  • Q6. RDS VA DF VS DS
  • Ans. 

    RDS, VA, DF, VS, and DS are all acronyms related to data engineering.

    • RDS stands for Relational Database Service, a managed database service by AWS.

    • VA stands for Virtual Assistant, a software program that can assist with tasks.

    • DF stands for Dataflow, a managed service by Google Cloud for data processing.

    • VS stands for Virtual Server, a server that runs on a virtual machine.

    • DS stands for Datastore, a NoSQL document databa

  • Answered by AI

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Sep 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Azure activities
  • Q2. Project experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Basics of azure must be very clear also scenario based questions.

I applied via Recruitment Consultant and was interviewed in Feb 2021. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. #3 interviews were there 1. Basic Telephonic all basic questions were there then 2. zoom video for detaled code and sql queries 3. advanced for algo designing and case analysis questions.All related to had...
  • Q2. Basic question and coding is answered as per knowledge and experience. Advance questions is totally based on aptitude . reasonng and decision making skills
  • Q3. Why TechMahindra guys conduct interviews if after selecting all technical round they dnt have any offer to give. And make it as hold.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please discuss frankly to HR after selecting in all interview round will i get the offer with expected salary or just it will hold to infinite time.

Interview Questionnaire 

1 Question

  • Q1. How would you recommend customer to migrate on cloud
  • Ans. 

    To recommend customers to migrate to the cloud, assess their current infrastructure, plan the migration strategy, choose the right cloud provider, and ensure data security.

    • Assess the customer's current infrastructure and identify the applications and data that can be migrated to the cloud.

    • Plan the migration strategy by considering factors like cost, time, and resource requirements.

    • Choose the right cloud provider based ...

  • Answered by AI

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. Reading Data from a .log file and finding out each column with a specific regex.
  • Ans. 

    Reading data from a .log file and extracting columns with a specific regex.

    • Use Python's built-in 're' module to define the regex pattern.

    • Open the .log file using Python's 'open' function.

    • Iterate through each line of the file and extract the desired columns using the regex pattern.

    • Store the extracted data in a data structure such as a list or dictionary.

  • Answered by AI
  • Q2. Asked to find count and profit from the data for last 4 years
  • Q3. Optimizations I can use
  • Ans. 

    Optimizations for data engineering

    • Use indexing to speed up queries

    • Partition data to improve query performance

    • Use caching to reduce data retrieval time

    • Optimize data storage format for faster processing

    • Use parallel processing to speed up data processing

    • Optimize network bandwidth usage

    • Use compression to reduce storage and network usage

  • Answered by AI
  • Q4. Python JSON reading
  • Ans. 

    Answering how to read JSON in Python.

    • Use the json module to load and parse JSON data

    • Use the json.loads() method to load JSON data from a string

    • Use the json.load() method to load JSON data from a file

    • Access JSON data using keys or indexes

    • Use the json.dumps() method to convert Python objects to JSON strings

  • Answered by AI
  • Q5. Array, List - Python scenarios
  • Q6. Pyspark configs
  • Ans. 

    Pyspark configs

    • Pyspark configs are used to configure the behavior of a Pyspark application.

    • They can be set using SparkConf object or spark-submit command.

    • Examples include setting the number of executors, memory allocation, and log level.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Very easy if you have prev work exp.

Skills evaluated in this interview

Datsy Interview FAQs

How many rounds are there in Datsy Associate Data Engineer interview?
Datsy interview process usually has 4 rounds. The most common rounds in the Datsy interview process are Technical, Resume Shortlist and Aptitude Test.
What are the top questions asked in Datsy Associate Data Engineer interview?

Some of the top questions asked at the Datsy Associate Data Engineer interview -

  1. What is construct...read more
  2. Types of Methods in pyth...read more
  3. In this round they ask about ML & it's Algorithms, Data Science concepts,,,...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Accenture Interview Questions
3.9
 • 7.9k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.4k Interviews
Amazon Interview Questions
4.1
 • 4.9k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.6
 • 3.6k Interviews
Genpact Interview Questions
3.9
 • 2.9k Interviews
View all
Datsy Associate Data Engineer Salary
based on 4 salaries
₹2.1 L/yr - ₹3 L/yr
70% less than the average Associate Data Engineer Salary in India
View more details

Datsy Associate Data Engineer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-Life balance

5.0

Salary & Benefits

5.0

Job Security

5.0

Company culture

5.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Technology Trainee
6 salaries
unlock blur

₹1.2 L/yr - ₹3.5 L/yr

Associate Data Engineer
4 salaries
unlock blur

₹2.1 L/yr - ₹3 L/yr

Data Engineer
4 salaries
unlock blur

₹2 L/yr - ₹4.8 L/yr

Explore more salaries
Compare Datsy with

TCS

3.7
Compare

Accenture

3.9
Compare

Wipro

3.7
Compare

Cognizant

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview