Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Amdocs Team. If you also belong to the team, you can get access from here

Amdocs Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 3.8k Reviews

Filter interviews by

Amdocs ETL Developer Interview Questions and Answers

Updated 12 Nov 2019

Amdocs ETL Developer Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 12 Nov 2019

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

Interview preparation tips for other job seekers - Do study well representation is very important confidence and technical skills

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical 

(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 ...

  • Answered by AI
  • 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.

  • Answered by AI
  • 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.

  • Answered by AI
  • Q4. Max sal of an employee

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Naukri.com and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

25 questions on coding output and 5 questions on aptitude

Round 2 - Coding Test 

DSA problems on arrays and strings easy to medium level

Round 3 - One-on-one 

(3 Questions)

  • Q1. Develop a live streaming application
  • Ans. 

    Develop a live streaming application for real-time video broadcasting

    • Use a reliable streaming protocol like RTMP or HLS

    • Implement a video encoder to compress and transmit video data

    • Set up a media server to handle incoming video streams

    • Develop a user interface for viewers to watch live streams

    • Incorporate features like chat, likes, and notifications for user engagement

  • Answered by AI
  • Q2. Questions on Resume
  • Q3. What is your interested technically
Round 4 - HR 

(2 Questions)

  • Q1. Family background
  • Q2. Salary expectations

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for DSA on your resume and networking, DBMS and OS concepts.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement

Round 1 - Aptitude Test 

Question related to operating system and computer network

Round 2 - Technical 

(1 Question)

  • Q1. Traverse all child nodes in tree
Round 3 - Technical 

(1 Question)

  • Q1. Question related to cloud and oops
Round 4 - Technical 

(1 Question)

  • Q1. Question related to my background and how web site work
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Coding Test 

It was an amazing interview.

Round 2 - Assignment 

S abJDQdlqd qk; qdkq;q bdkq;d

Round 3 - One-on-one 

(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
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jul 2024. There were 5 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Features of new Java versions?
  • Ans. 

    New Java versions introduce various features and improvements for developers.

    • Java 8 introduced lambda expressions and the Stream API for functional programming.

    • Java 9 added the module system to improve code organization and security.

    • Java 10 included local variable type inference for cleaner code.

    • Java 11 introduced the HttpClient API for easier HTTP communication.

    • Java 12 added switch expressions for more concise code.

    • Ja...

  • Answered by AI
  • Q2. Hash map, hashing and internal working of collision handling
Round 2 - Technical 

(2 Questions)

  • Q1. Lru cache and its implementation in java
  • Ans. 

    LRU cache is a data structure that stores the most recently used items, discarding the least recently used items when full.

    • Use a LinkedHashMap to implement LRU cache in Java

    • Override removeEldestEntry method to limit the size of the cache

    • Accessing an element updates its position in the cache

  • Answered by AI
  • Q2. In depth discussion on basic of java
Round 3 - Behavioral 

(2 Questions)

  • Q1. Why sap and what if we offer less compensation
  • Ans. 

    I chose SAP because of its industry-leading reputation and comprehensive suite of solutions. If offered less compensation, I would consider the overall growth opportunities and work-life balance.

    • SAP is a widely used enterprise software with a strong market presence

    • SAP offers a wide range of solutions for various industries, providing valuable experience and skill development

    • Consider the overall growth opportunities, wo...

  • Answered by AI
  • Q2. About current project and ways you would make it better
Round 4 - Cross LOB 

(2 Questions)

  • Q1. Implement stack using other data structures
  • Ans. 

    Implement stack using array or linked list

    • Use an array or linked list to store elements in the stack

    • Implement push() and pop() functions to add and remove elements from the stack

    • Maintain a pointer to keep track of the top element in the stack

  • Answered by AI
  • Q2. Current project and what technology you are using
Round 5 - HR 

(2 Questions)

  • Q1. What motivates you to join sap
  • Ans. 

    I am motivated to join SAP because of their reputation for innovation, global impact, and opportunities for growth.

    • SAP is a global leader in enterprise software solutions, offering cutting-edge technology and opportunities to work on impactful projects.

    • I am excited about the chance to work with a diverse team of talented individuals and learn from industry experts.

    • SAP's commitment to innovation and continuous learning ...

  • Answered by AI
  • Q2. What is your top priority while choosing new job
  • Ans. 

    My top priority while choosing a new job is growth opportunities and a positive work culture.

    • Opportunities for career advancement and skill development

    • Positive work environment and company culture

    • Alignment with personal values and goals

    • Competitive compensation and benefits

    • Work-life balance

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Coding Test 

In first round 4 coding question like 1 dsa 2 database and one is api and question is very simple . coding round was conducted in hackerrank

Round 2 - Technical 

(2 Questions)

  • Q1. DSA QUESTION LIKE TREE AND GRAPH
  • Q2. DP AND SORTING APPROACH
Round 3 - Coding Test 

Again same but dsa question and oops concept in deep level

Interview Preparation Tips

Interview preparation tips for other job seekers - good knowledge in dsa , database , programming thats it
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

LeetCode , hard questions on dynamic programming, graphs, and more.

Round 2 - Coding Test 

DSA, Cn, os, DBMS, ML

Round 3 - One-on-one 

(2 Questions)

  • Q1. Is relocation a possibility for this position?
  • Q2. Senior role is there
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
-

I applied via Campus Placement and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Bubble sort and array was given
  • Q2. Create binary tree
  • Ans. 

    A binary tree is a data structure where each node has at most two children.

    • Start by creating a Node class with left and right child pointers.

    • Implement methods to insert, search, and delete nodes in the tree.

    • Consider different traversal methods like inorder, preorder, and postorder.

  • Answered by AI
  • Q3. HightBuilding Pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - just go through strivers videos

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Coding Test 

2medium level questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. Project discussion for 30 mins
  • Q2. Dsa problem medium level

Amdocs Interview FAQs

How to prepare for Amdocs ETL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Amdocs. The most common topics and skills that interviewers at Amdocs expect are Ab Initio, Amdocs, Application Software, Computer science and Continuous Improvement.

Tell us how to improve this page.

People are getting interviews through

based on 1 Amdocs interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Amdocs ETL Developer Salary
based on 119 salaries
₹5.2 L/yr - ₹17 L/yr
57% more than the average ETL Developer Salary in India
View more details

Amdocs ETL Developer Reviews and Ratings

based on 19 reviews

4.3/5

Rating in categories

3.8

Skill development

3.5

Work-Life balance

3.6

Salary & Benefits

4.0

Job Security

3.9

Company culture

3.2

Promotions/Appraisal

3.8

Work Satisfaction

Explore 19 Reviews and Ratings
Software Developer
7.6k salaries
unlock blur

₹5 L/yr - ₹16.6 L/yr

Software Engineer
1.9k salaries
unlock blur

₹4 L/yr - ₹16 L/yr

Softwaretest Engineer
1.7k salaries
unlock blur

₹3 L/yr - ₹12 L/yr

Functional Test Engineer
1.2k salaries
unlock blur

₹4 L/yr - ₹12.1 L/yr

Associate Software Engineer
1k salaries
unlock blur

₹3.2 L/yr - ₹12 L/yr

Explore more salaries
Compare Amdocs with

TCS

3.7
Compare

IBM

4.1
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview