Kadence International Data Executive Interview Questions and Answers

Q1. What is coalesce
Ans. 
Coalesce is a function used to return the first non-null value in a list of expressions.
• Coalesce function is commonly used in SQL to handle null values.

• It takes multiple arguments and returns the first non-null value.

• Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.
Answered by AI
Add your answer
Q2. What is repartition
Ans. 
Repartition is the process of redistributing data across partitions in a distributed system.
• Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

• It involves moving data between partitions based on certain criteria such as key values or hash functions.

• Repartitioning can be done in Spark using operations like repartition() or coalesce().
Answered by AI
Add your answer

Q1. Non repeatable character
Ans. 
A non repeatable character is a character that appears only once in a given string.
• Iterate through the string and count the frequency of each character

• Identify the characters that have a frequency of 1

• Return the first non repeatable character found
Answered by AI
Add your answer
Q2. Sort list without sort method
Ans. 
Sort list without using sort method
• Create a custom sorting function using loops

• Compare each element with every other element to determine the correct order

• Swap elements based on the comparison results
Answered by AI
Add your answer

I was asked to write SQL queries for 3rd highest salary of the employee, some name filtering, group by tasks.
Python code to find the index of the maximum number without using numpy.

Q1. Explain the Project undertaken during the research and follow-up questions
Add your answer

Q1. Write pandas query to separate the names as first and last name from the full name. Drop the duplicate columns and also the missing values. Write output for the Python code. Write SQL query to retrieve t...read more
Ans. 
Answering questions related to data science concepts and techniques.
• Recall is the ratio of correctly predicted positive observations to the total actual positives. Precision is the ratio of correctly predicted positive observations to the total predicted positives.

• To reduce variance in an ensemble model, techniques like bagging, boosting, and stacking can be used. Bagging involves training multiple models on different ...read more
Answered by AI
Add your answer

The aptitude test was easy.just like usual aptitude questions like quants,verbal,reasoning etc....

Q1. Second round was all about one on one video call interview where they will ask to record a video and send it.(managerial questions). Like, why do you need to join mu sigma,why should we hire you....
Ans. Third round was online hr interview. Where there will ask questions based on your resumes.
Answered Anonymously
Add your answer

Q1. How to read and write parquet files in pyspark?
Ans. 
Reading and writing parquet files in PySpark involves using the SparkSession API.
• Create a SparkSession object

• Read a parquet file using spark.read.parquet() method

• Write a DataFrame to a parquet file using df.write.parquet() method
Answered by AI
Add your answer

Analysing the company's document and finding out the answer which will be given in choose

Q1. Details of ESG(Environmental, social and governance)
Ans. 
ESG stands for Environmental, Social and Governance. It is a set of criteria used to evaluate a company's performance in these areas.
• Environmental criteria include a company's impact on the environment, such as its carbon footprint and use of renewable energy.

• Social criteria include a company's relationships with its employees, customers, and communities, as well as its impact on human rights.

• Governance criteria includ...read more
Answered by AI
Add your answer
Q2. What is mean by renewable and non renewable energy
Ans. 
Renewable energy is derived from natural resources that can be replenished, while non-renewable energy is finite and cannot be replenished.
• Renewable energy sources include solar, wind, hydro, geothermal, and biomass

• Non-renewable energy sources include fossil fuels like coal, oil, and natural gas

• Renewable energy is considered more sustainable and environmentally friendly

• Non-renewable energy sources are finite and will e...read more
Answered by AI
Add your answer

Q1. Technical and Problem solving interview. Mostly related to your resume
Add your answer

Q1. 2nd Round of technical and it is related to mostly data engineering
Add your answer

Q1. This is Techno manager round includes technical and behavioral questions
Add your answer

Q1. This round includes Technical first and Problem solving
Add your answer

Q1. This is final round mostly offer discussion
Add your answer

Q1. What are sql aggregate functions?
Ans. 
SQL aggregate functions perform calculations on a set of values and return a single value.
• Aggregate functions include COUNT, SUM, AVG, MAX, and MIN.

• COUNT returns the number of rows in a table or the number of non-null values in a column.

• SUM returns the sum of all values in a column.

• AVG returns the average of all values in a column.

• MAX returns the highest value in a column.

• MIN returns the lowest value in a column.
Answered by AI
Add your answer
Q2. What is sub quires how its was working befif exolanation they asked for me
Add your answer

Discussed about company and work related topic

Q1. Self introduction , mathematical questions
Add your answer