Shekar Logistics Data Engineer Interview Questions and Answers

Q1. What joins you used
Ans. 
I have used various types of joins including inner join, left join, right join, and full outer join.
• Used inner join to retrieve records that have matching values in both tables

• Utilized left join to retrieve all records from the left table and matching records from the right table

• Employed right join to retrieve all records from the right table and matching records from the left table

• Utilized full outer join to retrieve ...read more
Answered by AI
Add your answer
Q2. Write query for joins
Ans. 
Query for joins in SQL to combine data from multiple tables
• Use JOIN keyword to combine data from two or more tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Answered by AI
Add your answer

Q1. Some good questions as per the technical requirements
Add your answer

Q1. Typical hr related questions
Add your answer

Q1. Personal quetions
Add your answer
Q2. Professional journey
Add your answer

Q1. What is key features python programming
Ans. 
Key features of Python programming include simplicity, readability, versatility, and extensive libraries.
• Python is known for its simple and readable syntax, making it easy to learn and understand.

• It is a versatile language that can be used for various purposes such as web development, data analysis, and artificial intelligence.

• Python has a vast collection of libraries and frameworks that provide ready-to-use tools for ...read more
Answered by AI
Add your answer
Q2. What is pandas word?
Ans. 
Pandas is a powerful data manipulation library in Python, used for data analysis and data wrangling tasks.
• Pandas is a Python library that provides data structures and functions for efficient data manipulation.

• It is widely used for tasks like data cleaning, transformation, and analysis.

• Pandas offers powerful tools for handling structured data, such as CSV or Excel files.

• It provides functionalities like filtering, sortin...read more
Answered by AI
Add your answer
Q3. Different between seaborn and matplotlib
Ans. 
Seaborn is a high-level interface for statistical data visualization, while Matplotlib is a low-level library for creating basic plots.
• Seaborn provides a more aesthetically pleasing and informative visual representation of data compared to Matplotlib.

• Seaborn has built-in themes and color palettes that make it easier to create visually appealing plots.

• Matplotlib offers more flexibility and control over plot customizatio...read more
Answered by AI
Add your answer

First round is gaming round with 13 levels
And the aptitude with science, technical and non technical questions

Q1. General questions were asked Tell me about yourself And then technical he round with puzzles and aptitude to solve
Add your answer
Q2. Long term and short term goals
Add your answer
Q3. Strength and weakness
Add your answer
Q4. Puzzles and aptitude questions
Add your answer

3 questions in 3 hr, topics were Dp, Strings, Tree

1hr durations 40 questions, main topics were patterns, profit loss, work man , etc.

Q1. OOPS, JAVA, Mysql, general questsjons
Add your answer

Std 1th to 10th basic maths questions,formulas , calculations, etc.

1. Mobile bad effects or good effects.
2. Village Life or city life.

Q1. 1.Tell me about your self ?
Ans. 
I am a detail-oriented and organized individual with experience in data entry. I have strong typing skills and a high level of accuracy.
• Experience in data entry

• Detail-oriented and organized

• Strong typing skills

• High level of accuracy
Answered by AI
View 4 more amswers
Q2. Why do you apply this job?
Ans. 
I am applying for this job because I have strong attention to detail and excellent data entry skills.
• I have a proven track record of accurately entering large amounts of data.

• I am highly organized and can efficiently manage and prioritize tasks.

• I have a keen eye for detail and can spot errors or inconsistencies in data.

• I am proficient in using data entry software and have a fast typing speed.

• I enjoy working with data a...read more
Answered by AI
View 2 more amswers
Q3. What is your strength?
Ans. 
My strength is my attention to detail and accuracy in data entry tasks.
• I have a keen eye for detail and can spot errors or inconsistencies in data.

• I am highly organized and can efficiently manage large volumes of data.

• I have excellent typing speed and accuracy, ensuring minimal mistakes.

• I am proficient in using data entry software and tools.

• I am able to prioritize tasks and meet deadlines in a fast-paced environment.
Answered by AI
View 3 more amswers
Q4. How many year's of experience?
Ans. 
I have 3 years of experience as a Data Entry Operator.
• I have worked as a Data Entry Operator for 3 years.

• I am experienced in accurately entering data into various systems and databases.

• I have a strong attention to detail and can efficiently handle large volumes of data.

• I am proficient in using data entry software and have a good typing speed.

• I have experience in maintaining data confidentiality and ensuring data accura
Answered by AI
View 2 more amswers

Round duration - 60 mins
Round difficulty - Medium

Q1. Berth of railway seat number
You are given a railway seat number as an integer, your task is to check whether it is a valid seat number or not. Also print its berth type i.e lower berth, middle berth, uppe...read more
Ans. 
Check if seat number is valid seat number or not(i.e in range of 1 to 72).
if (seat_number % 8) equals 1 or 4, then berth is a lower berth
if (seat_number % 8) equals 2 or 5, then berth is a middle berth
if (seat_number % 8) equals 3 or 6, then berth is an upper berth
if (seat_number % 8) equals 7, then berth is a side lower berth
if (seat_number % 8) equals 0 then berth is a side upper berth
Answered by CodingNinjas
View 1 more amswer

Round duration - 90 mins
Round difficulty - Hard

First they asked me to introduce myself then they started questioning on oops concept from basic to advance level such as inheritance, polymorphism, abstraction, exception handling , STL etc. Next they started questioning on data structures. They asked me the logic of “how to find the middle of a linked list”.

Q1. Factorial of a Number
Ans. 
Recursive Solution:
Factorial can be calculated using following recursive formula.
n! = n * (n-1)!
n! = 1 if n = 0 or n = 1
I
Answered by CodingNinjas
Add your answer
Q2. Matrix is symmetric
You are given a square matrix, return true if the matrix is symmetric otherwise return false.
A symmetric matrix is that matrix whose transpose is equal to the matrix itself.
Examp...read more
Ans. 
A Simple solution is to do the following.
1) Create transpose of given matrix.
2) Check if transpose and given matrices are same or not.
Answered by CodingNinjas
View 2 more amswers