JLL is a real estate company and soon it will be dealing with new data science tools. So, one of my friend attended the interview of JLL for Python Data scientist. I am discussing here all the Python Interview questions here. But first of all, lets know why JLL.
JLL(Jones Lang LaSalle) is an American professional services and investment management company specializing in real estate. It values the diversity of its employees and provide them good opportunity growth. Soon, it is targeting to become one customer data science company. So, why not join it 🙂
JLL Python Interview Questions and Interview Process
So, there are total four to five rounds if you are going for JLL Python interview. The very first round will be a telephonic one wherein you will be asked about your current company and job role. The interviewer was very supportive in my friends’ case.
The interviewer will explain about the job role and what a JLL python data scientist does in their company. The interviewer will ask simple managerial type questions and you’ll have to provide him/her your scale in a particular skills.
Give Correct ratings for your skills, Interviewer will make a note of it for future rounds.
Further questions will be like what is your notice period and and further date will be intimated to you if the interview finds you a right candidate.
JLL Python Interview Questions and Answers
There will a technical test based on SQL and Python. You”ll find the test is simple if you know your skills :p. The interviewer will also ask you to write on the test how much time did you take to complete the test. It took my friend around 15 mins to complete the SQL test and 25 min to complete the JLL Python Interview questions.
Hi Friends, today I am sharing with you the Python Test pattern of Dunnhumby. Go through the details to know about Dunnhumby Python Analyst Placement Paper pattern, scoring and further interview process. Also, I would share with you all the details on which you need to focus to get selected as a Dunnhumby Analyst. One of my friend appeared for the Analyst profile for Dunnhumby, Gurgaon location. The interview process started early at 9:00 AM.
Dunnhumby is a customer science company and values the candidates that understand the value that the company adds to its customers. Getting a job at Dunnhumby is like being in your good luck. So, there were many candidates that were either going to appear for an interview on R or Python. My friend appeared for a test on Python. So, Here is the structure of the Python test:
Dunnhumby Placement Paper Pattern
The Dunnhumby Python test contains a total of 15 questions. Out of these 15 questions, 4 were objective questions while 11 of these questions were coding questions where you are supposed to write the answers. Most of these questions were of different scores (2 marks to 5 marks). The questions were typically based on the following things :
Dunnhumby Placement Paper Pattern (Analyst) – Python
Understanding of Python lists
Understanding of operators and float values
For loop applied on lists
Reading the CSV files (few tables were provided and you need to write code to store these files as data frames)
Write the code to change the data type of a column into some other
Write the code to shuffle the list values in a significant way
Sort the table values based on a specific column (ascending or descending order)
Select a particular column based on column joins from two tables
Select column values and calculate min, max, average, count, sum
Re-sampling the data of tables
Dunnhumby Python Objective Test Paper Scoring
In the python technical objective questions you have to choose the output of the applied functions, operators. For this, one should have proper understanding of lists and loops and object referencing. Each objective question contains multiple sub-questions with different score weightage.
The second round will be a case study round and subsequent questions based on it. First of all, do review the already available case studies present on the official website of Dunnhumby. This will help you a lot in forming the logic and giving you an idea of the work Dunnhumby is doing for its clients. As aresult, you will be able to answer the questions asked during this case study interview. Also, wear a smile on your face since nobody likes sad faces :p
That’s all my friends. Best of luck for your interview! 🙂
Please share your interview stories in the comment section. Or you can also share some other company interview experience to me on my contact id.
There are various Date time functions available in SQL which allow us to create trigger based on it. Date time function allow us to check whether an input string is a date or not. Also, we can check what’s the day or week number on a specific date using date time function. To learn about SQL basics and Stored Procedures function, follow my blog.
Let’s check various date time function available with us:
The isDate function is used to check whether the input string is a date or not.
Command: Select isDate(“2012-05-30”), it will return 1
If the input string is not a date, the IsDate date time function will return zero.
The isDate function works well on date, time and datetime datatype but not with datetime2 (timestamp with nanoseconds)
This date time function returns the “day number” of the specified input date string.
Exec spGetEmployeeCount @LastName = “Male”, @TotalCount Out
Benefits of Stored procedures:
The execution plan can be reused
When a normal statement is executed, the path like first few columns are selected, then refined through where clause and then ordered. This is called a kind of execution plan. So, we can save time through stored procedures.
e.g. Select name, gender from Emp
when id IN(12, 14, 15)
order by name
A normal statement if executed with different parameters, use different execution path. However Stored procedures uses the same execution path even with different variable values.
2. Reduced Network Traffic
Since Stored procedures allows code re-usability, the sql instructions takes less time and space while utilizing network bandwidth. Thus network traffic is reduced.
3. Easy Maintainability using Stored Procedures
Maintenance becomes easy. A change in stored procedure is easy rather than finding similar statements at various places and then modifying the code.
4. Code Re-usability
The instruction that will be required again and again need not to be typed again. We just have to create a stored procedure with that statement and this will help us in reusing the code in less time and space.
5. Better Security
The database can be huge and we don’t want everyone to give access to every user in the network. So, build procedures on the specific table to which the user wants access. This way we will be able to provide better security.
6. Avoid SQL Injection Attack
Stored procedures also helps in avoiding SQL injection attacks. To know more about SQL injection attacks, go to the link.
Hola Friends! Today we will learn about various user defined functions present in SQL. So far, we have studied lots of system functions : IsDate, Rand(), round() etc. To gather more information about these system functions, please refer my post Mathematical functions in SQL and Date time functions in SQL.
SQL provides us a feature of programmability wherein it provides system functions as well as lets user create functions of three types:
InLine Table Valued functions
Multi Statement table valued functions
Each type of sql function is of different use and one should have a proper understanding of all these function types.
If you are new to SQL, please check SQL basics and SQL mathematical