i
UST
Filter interviews by
I applied via Campus Placement and was interviewed in Oct 2024. There was 1 interview round.
Use regular expression to remove special characters from a string
Use the regex pattern [^a-zA-Z0-9\s] to match any character that is not a letter, digit, or whitespace
Use the replace() function in your programming language to replace the matched special characters with an empty string
Example: input string 'Hello! How are you?' will become 'Hello How are you' after removing special characters
Rank assigns unique rank to each row, while dense rank assigns consecutive ranks without gaps.
Rank leaves gaps in rank sequence if there are ties, while dense rank does not
Rank function is used to assign a unique rank to each row based on a specified column
Dense rank function is used to assign consecutive ranks to rows without any gaps
Example: If there are two rows with rank 1 in a dataset, rank function will assign 1
Use Google Cloud Storage to load CSV data into BigQuery
Upload the CSV file to Google Cloud Storage
Create a BigQuery table with the appropriate schema
Use the 'bq load' command to load the data from the CSV file into the BigQuery table
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
ADF triggers are used in Azure Data Factory to schedule and orchestrate data pipelines.
ADF triggers enable the automation of data movement and data transformation activities.
Triggers can be scheduled to run at specific times or based on event-based triggers.
They can be used to start or stop pipelines, and can be configured with parameters and dependencies.
Examples of triggers include time-based schedules, event-based t...
IR stands for Integration Runtime. Dataset is a representation of data, while linked service is a connection to the data source.
IR is a compute infrastructure used to provide data integration capabilities
Dataset is a structured representation of data used in data engineering tasks
Linked service is a connection to a data source, providing access to the data
IR enables data movement and transformation between different da...
Optimization techniques in Spark
Partitioning data to optimize data locality
Caching frequently accessed data
Using broadcast variables for small data sets
Using appropriate data structures and algorithms
Avoiding unnecessary shuffling of data
What people are saying about UST
I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.
I applied via Campus Placement and was interviewed before Aug 2021. There were 2 interview rounds.
Easy DSA questions and some questions on resume
I applied via Campus Placement and was interviewed in Mar 2020. There was 1 interview round.
To get the second to last element from a SQL table, use the OFFSET-FETCH clause.
Use the ORDER BY clause to sort the table in descending order.
Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;
I applied via Naukri.com and was interviewed before Jun 2021. There was 1 interview round.
I applied via Campus Placement and was interviewed before May 2020. There were 3 interview rounds.
based on 3 interviews
1 Interview rounds
based on 12 reviews
Rating in categories
Software Developer
2.1k
salaries
| ₹2.5 L/yr - ₹12.1 L/yr |
Senior Software Engineer
1.7k
salaries
| ₹7.2 L/yr - ₹27.8 L/yr |
Software Engineer
1.3k
salaries
| ₹3.7 L/yr - ₹15.5 L/yr |
System Analyst
1.1k
salaries
| ₹6.3 L/yr - ₹21 L/yr |
Validation Engineer
936
salaries
| ₹2 L/yr - ₹7.2 L/yr |
TCS
Infosys
Wipro
HCLTech