Upload Button Icon Add office photos
Engaged Employer

i

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

Ocwen Financial Solutions Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Ocwen Financial Solutions ETL Test Engineer Interview Questions and Answers

Updated 30 Jun 2022

Ocwen Financial Solutions ETL Test Engineer Interview Experiences

1 interview found

I applied via Campus Placement and was interviewed in May 2022. 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 

(1 Question)

  • Q1. What are the joints and what are those and tell me briefly

Interview Preparation Tips

Interview preparation tips for other job seekers - Market yourself, job search like it's your job...
Know yourself what you whant...

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Mar 2021. There were 3 interview rounds.

Round 1 - Coding Test 

2 moderate data structure problems

Round 2 - Technical 

(2 Questions)

  • Q1. Write the code for Fibonacci series
  • Ans. 

    Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.

    • Declare variables for first two numbers of the series

    • Use a loop to generate the series by adding the previous two numbers

    • Store the series in an array or print each number as it is generated

  • Answered by AI
  • Q2. Write a SQL joining two tables on a key column
  • Ans. 

    Join two tables on a key column using SQL

    • Use the JOIN keyword followed by the name of the second table

    • Specify the key column in both tables using the ON keyword

    • Choose the type of join (INNER, LEFT, RIGHT, FULL) based on your requirement

  • Answered by AI
Round 3 - HR 

(6 Questions)

  • Q1. What are your strengths and weaknesses?
  • Q2. What are your salary expectations?
  • Q3. What is your family background?
  • Q4. Why should we hire you?
  • Q5. Where do you see yourself in 5 years?
  • Q6. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be good at OOPS concepts.
Data structures is required only to clear the initial coding round.
SQL knowledge is essential for the interview.

Skills evaluated in this interview

Interview Preparation Tips

Round: Test
Experience: 7 CGPA cut off, The First round was an Aptitude test (quant+DI+verbal ) 20 questions + 10 basic C/C+ questions
Total Questions: 30

Round: Other Interview
Experience: Second Stage: 2 rounds Tech interview + 1 HR, Very casual personal interview with questions based on resume onlyNo core coding questions since I was from ECE but for Comps/IT they expect knowledge in DBMS.Some finance questions like what are stocks/shares, mutual funds etc. I was asked more detailed finance questions also since I had mentioned my finance interns.

Skill Tips: Be thorough with apti tests . Past CAT papers are ideal as they cover all aspects  (quant+Data Interpretation +Logical reasoning +verbal ) For learning finance jargon use Economist A-Z list and Investopedia
Skills: quant, Data Interpretation , Logical reasoning
College Name: NIT SURATHKAL

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
Experience: Practice questions on Indiabix.

Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

I applied via Naukri.com and was interviewed in May 2019. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Related debugging, views, scripting, control_m schedule related & Aws basic concepts and real time issues

Interview Preparation Tips

Interview preparation tips for other job seekers - We should be very carefully while answering the question because with in that answer again they will ask one more question.

And be confident

I applied via Company Website and was interviewed before Sep 2019. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Whatever mentioned on resume , data structure must (hackerrank coding round mainly on Tree)
  • Q2. Tree traversal implementation , string based question , 2-d array

Interview Preparation Tips

Interview preparation tips for other job seekers - Tree question in hackerrank must , prepare well whatever mentioned in your resume

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. Explain SCD Type 2 Implementation in Informatica
  • Ans. 

    SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

    • SCD Type 2 maintains a separate row for each change in data, with a start and end date.

    • It requires a surrogate key to uniquely identify each row.

    • Informatica provides a built-in SCD Type 2 transformation to implement this technique.

    • Example: tracking changes in customer addresses over time.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Kindly focus on basic BI terminologies, common to trivial scenarios and introductory information on latest trending tools and technologies.

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be 100% technical in java here they will not be any support u need to dig deep lot of complex modules which we cannot understand in depth

I applied via LinkedIn and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All microsoft technologies related

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

I applied via Campus Placement and was interviewed before Sep 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Few DSA questions, questions about my projects and my resume. Also, since I specialise in python, if I could create an API using it. HR questions, hobbies, leadership experience...

Interview Preparation Tips

Interview preparation tips for other job seekers - Understanding the culture of J.P. Morgan Chase played a big role in passing the interview. The coding questions were easy/medium level. The interviewers were very friendly.

Ocwen Financial Solutions Interview FAQs

How many rounds are there in Ocwen Financial Solutions ETL Test Engineer interview?
Ocwen Financial Solutions interview process usually has 2 rounds. The most common rounds in the Ocwen Financial Solutions interview process are Resume Shortlist and Technical.

Tell us how to improve this page.

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 575 Interviews
Citicorp Interview Questions
3.7
 • 573 Interviews
American Express Interview Questions
4.2
 • 365 Interviews
UBS Interview Questions
3.9
 • 338 Interviews
Morgan Stanley Interview Questions
3.6
 • 293 Interviews
Morningstar Interview Questions
3.9
 • 244 Interviews
BNP Paribas Interview Questions
3.8
 • 180 Interviews
View all
Ocwen Financial Solutions ETL Test Engineer Salary
based on 4 salaries
₹4.2 L/yr - ₹8.5 L/yr
9% more than the average ETL Test Engineer Salary in India
View more details
Specialist
263 salaries
unlock blur

₹2.5 L/yr - ₹7 L/yr

Senior Specialist
251 salaries
unlock blur

₹3.8 L/yr - ₹8.5 L/yr

Associate
215 salaries
unlock blur

₹1.9 L/yr - ₹5.3 L/yr

Team Lead
174 salaries
unlock blur

₹5.2 L/yr - ₹20 L/yr

Assistant Manager
173 salaries
unlock blur

₹8.5 L/yr - ₹25 L/yr

Explore more salaries
Compare Ocwen Financial Solutions with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

Citicorp

3.7
Compare

American Express

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