Upload Button Icon Add office photos

Filter interviews by

Carelon Global Solutions ETL Developer Interview Questions and Answers

Updated 21 Sep 2023

Carelon Global Solutions ETL Developer Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 21 Sep 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(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

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare thoroughly

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

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 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
5
Excellent
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Aptitude Test 

30min duration simple questions

Round 2 - Coding Test 

Basic array 2 coding questions

Round 3 - Technical 

(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
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
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Coding Test 

Basic DSA from the hacker rank website

Round 2 - Technical 

(1 Question)

  • Q1. Basic to medium questions on javascript, nodejs, MySQL joints, html5 tags
Round 3 - Technical 

(1 Question)

  • Q1. Real life problems, Use cases

Interview Preparation Tips

Interview preparation tips for other job seekers - I have applied for Full stack developer role. Be strong at real time implementations and use cases
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
-
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

Carelon Global Solutions Interview FAQs

How many rounds are there in Carelon Global Solutions ETL Developer interview?
Carelon Global Solutions interview process usually has 2 rounds. The most common rounds in the Carelon Global Solutions interview process are Resume Shortlist and Technical.
What are the top questions asked in Carelon Global Solutions ETL Developer interview?

Some of the top questions asked at the Carelon Global Solutions ETL Developer interview -

  1. Explain use of loo...read more
  2. Type of lookup transformat...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Carelon Global Solutions interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Carelon Global Solutions ETL Developer Salary
based on 21 salaries
₹4 L/yr - ₹8.2 L/yr
32% less than the average ETL Developer Salary in India
View more details

Carelon Global Solutions ETL Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

4.0

Skill development

4.0

Work-Life balance

4.0

Salary & Benefits

4.0

Job Security

5.0

Company culture

5.0

Promotions/Appraisal

4.0

Work Satisfaction

Explore 1 Review and Rating
Senior Software Engineer
3.3k salaries
unlock blur

₹9.2 L/yr - ₹28 L/yr

Software Engineer
3.2k salaries
unlock blur

₹5 L/yr - ₹18.1 L/yr

Claims Associate
2.3k salaries
unlock blur

₹1.5 L/yr - ₹4.8 L/yr

Associate Software Engineer
1.3k salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Associate
997 salaries
unlock blur

₹2 L/yr - ₹6.1 L/yr

Explore more salaries
Compare Carelon Global Solutions with

Infosys

3.7
Compare

TCS

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
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