AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
EXL Service
Compare
Filter interviews by
EXL Service ETL Developer Interview Questions, Process, and Tips
EXL Service ETL Developer Interview Experiences
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. 1) Explain about your project
- Q2. 2) for each loop container
- Ans.
For Each Loop Container is used to iterate through a set of objects or files in SSIS packages.
Used to perform repetitive tasks on a set of objects or files
Can be used to loop through files in a directory or rows in a table
Requires a data source and a variable to store the current object or file
Can be configured to run in parallel or sequentially
- Q3. 3) SCD Type 2 dimension used in your old project
- Ans.
SCD Type 2 is used to maintain historical data in a dimension table.
SCD Type 2 is used to track changes in dimension attributes over time.
It creates a new record for each change and maintains a history of all changes.
It includes additional columns like start date, end date, and version number.
Example: Employee table with changes in job title, salary, and department over time.
It helps in analyzing trends and making info
- Q4. 4) joins in SQL
- Ans.
Joins are used in SQL to combine data from two or more tables based on a related column.
Joins are used to retrieve data from multiple tables.
Common types of joins are inner join, left join, right join, and full outer join.
Joins are performed using the JOIN keyword and specifying the tables to join and the columns to join on.
Joins can be used to filter data based on a related column.
Joins can also be used to combine dat
- Q5. 5) different between truncate, delete and drop
- Ans.
Difference between truncate, delete and drop
Truncate removes all data from a table but keeps the structure
Delete removes specific rows from a table
Drop removes the entire table and its structure
Truncate and drop cannot be rolled back, but delete can be
Truncate is faster than delete as it does not log individual row deletions
- Q6. 6) what is Normalization
- Ans.
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a table into smaller tables to reduce redundancy.
It helps to avoid data inconsistencies and anomalies.
Normalization is achieved through a series of normal forms, such as first normal form (1NF), second normal form (2NF), and so on.
Each normal form has specific rules that mus...
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
(3 Questions)
- Q1. Tell me about yourself
- Ans.
I am a software developer with 5 years of experience in developing web applications using Java, JavaScript, and SQL.
5 years of experience in software development
Proficient in Java, JavaScript, and SQL
Developed web applications for various clients
Strong problem-solving skills
Excellent team player
- Q2. What is your roles and responsibilities
- Ans.
As a Software Developer, my roles and responsibilities include designing, developing, testing, and maintaining software applications.
Designing and developing software applications based on client requirements
Testing and debugging code to ensure functionality and performance
Collaborating with team members to brainstorm and implement new features
Maintaining and updating existing software applications
Staying up-to-date wi
- Q3. Explain about bug lifecycle
- Ans.
Bug lifecycle involves identification, reporting, fixing, retesting, and closing of software bugs.
Identification: Bug is identified by testers or users through testing or real-world usage.
Reporting: Bug is reported to developers with detailed information like steps to reproduce.
Fixing: Developers analyze and fix the bug in the code.
Retesting: Testers verify the fix to ensure the bug is resolved.
Closing: Bug is closed o
(2 Questions)
- Q1. Case study with the topic provided
- Q2. Questions on the resume
Skills evaluated in this interview
I applied via Job Portal and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. Given the start and end times of the meetings, how can you determine if you are able to attend all of them?
Selected
I applied via Walk-in and was interviewed in Jul 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Uikit explaination
- Q2. Model classes with uikit
- Ans.
Model classes in UIKit are used to represent data in an application's user interface.
Model classes in UIKit typically subclass NSObject and are used to store and manage data for views.
They can include properties to represent different data fields, methods to manipulate the data, and sometimes protocols for delegation.
For example, a model class for a user profile in a social media app might have properties like username...
Project related questions
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed in Sep 2023. There were 2 interview rounds.
Aptitude Test + Technical Questions + One Coding Question
(2 Questions)
- Q1. Detect the loop in a Singly linked list
- Ans.
Detect loop in a singly linked list
Use two pointers, one moving one step at a time and the other moving two steps at a time
If there is a loop, the two pointers will eventually meet
If any of the pointers reach the end of the list, there is no loop
- Q2. 2 Sum (find a pair of numbers that sums up to a target)
- Ans.
The 2 Sum problem involves finding a pair of numbers in an array that adds up to a given target.
Use a hash table to store the complement of each number as you iterate through the array.
Check if the current number's complement exists in the hash table.
If found, return the indices of the two numbers.
If no pair is found, return an empty array.
Interview Preparation Tips
Followed by Technical Interview Round 1 and Round 2
Skills evaluated in this interview
Selected
I applied via Company Website and was interviewed in Jul 2022. There were 4 interview rounds.
Apt + coding questions, medium difficulty
(1 Question)
- Q1. Basics qs on oops and known programming language
(1 Question)
- Q1. In-depth of oops and live coding questions
(1 Question)
- Q1. Basics qs like y and what
Selected
I applied via Naukri.com and was interviewed before Aug 2023. There were 3 interview rounds.
Logical and reasoning, Maths
Basic coding Java & C
(2 Questions)
- Q1. Array and types
- Q2. Inheritance & OOPS
Interview Preparation Tips
I applied via Referral and was interviewed before Mar 2022. There were 3 interview rounds.
Basic coding questions And logical questions
Simple program for mathematics
Interview Preparation Tips
I applied via Approached by Company and was interviewed in Aug 2024. There was 1 interview round.
(2 Questions)
- Q1. Shallow copy and deep copy
- Q2. What is Pure component
- Ans.
A Pure component is a component in React that does not have any state or lifecycle methods, resulting in improved performance.
Pure components are used to prevent unnecessary re-renders in React applications.
Pure components implement shouldComponentUpdate method with shallow comparison of props and state.
Examples of Pure components include functional components and class components that extend PureComponent class.
Interview Preparation Tips
Qunatative, Reasoning, Blood Relation
(1 Question)
- Q1. CS fundamentals, DSA
(1 Question)
- Q1. Behavioural Questions only
EXL Service Interview FAQs
Tell us how to improve this page.
EXL Service Interviews By Designations
- EXL Service Business Analyst Interview Questions
- EXL Service Consultant Interview Questions
- EXL Service Executive Interview Questions
- EXL Service Assistant Manager Interview Questions
- EXL Service Senior Associate Interview Questions
- EXL Service Senior Executive Interview Questions
- EXL Service Data Analyst Interview Questions
- EXL Service Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Informatica ETL Developer Interview Questions
- Senior ETL Developer Interview Questions
- Database Developer Interview Questions
- Informatica Developer Interview Questions
- ETL Lead Interview Questions
- SQL Server Developer Interview Questions
- Datastage Developer Interview Questions
- Software Developer Interview Questions
- Show more
ETL Developer Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Executive
4.3k
salaries
|  ₹1 L/yr - ₹7.1 L/yr |
|
Assistant Manager
3k
salaries
| ₹4 L/yr - ₹15 L/yr |
|
Senior Associate
2.4k
salaries
| ₹1.2 L/yr - ₹8 L/yr |
|
Lead Assistant Manager
1.9k
salaries
| ₹6.3 L/yr - ₹22 L/yr |
|
Executive
1.7k
salaries
| ₹1 L/yr - ₹5.5 L/yr |
Genpact
WNS
TCS
Infosys
- Home >
- Interviews >
- EXL Service Interview Questions >
- EXL Service ETL Developer Interview Questions
