Filter interviews by
Nklrgn ij iojt hohoihcnjoh uth hd afbc heigf oj
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
A dictionary is a collection of key-value pairs, while a list is a collection of ordered elements.
A dictionary is accessed by keys, while a list is accessed by index.
Dictionaries are unordered, while lists are ordered.
Example: dict = {'name': 'John', 'age': 30}, list = ['apple', 'banana', 'cherry']
I have experience writing SQL queries for data manipulation and analysis.
Use SELECT statement to retrieve data from a database
Use WHERE clause to filter results based on specific conditions
Use JOIN clause to combine data from multiple tables
Int & Float data types are used to represent whole numbers and decimal numbers respectively in programming.
Int data type is used for whole numbers without any decimal points, such as 5, -10, 1000
Float data type is used for numbers with decimal points, such as 3.14, -0.5, 10.75
Int data type is typically used for counting or indexing, while Float data type is used for calculations involving fractions or decimals
Left join includes all records from the left table and matching records from the right table. Right join includes all records from the right table and matching records from the left table. Full join includes all records when there is a match in either left or right table.
Left join: includes all records from the left table and matching records from the right table
Right join: includes all records from the right table and...
I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.
I have worked on various projects including developing mobile applications, creating websites, and implementing data analysis solutions.
Developed a mobile application for tracking daily water intake
Created a website for a local non-profit organization to showcase their work
Implemented a data analysis solution to optimize inventory management for a retail company
Duplicate records can be deleted from a SQL table by using the DELETE statement with a subquery to identify and remove the duplicates.
Use a subquery to identify the duplicate records based on specific criteria
Use the DELETE statement with the subquery to remove the duplicate records
Ensure to backup the data before deleting any records
Python code to generate Fibonacci series
Use a loop to iterate and calculate the next Fibonacci number
Start with 0 and 1 as the first two numbers
Add the previous two numbers to get the next number
Yes, I am ready to move to the location for the job.
I am excited about the opportunity to relocate for this position.
I have already researched the location and feel comfortable moving there.
I have discussed the potential move with my family and we are all on board.
I am prepared to make the necessary arrangements to move smoothly.
Yes, I have experience handling client issues in my previous role as a Technical Analyst.
Managed and resolved technical issues reported by clients
Communicated effectively with clients to understand their concerns and provide solutions
Prioritized and escalated urgent client issues to ensure timely resolution
JLL Technologies interview questions for popular designations
Find and remove a substring from a given string
Use string manipulation functions to find and remove the substring
Iterate through the string and check for occurrences of the substring
Replace the substring with an empty string to remove it
Get interview-ready with Top JLL Technologies Interview Questions
posted on 28 Jan 2025
I was interviewed in Jul 2024.
Rank assigns a unique number to each row based on a specified criteria, while row number assigns a sequential number to each row in the result set.
Rank function can have ties, where multiple rows can have the same rank value.
Row number function always assigns a unique number to each row in the result set.
Rank function is typically used to identify the top N records based on a certain criteria.
Row number function is oft...
Basic coding test with data and control loop
I applied via AmbitionBox and was interviewed in Mar 2024. There was 1 interview round.
There are mainly two types of transformers: step-up transformers and step-down transformers.
Step-up transformers increase voltage levels, while step-down transformers decrease voltage levels.
Transformers can also be classified based on their construction, such as core type transformers and shell type transformers.
Other types of transformers include distribution transformers, power transformers, and instrument transform
The number of HVAC AHUs can vary depending on the size and layout of the building.
The number of HVAC AHUs is typically determined by the size of the building and the specific heating and cooling needs of different areas.
Large commercial buildings may have multiple HVAC AHUs to efficiently regulate temperature throughout the space.
Residential buildings may have a single HVAC AHU serving the entire home.
HVAC AHUs can als...
A transformer is an electrical device that transfers electrical energy between two or more circuits through electromagnetic induction.
Transformers are used to increase or decrease the voltage in electrical power transmission and distribution systems.
They consist of two or more coils of wire, known as windings, that are wound around a core made of magnetic material.
The primary winding is connected to the input voltage s...
I applied via LinkedIn and was interviewed in Jun 2023. There were 3 interview rounds.
Top trending discussions
based on 17 interviews
Interview experience
based on 67 reviews
Rating in categories
Software Engineer2
18
salaries
| ₹20 L/yr - ₹23 L/yr |
Senior Data Engineer
12
salaries
| ₹23 L/yr - ₹46 L/yr |
Data Quality Analyst
11
salaries
| ₹7.1 L/yr - ₹9 L/yr |
Business Analyst
9
salaries
| ₹4.8 L/yr - ₹8 L/yr |
Senior Software Engineer
9
salaries
| ₹16.5 L/yr - ₹50 L/yr |
CBRE
Colliers India
Cushman & Wakefield
Knight Frank