Add office photos
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
Interview questions from similar companies
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
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?
- Q2. Because I want good growth in my career.
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Dec 2024. There were 2 interview rounds.
(2 Questions)
- Q1. What are joins in SQL, and what are the different types?
- Q2. What is the method to find the third highest salary in a dataset?
(2 Questions)
- Q1. How do you manage multiple clients simultaneously?
- Q2. How do you determine which issue to prioritize when faced with multiple problems?
I was interviewed in Dec 2024.
(7 Questions)
- Q1. Started with introduction
- Q2. Asked about projects
- Q3. Asked Architecture related questions and design pattern related questions
- Q4. If you have 1 million requests how will you manage that
- Ans.
I would use load balancing, caching, and scaling techniques to manage the 1 million requests.
Implement load balancing to distribute requests evenly across multiple servers.
Utilize caching to store frequently accessed data and reduce response times.
Scale horizontally by adding more servers to handle the increased load.
Optimize code and database queries to improve performance.
Monitor system performance and make adjustmen
- Q5. React vs SAP UI5
- Ans.
React is a popular JavaScript library for building user interfaces, while SAP UI5 is a framework for developing enterprise-ready web applications.
React is more flexible and widely used in the industry.
SAP UI5 is specifically designed for SAP applications and has built-in support for SAP technologies.
React has a larger community and ecosystem with more resources and libraries available.
SAP UI5 provides a consistent user...
- Q6. Node VS JAVA
- Ans.
Node.js is a runtime environment for executing JavaScript code outside of a browser, while Java is a general-purpose programming language often used for building enterprise applications.
Node.js is single-threaded and event-driven, making it ideal for handling asynchronous operations like I/O operations.
Java is a statically typed language with a strong emphasis on object-oriented programming, making it suitable for larg...
- Q7. Multitenancy in sap btp
- Ans.
Multitenancy in SAP BTP allows multiple customers to share the same application instance while keeping their data isolated.
Multitenancy allows multiple customers (tenants) to use the same application instance.
Each tenant's data is isolated and secure from other tenants.
Tenants can customize their own settings, branding, and configurations within the shared application.
SAP BTP provides tools and features to manage multi...
Arrays and strings - 90 mins
Create Modules, railway reservation system - 60 mins
(5 Questions)
- Q1. Difference between hashmap and hasptable
- Q2. Why typescript over javascript
- Q3. Find the percentage of increace in the quantity of item after making it price 20% extra
- Q4. What is normalization
- Q5. Date and time api available
Software Developer Interview Questions & Answers
KPIT Technologies
Somashanker gudapati
posted on 3 Dec 2024
30min duration simple questions
Basic array 2 coding questions
(5 Questions)
- Q1. Introduce yorself
- Q2. Explain about final year project
- Q3. Github link for project
- Q4. What is oops in java
- Q5. What is polymorphism explain with examples
Parth Akre
Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 3 interview rounds.
It was an amazing interview.
S abJDQdlqd qk; qdkq;q bdkq;d
(5 Questions)
- Q1. Dbjas xjhqvUGQJQ mnq
- Q2. Add qbnjq j qj slx qx
- Q3. DaD JDQ d KNX ax sqkd
- Q4. Bj q dsa k xkqs xkna ;x
- Q5. DJ m qd s Jhdvaljcbaf
Software Developer Interview Questions & Answers
OpenText Technologies
Anonymous
posted on 11 Dec 2024
I applied via LinkedIn and was interviewed in Nov 2024. There were 3 interview rounds.
Basic DSA from the hacker rank website
(1 Question)
- Q1. Basic to medium questions on javascript, nodejs, MySQL joints, html5 tags
(1 Question)
- Q1. Real life problems, Use cases
Interview Preparation Tips
Software Developer Interview Questions & Answers
Microsoft Corporation
Anonymous
posted on 1 Jan 2025
LeetCode , hard questions on dynamic programming, graphs, and more.
DSA, Cn, os, DBMS, ML
(2 Questions)
- Q1. Is relocation a possibility for this position?
- Q2. Senior role is there
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) Analyst Interview Questions
- Automatic Data Processing (ADP) Consultant Interview Questions
- Automatic Data Processing (ADP) Business Analyst Interview Questions
- Automatic Data Processing (ADP) Software Engineer 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
Automatic Data Processing (ADP) ETL Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Member Technical
1.6k
salaries
|  ₹7 L/yr - ₹21.4 L/yr |
|
Senior Process Associate
1.4k
salaries
| ₹2 L/yr - ₹8.2 L/yr |
|
Analyst
1.3k
salaries
| ₹3.4 L/yr - ₹10.5 L/yr |
|
Consultant
1.2k
salaries
| ₹10 L/yr - ₹40 L/yr |
|
Member Technical
883
salaries
| ₹3.5 L/yr - ₹12 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Automatic Data Processing (ADP) Interview Questions >
- Automatic Data Processing (ADP) ETL Developer Interview Questions
