i
Principal Global Services
Filter interviews by
I applied via Approached by Company and was interviewed in May 2024. There were 2 interview rounds.
End to end project architecture involves designing and implementing a data pipeline to process and analyze data from various sources.
Define project requirements and goals
Design data architecture including data sources, storage, processing, and analytics tools
Implement data pipeline to extract, transform, and load data
Ensure data quality and consistency throughout the pipeline
Monitor and optimize performance of the data...
Implemented query optimization techniques to improve performance in data processing.
Utilized indexing to speed up data retrieval
Optimized SQL queries by rewriting them for better performance
Implemented caching mechanisms to reduce redundant data processing
Using Common Table Expressions (CTEs) to delete duplicates in SQL query
Use a CTE to identify duplicates by ranking rows based on a unique identifier
Delete rows with duplicate ranks in the main query
Reverse a list without using inbuilt functions
Create two pointers, one at the start and one at the end of the array
Swap the elements at the two pointers and move them towards the center until they meet
Repeat the process until the entire list is reversed
End to end project implementation involves taking a project from conception to completion, including planning, development, testing, and deployment.
Define project goals and requirements
Design data pipelines and architecture
Develop and implement data processing algorithms
Test and validate data quality and accuracy
Deploy and monitor the project in production
Iterate and improve based on feedback
SQL joins combine data from two or more tables based on a related column between them.
Different types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
The number of records in the result of a join depends on the type of join and the data in the tables.
For example, an INNER JOIN will only return records that have matching values in both tables, while a LEFT JOIN will return all records from the left...
Questions on python programming- 2 and SQL-1
They will ask from you resume
posted on 16 Apr 2024
I applied via Campus Placement
Basic 10 apti question
Basic 5 python question
Basic 5 SQL question
posted on 27 Jul 2024
General SQL Questions.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
I applied via Naukri.com and was interviewed before Mar 2023. There was 1 interview round.
LAN stands for Local Area Network. A firewall is a network security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules.
LAN is a network of interconnected devices within a limited area, such as a home, office, or campus.
Firewall works by examining data packets and determining whether they should be allowed through based on predefined security rules.
Firewalls can...
I applied via Naukri.com and was interviewed in Dec 2021. There were 2 interview rounds.
Hard level of 1 st round with manager and team
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Process Specialist
334
salaries
| ₹2.6 L/yr - ₹6.3 L/yr |
Analyst
328
salaries
| ₹2.7 L/yr - ₹11 L/yr |
Software Engineer
296
salaries
| ₹8 L/yr - ₹15 L/yr |
Softwaretest Engineer
220
salaries
| ₹3.5 L/yr - ₹5.6 L/yr |
Senior Analyst
137
salaries
| ₹4.9 L/yr - ₹17.5 L/yr |
IBM
Accenture
TCS
Infosys