Tell me about yourself, your major, why you want to work here.
Associate Consultant Interview Questions
16,735 associate consultant interview questions shared by candidates
Starts from self introduction and will asks questions on each point mentioned in the resume and additional questions.
map vs flatmap coalesce vs repartition can I reduce partitions using repartitions wide tranformations vs narrow transformations spark 1.0 vs spark 2.0 sparkContext vs SparkSession what is DAG?Why we need it? What is lineage?why we need it? DAG vs lineage rdd vs dataset vs dataframe
how do you do xss?
Write an SQL query using joins to fetch employee details from two related tables.
1.Deep dive into one of my projects, and follow-ups were asked. This varied from details being stored in the database,purpose,scope and feasibility of the application and main focus was on the coding aspect of it, like what coding was done. 2.Different types of joins and a SQL query using joins 3. 2-3 basic aptitude questions Some people were also asked basic DSA questions like reverse string, swap two numbers without third one, so be prepared for such questions as well. Also ensure you know your resume inside out. Keep it simple as much as you can as the role being Associate Consultant, your achievements don't matter much so even if you have a simple resume, be confident in your communication and thorough with your resume as many people did get selected who had a simple and plain resume.
How can your degree modules help you as a consultant ?
1) what is an abstract class in java? 2) Tell me about polymorphism, diff b/w overriding & overloading, coded example (just brief) 3) prime no code, palindrome string code ( you have to write a rough code & need to describe your code, she may ask conditions from your code) 4) diff b/w abstract, normal & inner class. 5) inheritance brief, why multiple Inheritance is not supportable in java and how we use it in java. 6) tell me about your academic project 7) diff b/w DBMS & RDBMS 8) what is trigger, schema in RDBMS 9) describe joining 10) or, and, nand gate etc she also asked lots of hr questions like self-intro, strength, hobby, why ece? why dxc? many questions but easy
What is your project in majors?
Why you want to join this organization
Viewing 391 - 400 interview questions
See Interview Questions for Similar Jobs
Business AnalystPrincipal ConsultantManaging ConsultantBusiness Development AnalystManagement ConsultantFinancial AnalystStaff ConsultantElectrical SupervisorHuman Capital ConsultantBusiness ConsultantSenior ConsultantAssistant ConsultantIt ConsultantAssociate AnalystHuman Resources ConsultantImplementation ConsultantConsulting AnalystTechnology ConsultantSummer Associate