Inferenz Tech Data Engineer Interview Questions and Answers

Q1. What experience do you have in this role?
Add your answer
Q2. What tools or technologies are you comfortable using?
Ans. 
I am proficient in various data analysis tools, including Excel, SQL, Python, and visualization software like Tableau.
• Excel: Advanced functions, pivot tables, and data visualization.

• SQL: Writing complex queries for data extraction and manipulation.

• Python: Utilizing libraries like Pandas and NumPy for data analysis.

• Tableau: Creating interactive dashboards for data visualization.

• R: Statistical analysis and data visualiza
Answered by AI
Add your answer

Q1. Tell me about projects you have worked upon
Add your answer
Q2. PEP-8 standards
Add your answer

Q1. Architecture of project on which you were working
Add your answer
Q2. Pandas and Numpy
Add your answer

Q1. Tell me your Current CTC
Add your answer
Q2. Tell me your Expected CTC
Add your answer

Basic java questions along with aptitude questions.

Q1. Basic oops concept, java functionalities, spring framework.
Add your answer

Q1. Basic Hr questions, when you can join, expected ctc...
Add your answer

The aptitude test was relatively straightforward, consisting of both aptitude and technical questions, with a difficulty level ranging from easy to medium.

Q1. Was asked to write a code on basic DSA concept
Add your answer
Q2. Then was asked basic questions on DSA and SQL
Add your answer

Q1. Question on Java mcq
Add your answer
Q2. Questions on Oops
Add your answer

Q1. Questions based on resume
Add your answer

Q1. Questions on direction, physics
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical interview round with questions on DSA and DBMS mainly.

Q1. 
Maximum Sum Subarray Problem Statement
Given an array ARR consisting of N integers, determine the sum of the subarray with the maximum sum, including the possibility of an empty subarray.
A subarray is a...read more
Ans. 
Find the sum of the subarray with the maximum sum in a given array.
• Iterate through the array and keep track of the current sum and maximum sum.

• Update the maximum sum if the current sum becomes greater.

• Handle cases where the array has all negative numbers or empty subarray.

• Example: For input [-2, 1, -3, 4, -1], the maximum sum subarray is [4] with sum 4.
Answered by AI
Add your answer
Q2. 
Prime Numbers Identification
Given a positive integer N, your task is to identify all prime numbers less than or equal to N.
Explanation:
A prime number is a natural number greater than 1 that has no po...read more
Ans. 
Identify all prime numbers less than or equal to a given positive integer N.
• Iterate from 2 to N and check if each number is prime

• Use the Sieve of Eratosthenes algorithm for efficient prime number identification

• Optimize by only checking numbers up to square root of N for divisibility
Answered by AI
Add your answer
Q3. What are Joins in the context of databases?
Ans. 
Joins in databases are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right ta...read more
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

Typical HR round with behavioral problems.

Hackerrank Test

Q1. Questions related to NodeJS and Javascript Basics
Add your answer

Q1. Technical questions based on past experience
Add your answer

Q1. Company Culture related
Add your answer

Q1. Expectations and Processes
Add your answer