Upload Button Icon Add office photos
Engaged Employer

i

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

CitiusTech Verified Tick

Compare button icon Compare button icon Compare
3.4

based on 1.6k Reviews

Filter interviews by

CitiusTech ETL Developer Interview Questions and Answers

Updated 12 Jun 2024

CitiusTech ETL Developer Interview Experiences

2 interviews found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 27 Apr 2024

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

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 12 Jun 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Few questions about powercenter

ETL Developer Interview Questions Asked at Other Companies

asked in Ciber
Q1. What are the content of APT_CONFIG_FILE? Can you brief on the rel ... read more
asked in Ciber
Q2. What is RCP? In What scenario you have used this in your project?
Q3. What is trigger . Do Implementation of types of trigger?
asked in Ciber
Q4. What are the methods available in Aggregator stage?
Q5. How will you run 300 SPs sequential n parallel in SQL server

Interview questions from similar companies

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
-
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
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Shine and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Normal coding round with simple oa complexity

Round 2 - One-on-one 

(2 Questions)

  • Q1. Discussion on projects
  • Q2. Culture fit check

Interview Preparation Tips

Interview preparation tips for other job seekers - go thru projects and problem solving
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Coding Test 

DSA questions and programming concepts

Round 2 - Technical 

(2 Questions)

  • Q1. Reverse string and optimize it
  • Ans. 

    Reverse array of strings efficiently

    • Use two pointers approach to swap characters from start and end of each string

    • Optimize by using in-place reversal instead of creating new strings

    • Consider edge cases like empty strings or strings with only one character

  • Answered by AI
  • Q2. Reverse binary tree
Round 3 - HR 

(2 Questions)

  • Q1. Salary expectations
  • Q2. Joining location
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
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 - Coding Test 

Asked some basic level questions

Round 2 - Coding Test 

Asked little bit hard questions

Round 3 - Coding Test 

Asked depth questions and wrote some sample programs

Round 4 - Technical 

(1 Question)

  • Q1. Wrote some sample program
Round 5 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-

I applied via Referral

Round 1 - Technical 

(1 Question)

  • Q1. Basic core Java question.

CitiusTech Interview FAQs

How many rounds are there in CitiusTech ETL Developer interview?
CitiusTech interview process usually has 1 rounds. The most common rounds in the CitiusTech interview process are Technical.
How to prepare for CitiusTech 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 CitiusTech. The most common topics and skills that interviewers at CitiusTech expect are ETL, AWS, Adf, Bpm and SQL.
What are the top questions asked in CitiusTech ETL Developer interview?

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

  1. and some sql queries and questi...read more
  2. Few questions about powercen...read more

Tell us how to improve this page.

CitiusTech ETL Developer Interview Process

based on 2 interviews

Interview experience

2.5
  
Poor
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.7
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Mphasis Interview Questions
3.4
 • 797 Interviews
View all
CitiusTech ETL Developer Salary
based on 8 salaries
₹4 L/yr - ₹6 L/yr
15% less than the average ETL Developer Salary in India
View more details

CitiusTech ETL Developer Reviews and Ratings

based on 3 reviews

2.1/5

Rating in categories

2.7

Skill development

1.9

Work-life balance

1.9

Salary

2.7

Job security

2.4

Company culture

1.6

Promotions

2.1

Work satisfaction

Explore 3 Reviews and Ratings
Senior Software Engineer
2.6k salaries
unlock blur

₹5.8 L/yr - ₹20 L/yr

Technical Lead
2.1k salaries
unlock blur

₹7.3 L/yr - ₹27.4 L/yr

Software Engineer
1.2k salaries
unlock blur

₹3.3 L/yr - ₹11.2 L/yr

Technical Lead 1
361 salaries
unlock blur

₹7 L/yr - ₹25.4 L/yr

Technical Lead 2
289 salaries
unlock blur

₹8.5 L/yr - ₹28 L/yr

Explore more salaries
Compare CitiusTech with

Accenture

3.9
Compare

Capgemini

3.8
Compare

TCS

3.7
Compare

Wipro

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