Upload Button Icon Add office photos

Filter interviews by

Ciber ETL Developer Interview Questions, Process, and Tips

Updated 12 Sep 2020

Ciber ETL Developer Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Amirthaprakash C

posted on 12 Sep 2020

Interview Questionnaire 

4 Questions

  • Q1. What is RCP? In What scenario you have used this in your project?
  • Ans. 

    RCP stands for Rich Client Platform. It is a framework used for developing desktop applications.

    • RCP is based on Eclipse platform and provides a set of reusable components for building desktop applications.

    • It provides a modular architecture that allows developers to easily add or remove features.

    • RCP applications can be customized using plug-ins and extensions.

    • I have used RCP in a project where we needed to develop a des...

  • Answered by AI
  • Q2. What are the content of APT_CONFIG_FILE? Can you brief on the relationship between APT_CONFIG_FILE and Partition.
  • Ans. 

    APT_CONFIG_FILE is a configuration file used by Advanced Package Tool (APT) to manage packages in Linux.

    • APT_CONFIG_FILE contains settings for APT such as proxy settings, package sources, and authentication credentials.

    • Partition refers to dividing a hard drive into separate sections for different purposes.

    • APT_CONFIG_FILE can be used to specify package sources for specific partitions.

    • For example, if a user has a separate...

  • Answered by AI
  • Q3. What are the methods available in Aggregator stage?
  • Ans. 

    Aggregator stage methods include count, sum, average, min, max, first, last, and concatenate.

    • Count: counts the number of input rows

    • Sum: calculates the sum of a specified column

    • Average: calculates the average of a specified column

    • Min: finds the minimum value of a specified column

    • Max: finds the maximum value of a specified column

    • First: returns the first row of the input

    • Last: returns the last row of the input

    • Concatenate:

  • Answered by AI
  • Q4. Whats the prerequisites to use sort method in aggregator stage.
  • Ans. 

    The prerequisites to use sort method in aggregator stage.

    • The input data must be sorted by the same key as the one used in the aggregator stage.

    • The input data must be partitioned by the same key as the one used in the aggregator stage.

    • The sort method should be used before the aggregator stage in the data flow.

    • The sort method should be used only if the data is too large to fit in memory.

    • The sort method can be used with b

  • Answered by AI

Skills evaluated in this interview

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 Mar 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Tell me about ur self
  • Q2. And some sql queries and questions

Interview Preparation Tips

Interview preparation tips for other job seekers - They informed me through call that i cleared first round . but no further response from them .for follow up also no reply ..citiustech Pune
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Aptitude Test 

Logical reasoning, grammar, and coding: two basic level questions.

Round 2 - Technical 

(3 Questions)

  • Q1. Question on core Java
  • Q2. Question on SQL and PLSQL
  • Q3. Resume based question and on project
Round 3 - HR 

(2 Questions)

  • Q1. Resume and project based question
  • Q2. What do you like about your current company, and why do you want to join our organization?
  • Ans. 

    I appreciate the collaborative team environment and innovative projects at my current company, and I am excited about the opportunities for growth and learning at your organization.

    • Collaborative team environment fosters creativity and productivity

    • Innovative projects challenge me to learn and grow

    • Excited about the opportunities for growth and learning at your organization

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Coding Test 

Coding round is related to DSA

Round 2 - Technical 

(2 Questions)

  • Q1. Java related questions
  • Q2. Explain about your project
Round 3 - HR 

(2 Questions)

  • Q1. Salary negotiation
  • Q2. Why you want to join us?
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Basic Java Question
  • Q2. Spring Boot related questions
Round 2 - One-on-one 

(2 Questions)

  • Q1. Design a rest API and code it.
  • Ans. 

    Design and code a REST API for a software developer interview.

    • Define the endpoints and HTTP methods for the API (e.g. GET /users, POST /users)

    • Implement authentication and authorization mechanisms (e.g. JWT tokens)

    • Use proper status codes for responses (e.g. 200 OK, 401 Unauthorized)

    • Include error handling and validation for input data

    • Document the API using tools like Swagger or OpenAPI

  • Answered by AI
  • Q2. Questions related to JPA HIBERNATE SQL
Round 3 - One-on-one 

(2 Questions)

  • Q1. Discussion related to Last company Project and architecture level questions
  • Q2. Write code to calculate frequency of a word using Stream API and lambda expressions
  • Ans. 

    Calculate word frequency using Stream API and lambda expressions

    • Use Stream API to convert array of strings to stream

    • Use Collectors.groupingBy to group words by their frequency

    • Use Collectors.counting to count the occurrences of each word

  • Answered by AI

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic of java to advanced
  • Q2. Array related questions
Round 2 - Technical 

(2 Questions)

  • Q1. Architecture related
  • Q2. Management roles
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. Questions on spring boot and question around spring annotations and its benifits
  • Q2. Questions on Java 8 - 21 versions such as virtual threads and stream API
  • Q3. Question on Databases fundamentals.

Interview Preparation Tips

Interview preparation tips for other job seekers - The process was simple and crisp
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-

I applied via Referral

Round 1 - Technical 

(1 Question)

  • Q1. Basic core Java question.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hackerrank coding round.

Round 2 - Technical 

(1 Question)

  • Q1. Questions and coding testing your OOPS knowledge
Round 3 - Technical 

(1 Question)

  • Q1. Every tech stack, SQL, OOPS, JAVA

Interview Preparation Tips

Interview preparation tips for other job seekers - Be familiar with designing and writing better code follwing OOPS, YAGNI,DRY principles.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Related to project?
  • Q2. Java related question especially on 1.8 and streams

Ciber Interview FAQs

What are the top questions asked in Ciber ETL Developer interview?

Some of the top questions asked at the Ciber ETL Developer interview -

  1. What are the content of APT_CONFIG_FILE? Can you brief on the relationship betw...read more
  2. What is RCP? In What scenario you have used this in your projec...read more
  3. What are the methods available in Aggregator stag...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

CitiusTech Interview Questions
3.4
 • 266 Interviews
Altimetrik Interview Questions
3.8
 • 211 Interviews
Xoriant Interview Questions
4.2
 • 180 Interviews
ThoughtWorks Interview Questions
3.9
 • 145 Interviews
Brillio Interview Questions
3.5
 • 128 Interviews
TEKsystems Interview Questions
3.4
 • 115 Interviews
Prodapt Interview Questions
3.6
 • 98 Interviews
View all
Senior Consultant
68 salaries
unlock blur

₹8.6 L/yr - ₹19 L/yr

Principal Consultant
55 salaries
unlock blur

₹8.9 L/yr - ₹22.4 L/yr

Consultant
32 salaries
unlock blur

₹3.6 L/yr - ₹13 L/yr

Software Engineer
19 salaries
unlock blur

₹3.8 L/yr - ₹10 L/yr

Senior Engineer
15 salaries
unlock blur

₹9 L/yr - ₹20 L/yr

Explore more salaries
Compare Ciber with

CitiusTech

3.4
Compare

Bounteous x Accolite

3.5
Compare

Altimetrik

3.8
Compare

Xoriant

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview