Premium Employer

i

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

Franklin Templeton Investments Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Franklin Templeton Investments Oracle SQL and PLSQL Developer Interview Questions and Answers

Updated 27 Feb 2024

Franklin Templeton Investments Oracle SQL and PLSQL Developer Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain about the joins and differences between the inner join and left join
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them.

    • Inner join returns only the rows that have matching values in both tables

    • Left join returns all the rows from the left table and the matched rows from the right table

    • Inner join is more restrictive as it requires a match in both tables, while left join is less restrictive

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1....

  • Answered by AI
  • Q2. What is your contribution in your current project

Interview Preparation Tips

Interview preparation tips for other job seekers - They have asked questions on the joins.
Data modeling questions and ETL concepts

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Mcq questions, create proc for displaying collection values, write func to show values.
Round 2 - Technical 

(2 Questions)

  • Q1. Difference between primary key and unique key. Questions based on unique key and composite key. Write function to return multiple values. Sql queries to print values, update statement to update multiple ro...
  • Q2. Performance tuning questions related to hints.

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure you read about collections. They mostly work on collections and focus on basics for interview. Smallest details are asked.
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Referral and was interviewed in Nov 2023. There were 4 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Mssql and SSRS related questions.
Round 2 - Technical 

(1 Question)

  • Q1. Managerial Round.
Round 3 - HR 

(1 Question)

  • Q1. HR Discussion 1
Round 4 - HR 

(1 Question)

  • Q1. HR Discussion 2

Interview Preparation Tips

Interview preparation tips for other job seekers - Unfortunate Experience in the Recruitment Process with Intertrust Group.

I am writing to share my disappointment regarding my recent experience with the recruitment process at Intertrust Group. I recently underwent four rounds of interviews with your team, during which I was informed that I had successfully cleared the process and was selected for the position.

However, I am disheartened to report that despite submitting the requested documents, I have not received the promised offer letter. This situation has been particularly frustrating, compounded by the fact that my attempts to reach out to the HR department have gone unanswered for the past two weeks.

During the interview process, I was reassured that I need not explore other job opportunities, which I took to heart. Unfortunately, the subsequent lack of communication and the ultimate rejection of my candidature have left me bewildered and questioning the transparency of the recruitment process.

Moreover, I have found the inconsistency in the reasons provided for not moving forward with my application perplexing. On one occasion, I was informed that senior management was not ready, and on another, I was told that my experience was deemed insufficient, paired with a comment on the perceived high package. These concerns raise questions about the thoroughness of the initial assessment before scheduling the interviews.

I believe that open and clear communication is essential in any professional setting, especially during the hiring process. It is disconcerting to note that the HR department appears to be unaware of company policies and lacks a concrete explanation for the decision to retract the offer. Additionally, it is surprising to encounter a discrepancy in the understanding of market value, especially in terms of compensation, which seems to be based on outdated figures.

Please don't invest too much time and simultaneously look for other opportunities as there is no guarantee that you will get an offer letter.
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Referral and was interviewed in Nov 2023. There were 4 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Sql and SSRS questions.
Round 2 - Technical 

(1 Question)

  • Q1. Managerial Round.
Round 3 - HR 

(1 Question)

  • Q1. HR Discussion 1
Round 4 - HR 

(1 Question)

  • Q1. HR Discussion 2

Interview Preparation Tips

Interview preparation tips for other job seekers - Unfortunate Experience in the Recruitment Process with Intertrust Group.

I am writing to share my disappointment regarding my recent experience with the recruitment process at CSC Group. I recently underwent four rounds of interviews with CSC, during which I was informed that I had successfully cleared the process and was selected for the position.

However, I am disheartened to report that despite submitting the requested documents, I have not received the promised offer letter. This situation has been particularly frustrating, compounded by the fact that my attempts to reach out to the HR department have gone unanswered for the past two weeks.

During the interview process, I was reassured that I need not explore other job opportunities, which I took to heart. Unfortunately, the subsequent lack of communication and the ultimate rejection of my candidature have left me bewildered and questioning the transparency of the recruitment process.

Moreover, I have found the inconsistency in the reasons provided for not moving forward with my application perplexing. On one occasion, I was informed that senior management was not ready, and on another, I was told that my experience was deemed insufficient, paired with a comment on the perceived high package. These concerns raise questions about the thoroughness of the initial assessment before scheduling the interviews.

I believe that open and clear communication is essential in any professional setting, especially during the hiring process. It is disconcerting to note that the HR department appears to be unaware of company policies and lacks a concrete explanation for the decision to retract the offer. Additionally, it is surprising to encounter a discrepancy in the understanding of market value, especially in terms of compensation, which seems to be based on outdated figures.

Please don't invest too much time and simultaneously look for other opportunities as there is no guarantee that you will get an offer letter.

I applied via Company Website and was interviewed in Apr 2022. There was 1 interview round.

Round 1 - Technical 

(6 Questions)

  • Q1. How many years of experience
  • Q2. Which company your working and company name
  • Q3. Which location your prefer
  • Q4. What is your email id
  • Ans. 

    I cannot disclose my personal email id for privacy reasons.

    • I prefer to communicate through official channels provided by the company.

    • Sharing personal email id can lead to security risks.

    • I can provide an alternate email id for official communication.

  • Answered by AI
  • Q5. What is your phone number
  • Q6. Is it permanent company are paraeel company

Interview Preparation Tips

Topics to prepare for CSC Global SQL Developer interview:
  • SQL
  • SSIS
  • SSRS
Interview preparation tips for other job seekers - Iam comfortable morning shifts

Franklin Templeton Investments Interview FAQs

How many rounds are there in Franklin Templeton Investments Oracle SQL and PLSQL Developer interview?
Franklin Templeton Investments interview process usually has 1 rounds. The most common rounds in the Franklin Templeton Investments interview process are One-on-one Round.

Tell us how to improve this page.

Franklin Templeton Investments Oracle SQL and PLSQL Developer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Franklin Templeton Investments Join us and say hello to progress. Yours and ours.

Interview Questions from Similar Companies

Goldman Sachs Interview Questions
3.5
 • 408 Interviews
Morgan Stanley Interview Questions
3.7
 • 308 Interviews
Morningstar Interview Questions
3.9
 • 241 Interviews
FactSet Interview Questions
3.9
 • 208 Interviews
Apex Group Interview Questions
2.7
 • 132 Interviews
Kotak Securities Interview Questions
3.6
 • 116 Interviews
Blackrock Interview Questions
3.8
 • 100 Interviews
Mr Cooper Interview Questions
4.1
 • 81 Interviews
View all
Senior Analyst
168 salaries
unlock blur

₹3.6 L/yr - ₹12.3 L/yr

Analyst
164 salaries
unlock blur

₹2.8 L/yr - ₹10.5 L/yr

Assistant Manager
134 salaries
unlock blur

₹5.7 L/yr - ₹24 L/yr

Software Engineer
109 salaries
unlock blur

₹8 L/yr - ₹23 L/yr

Treasury Analyst
85 salaries
unlock blur

₹2.4 L/yr - ₹6 L/yr

Explore more salaries
Compare Franklin Templeton Investments with

Blackrock

3.8
Compare

Vanguard

4.1
Compare

Fidelity Investments

4.2
Compare

State Street Global Advisors

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