IT Convergence Web Developer Interview Questions and Answers

Level of aptitude is easy

In this selected role question is asked suppose I applied in .net then coding must in c#

Son of the uncle's Kid is __ of son. This and some basic mathematics equation, etc were the questions

3 questions were there 1 was writing SQL query, 1 tree node related program, 1 logical question

Q1. Basic introduction question, Core oops concepts, basic SQL related questions, etc
Add your answer

Q1. Javascript and React native questions
Add your answer

It was an aptitude test consisting of 40 questions in 30 minutes.

There were coding questions
1.) Find the sum of 4 largest no in an array.
2.)find area of the largest rectangle in a histogram.
3.)Sudoko challenge

IN this section ask 60 aptitude qustion based on some computer science subject some qustions are on logic bulidng.

In this round they give one DSA quation which one is solve in only 30 min. According to my the qustion was is easy.

Percentages,Ratio,time,

Arrays,Strings,Hashing,stacks

Aptiude test on their platform

Coding question on array

It was a 30 minutes round questions on Python, SQL, Pyspark - scenario based question to write the code.

Q1. Here you will be asked few theoretical question like defination, where to use, what is the advantage etc. - Focused on Azure (ADF,ADLS,Synapse), SQL, Pyspark,python
Add your answer
Q2. SQL Optimization
Add your answer
Q3. Dynamic file ingestion in ADF
Ans. 
Dynamic file ingestion in ADF involves using parameters to dynamically load files into Azure Data Factory.
• Use parameters to specify the file path and name dynamically

• Utilize expressions to dynamically generate file paths

• Implement dynamic mapping data flows to handle different file structures
Answered by AI
Add your answer
Q4. Agregation in databricks
Ans. 
Aggregation in Databricks refers to the process of combining and summarizing data in a Spark environment.
• Aggregation functions like sum, count, avg, min, max can be used in Databricks to summarize data.

• Grouping data based on certain columns and then applying aggregation functions is a common practice.

• Aggregation can be performed on large datasets efficiently using Databricks' distributed computing capabilities.
Answered by AI
Add your answer

Q1. It would be basic HR round to understand your expectation and expertise.
Add your answer