Add office photos
Filter interviews by
Datsy Associate Data Engineer Interview Questions and Answers
Datsy Associate Data Engineer Interview Experiences
1 interview found
Anonymous
Some basic aptidude questions easy to solve.
(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.
- 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
(1 Question)
- Q1. In this round they ask about ML & it's Algorithms, Data Science concepts,,,ect
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
Selected
I applied via campus placement at RC Patel College of Education, Shirpur and was interviewed in Oct 2024. There were 3 interview rounds.
There are some general aptitude questions.
There were two simple codes from which we need to pass the test case for at least one code
(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...
- 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
I applied via Company Website
Prepare verval, LRDI, Quant moderate like using RS agarwal best book for prepare aptitude
Practice pseudo code minmum 100 pseudo code and for coding using code chef platform best for preparation
(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 ?
(1 Question)
- Q1. How to manage tram conflict ?
Interview Preparation Tips
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.
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.
(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
- 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.
- 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
- 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
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
- 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...
- 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.
- 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
Skills evaluated in this interview
akshaya rani
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
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 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 ...
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.
- 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
- 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
- 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.
Interview Preparation Tips
Skills evaluated in this interview
Datsy Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Scientist Interview Questions
- Associate Data Analyst Interview Questions
- Data Associate Interview Questions
- Senior Data Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Datsy Associate Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Technology Trainee
6
salaries
|  ₹1.2 L/yr - ₹3.5 L/yr |
|
Associate Data Engineer
4
salaries
| ₹2.1 L/yr - ₹3 L/yr |
|
Data Engineer
4
salaries
| ₹2 L/yr - ₹4.8 L/yr |
TCS
Accenture
Wipro
Cognizant
Calculate your in-hand salary
- Home >
- Interviews >
- Datsy Interview Questions >
- Datsy Associate Data Engineer Interview Questions
