AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Automatic Data Processing (ADP)
Compare
Proud winner of ABECA 2025 - AmbitionBox Employee Choice Awards
Filter interviews by
Automatic Data Processing (ADP) ETL Developer Interview Questions and Answers
Automatic Data Processing (ADP) ETL Developer Interview Experiences
1 interview found
I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.
(4 Questions)
- Q1. Diff between star schema and snowflake schema?
- Ans.
Star schema has a centralized fact table with denormalized dimensions, while snowflake schema has normalized dimensions.
Star schema is simpler and easier to understand compared to snowflake schema.
In star schema, dimensions are denormalized and directly connected to the fact table.
Snowflake schema has normalized dimensions, meaning dimensions are further broken down into sub-dimensions.
Star schema is more suitable for ...
- Q2. Explain the scenario based on type 2 scd in ur project
- Ans.
Type 2 SCD is used to track historical changes in data, creating new records for each change.
In our project, we use Type 2 SCD to track changes in customer information such as address, phone number, and email.
When a customer's address changes, a new record is created with the updated address and a new surrogate key.
This allows us to maintain a history of customer information and analyze trends over time.
- Q3. How to delete records in a table?
- Ans.
Records in a table can be deleted using SQL DELETE statement.
Use the DELETE statement followed by the table name to delete records.
You can add a WHERE clause to specify which records to delete.
Make sure to commit the transaction after deleting records to make the changes permanent.
- Q4. Max sal of an employee
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Oct 2019. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Why you left your first job?
- Ans.
I left my first job to pursue better growth opportunities and align my career with my passion for data engineering.
I felt that my skills were not being fully utilized in my first role, which limited my professional growth.
The company culture did not align with my values, making it challenging to stay motivated.
I wanted to work on more complex ETL projects that could enhance my technical expertise.
I received an offer fr...
- Q2. Because I want good growth in my career.
Interview Preparation Tips
ETL Developer Interview Questions & Answers
Carelon Global Solutions
Anonymous
posted on 21 Sep 2023
I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.
(3 Questions)
- Q1. About project details
- Q2. Explain use of lookup
- Ans.
Lookup is used in ETL processes to search for a specific value in a dataset and retrieve related information.
Lookup is used to search for a specific value in a dataset
It retrieves related information based on the search criteria
Lookup can be used to join data from different sources based on a common key
- Q3. Type of lookup transformation
- Ans.
There are three types of lookup transformations: Connected, Unconnected, and Cached.
Connected lookup transformation is used to look up data from a relational table or view.
Unconnected lookup transformation is used to look up data from a flat file or external source.
Cached lookup transformation stores the lookup data in memory for faster access.
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. How would you increase the sales of newspaper in your locality?
- Ans.
To increase newspaper sales in the locality, I would focus on improving content, distribution, and marketing strategies.
Conduct market research to understand readers' preferences and interests
Create engaging and informative content that caters to the local audience
Offer attractive subscription packages and discounts to encourage regular readership
Partner with local businesses and events to increase visibility and distr...
- Q2. What new feature you would like to add in Google maps and how would it help to increase the company's revenue?
- Ans.
I would like to add a feature that suggests nearby events and attractions based on user preferences.
Personalized event and attraction recommendations
Integration with ticketing platforms for revenue sharing
Increased user engagement and retention
Interview Preparation Tips
Experience: In the written test they asked questions from logical and quantitative aptitude, verbal reasoning and few questions from core topics.
Round: HR Interview
Experience: This was followed by different rounds of interviews. The HR questions were mainly about me, my strengths and weaknesses and why do I want to join the company and where do I see myself in the next five years or so. Loads of guesstimate questions like estimate number of autos in Delhi and other similar cases.
College Name: LADY SHRI RAM COLLEGE
I applied via Approached by Company and was interviewed in Nov 2021. There were 2 interview rounds.
(1 Question)
- Q1. Excel case study given to be completed in 2 hours
Presentation on a adobe product
Interview Preparation Tips
Selected
I appeared for an interview in Jun 2025, where I was asked the following questions.
- Q1. Walk me through your resume
- Ans.
I have a diverse background in data analysis, project management, and financial modeling, with a strong focus on delivering insights.
Graduated with a degree in Economics, where I developed a strong foundation in statistical analysis and economic theory.
Interned at XYZ Corp, where I assisted in analyzing market trends, leading to a 15% increase in sales through data-driven recommendations.
Worked as a Data Analyst at ABC...
- Q2. Generic questions, as in how will you meet deadlines, how to say no
Automatic Data Processing (ADP) HR Interview Questions
(1 Question)
- Q1. Integration and sales cloud
Chetan N
IQ test conducted inside office
Group discussioin about a common topic
Selected
I applied via LinkedIn and was interviewed in Dec 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Machine learning questions
- Q2. Decision trees, random forest
(1 Question)
- Q1. ML Ops related questions
Selected
I appeared for an interview before Apr 2024, where I was asked the following questions.
- Q1. What id primary key
- Q2. What is view
Automatic Data Processing (ADP) Interview FAQs
Tell us how to improve this page.
Automatic Data Processing (ADP) Interviews By Designations
- Automatic Data Processing (ADP) Member Technical Interview Questions
- Automatic Data Processing (ADP) Senior Member Technical Interview Questions
- Automatic Data Processing (ADP) Senior Process Associate Interview Questions
- Automatic Data Processing (ADP) Process Associate Interview Questions
- Automatic Data Processing (ADP) Consultant Interview Questions
- Automatic Data Processing (ADP) Analyst Interview Questions
- Automatic Data Processing (ADP) Business Analyst Interview Questions
- Automatic Data Processing (ADP) Member Technical Staff Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
Automatic Data Processing (ADP) ETL Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Member Technical
1.6k
salaries
|  ₹8.2 L/yr - ₹22.6 L/yr |
|
Analyst
1.4k
salaries
| ₹5 L/yr - ₹11 L/yr |
|
Senior Process Associate
1.4k
salaries
| ₹3.4 L/yr - ₹7 L/yr |
|
Consultant
1.4k
salaries
| ₹19 L/yr - ₹32.6 L/yr |
|
Member Technical
927
salaries
| ₹4.8 L/yr - ₹10 L/yr |
Oracle
Amdocs
Carelon Global Solutions
KPIT Technologies
- Home >
- Interviews >
- Automatic Data Processing (ADP) Interview Questions
