Wissen Infotech Data Engineer 1 Interview Questions and Answers

Q1. More on Technical area
Add your answer

Q1. More on Technical area
Add your answer

Q1. Technical + Behaviour
Add your answer

Q1. Technical + Behaviour
Add your answer

Q1. Expectation and Genaral
Add your answer

Q1. Data warehousing related questions
Add your answer
Q2. SQL scenario based questions
Add your answer
Q3. Project experience
Ans. 
I have experience working on projects involving data pipeline development, ETL processes, and data warehousing.
• Developed ETL processes to extract, transform, and load data from various sources into a data warehouse

• Built data pipelines to automate the flow of data between systems and ensure data quality and consistency

• Optimized database performance and implemented data modeling best practices

• Worked on real-time data pro...read more
Answered by AI
Add your answer
Q4. Python Based questions
Add your answer
Q5. AWS features and questions
Add your answer

Q1. Similar to first round but in depth questions relatively
Add your answer
Q2. Asked about career goals and stuff
Add your answer

Q1. General work related conversation
Add your answer
Q2. Salary discussion
Add your answer

Q1. Diff between Coalesce and repatriation
Add your answer

It was pair programming round where we need to attempt a couple of Spark Scenario along with the Interviewer. You will have a boiler plate code with some functionalities to be filled up. You will be assessed on writing clean and extensible code and test cases.

Q1. Questions will be based on the Project where they try to assess the depth of understading you have on your project, data quality checks, handling failure scenarios, reasoning behind choice of tech stack
Add your answer

Q1. Incremental load in pyspark
Ans. 
Incremental load in pyspark refers to loading only new or updated data into a dataset without reloading the entire dataset.
• Use the 'delta' function in pyspark to perform incremental loads by specifying the 'mergeSchema' option.

• Utilize the 'partitionBy' function to optimize incremental loads by partitioning the data based on specific columns.

• Implement a logic to identify new or updated records based on timestamps or uni...read more
Answered by AI
Add your answer
Q2. Drop duplicates
Add your answer

Q1. Sql regarding question was there
Add your answer

Coding test for all the student attending the first round, give your best practice every day all the best in your interview

Q1. What are your interest
Ans. 
My interests include data analysis, problem-solving, and continuous learning.
• Data analysis

• Problem-solving

• Continuous learning
Answered by AI
Add your answer
Q2. Java related question
Add your answer

Questions on SQL, Python and Data Science. SQL joins and Cumulative Sum question followed by Python function definitions to lambda functions - square the odd digits in array using lambda function. Data Science - Which test metric to use for assessing CTR and when to differentiate between Mean Sq Error and R2 coefficient of Variation. Overall medium difficulty questions.