OOP Patterns, SQL query questions involving optimization, live coding with writing a simple class and some LINQ queries
Analyst Developer Interview Questions
1,020 analyst developer interview questions shared by candidates
SQL: Triggers Function syntax Procedure execution Joins how do you optimize slow running query delete and drop Common Table expressions Normalization They will give scenarios and ask you to write the queries. Power Bi: difference of Filter/ slicer page level filters Import mode and direct query Relationships some example scenerio questions: if i take the live data can we refresh the report everyday? if i have 5 lakhs record and 10k records which one you will use import mode or direct mode? Time intelligence functions
Q: model traffic system (group stage) Q: few simple coding tasks on C# and SQL
Array and Sql based questions
Are you familiar with stored procedures? Describe your experience using stored procedures.
What is your favorite programming language to develop applications in?
They spend so much time on past project experience than the latest project you have on your resume. The technical interview was simple. Some basic DW and reporting questions. There was also another question to write a query from a given database diagram.
About the different standards of edi.
The interview was conversational and steered more towards technical experience and demonstrable skill sets.
Technical and interpersonal
Viewing 871 - 880 interview questions