Accenture
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Filter source data by department id and store in unique files
Use Talend components like tFilterRow to filter data based on department id
Create a unique file for each department using tFileOutputDelimited component
Loop through all department ids to process data for each department
Optimizing SQL queries can improve query performance by using indexes, avoiding unnecessary joins, and optimizing the query structure.
Use indexes on columns frequently used in WHERE clauses
Avoid using SELECT * and only retrieve necessary columns
Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
Use WHERE clause to filter data early in the query
Avoid using functions in WHERE clauses as they can preven
I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
based on 1 interview
Interview experience
based on 4 reviews
Rating in categories
Application Development Analyst
38.9k
salaries
| ₹3 L/yr - ₹12 L/yr |
Application Development - Senior Analyst
26.9k
salaries
| ₹6.9 L/yr - ₹20.2 L/yr |
Team Lead
24.5k
salaries
| ₹7.1 L/yr - ₹25.7 L/yr |
Senior Software Engineer
18.1k
salaries
| ₹6 L/yr - ₹20 L/yr |
Senior Analyst
17.6k
salaries
| ₹5.5 L/yr - ₹21 L/yr |
TCS
Cognizant
Capgemini
Infosys