NaviSite Senior Consultant Interview Questions and Answers

VM is given and you have 45 min to code the entire code
Please read upon the repository pattern and learn to implement it by heart .
please read upon how to convert decimal to double in .net

Q1. Dapr microservice architecture , Communication and transaction rollback between microservices chereographic saga pattern,api versioning in microservices, dev ops process deployment to kubernetes
Add your answer
Q2. Scrum methodology, how do we handle a team
Add your answer

Q1. General questions on Azure, Terraform, Kubernetes
Add your answer

Q1. In depth questions on Terraform and Kubernetes
Add your answer

Q1. Around project management, agile process
Add your answer

3 SQL questions of basic, intermediate and advance level respectively.

Q1. Technical Questions related to past work
Add your answer

Q1. Salary negotiation and offer.
Add your answer

Asked to write Selenium code to launch flipkart and handle the popup that shows up and asked to write code to reverse an entire string later asked reverse each word in that string without reversing the relative order of that string

A VM was provided with an already applied project with bugs, incorrect implementation of requirement, partial unit test.

They take people in parallel. This works as initial screening round.

Q1. Basic C#, .Net, .Net Core questions
Add your answer
Q2. Architecture questions on how to proceed with an app design.
Add your answer
Q3. SQL procedure function transactions indexes
Add your answer

Q1. Similar from the tech round 1. But more in-depth and including front end technology stack and azure
Add your answer

Q1. Technical Manager review and discussion. Adaptability, handling questions, over view discussions
Add your answer

UX Dashboard Redesign Assessment. They asked to redesign the Dashboard to sort the issue of cognitive load and better experience

They asked to show case one of the case study

Q1. Just discussion about one of my previous project, the methodology, problem statement what all the steps are taken to reach the solution
Add your answer
Q2. They asked about what all the technologies I worked earlier and the industry details.
Add your answer

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