i
Agilisium
Work with us
Filter interviews by
Ranking code in SQL
Use the RANK() function to assign a rank to each row based on a specified column
Use the ORDER BY clause to determine the order of ranking
Handle ties in ranking using the DENSE_RANK() function
Use the ROW_NUMBER() function to assign a unique number to each row
To read a file using Python, use the open() function and specify the file path and mode.
Use the open() function to open the file
Specify the file path and mode (e.g., 'r' for reading)
Read the contents of the file using the read() method
Close the file using the close() method
Reverses an array of strings using Python.
Use the reverse() method to reverse the array in-place.
Alternatively, use slicing with a step of -1 to create a new reversed array.
Remember to convert the array to a list before reversing if necessary.
Full stack refers to the development of both front-end and back-end portions of a web application.
Full stack developers are proficient in both front-end and back-end technologies
They can handle databases, servers, systems engineering, and clients
Examples of full stack technologies include HTML, CSS, JavaScript, Node.js, React, and Angular
Front end development refers to the creation of the user interface and user experience of a website or application.
Involves HTML, CSS, and JavaScript
Focuses on the visual and interactive aspects of a website or application
Requires knowledge of design principles and user behavior
Examples include creating responsive layouts, implementing animations, and optimizing page load speed
Types of filters include low-pass, high-pass, band-pass, and band-stop filters.
Low-pass filter allows frequencies below a certain cutoff frequency to pass through.
High-pass filter allows frequencies above a certain cutoff frequency to pass through.
Band-pass filter allows a specific range of frequencies to pass through.
Band-stop filter blocks a specific range of frequencies from passing through.
The questions are quite simple.
Two SQL and two Python HackerRank questions.
Questions were asked about the projects listed on my resume, focusing on the technologies used, challenges faced, and results achieved.
Technologies used in the project
Challenges faced during the project
Results achieved from the project
I appeared for an interview in Feb 2025.
Basic questions python spark, sql
3 SQL and 2 Python questions were asked, SQL was moderate, Python was tough
Types of filters include low-pass, high-pass, band-pass, and band-stop filters.
Low-pass filter allows frequencies below a certain cutoff frequency to pass through.
High-pass filter allows frequencies above a certain cutoff frequency to pass through.
Band-pass filter allows a specific range of frequencies to pass through.
Band-stop filter blocks a specific range of frequencies from passing through.
SQL, Python Coding intermediate questions
Intermediate coding questions
I applied via Walk-in and was interviewed in Feb 2024. There were 3 interview rounds.
Basic Apti , ex train ,speed work
From Leetcode questions
I applied via Walk-in and was interviewed in Aug 2023. There were 3 interview rounds.
I applied via Walk-in and was interviewed in Sep 2023. There were 2 interview rounds.
Ranking code in SQL
Use the RANK() function to assign a rank to each row based on a specified column
Use the ORDER BY clause to determine the order of ranking
Handle ties in ranking using the DENSE_RANK() function
Use the ROW_NUMBER() function to assign a unique number to each row
To read a file using Python, use the open() function and specify the file path and mode.
Use the open() function to open the file
Specify the file path and mode (e.g., 'r' for reading)
Read the contents of the file using the read() method
Close the file using the close() method
Reverses an array of strings using Python.
Use the reverse() method to reverse the array in-place.
Alternatively, use slicing with a step of -1 to create a new reversed array.
Remember to convert the array to a list before reversing if necessary.
I applied via Approached by Company and was interviewed before Oct 2023. There were 3 interview rounds.
Seeking new challenges and growth opportunities
Desire for new challenges and growth
Looking for a more innovative environment
Seeking better work-life balance
Top trending discussions
based on 16 interview experiences
Difficulty level
Duration
based on 97 reviews
Rating in categories
Hyderabad / Secunderabad,
Chennai
7-12 Yrs
Not Disclosed
Hyderabad / Secunderabad,
Chennai
4-6 Yrs
Not Disclosed
Senior Software Engineer
114
salaries
| ₹9.7 L/yr - ₹17.8 L/yr |
Software Engineer
95
salaries
| ₹6 L/yr - ₹12.4 L/yr |
Data Engineer
77
salaries
| ₹7.5 L/yr - ₹14 L/yr |
Senior Data Engineer
24
salaries
| ₹9.1 L/yr - ₹16.1 L/yr |
Specialist
18
salaries
| ₹9 L/yr - ₹20.5 L/yr |
Cyfuture
JoulestoWatts Business Solutions
Value Point Systems
Black Knight