Upload Button Icon Add office photos
Engaged Employer

i

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

Wipro Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Wipro Informatica Developer Interview Questions and Answers for Experienced

Updated 14 Oct 2023

Wipro Informatica Developer Interview Experiences for Experienced

2 interviews found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Indeed and was interviewed before Oct 2022. There were 3 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 

(4 Questions)

  • Q1. Sql/ data warehousing/ scenario based questions
  • Q2. Explain Daily work in detail
  • Q3. Google-informatica scenario based questions
  • Q4. Sql- 2nd highest or 3rd highest salary
  • Ans. 

    To find the 2nd or 3rd highest salary in SQL, use the 'ORDER BY' and 'LIMIT' clauses.

    • Use the 'ORDER BY' clause to sort the salaries in descending order.

    • Use the 'LIMIT' clause to specify the number of rows to return.

    • For 2nd highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1

    • For 3rd highest salary: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2,1

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Just focus on basic and take time to explain your daily work.

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed before Mar 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 

(2 Questions)

  • Q1. What is the difference between iics and power center
  • Ans. 

    IICS is a cloud-based integration platform while Power Center is an on-premise data integration tool.

    • IICS is a subscription-based service while Power Center is a perpetual license product.

    • IICS offers pre-built connectors to various cloud applications while Power Center requires custom coding for cloud integrations.

    • IICS has a web-based interface while Power Center has a desktop-based interface.

    • IICS offers real-time data...

  • Answered by AI
  • Q2. Why secure agent used
  • Ans. 

    Secure agent is used to securely transfer data between on-premises and cloud applications.

    • Secure agent provides a secure connection between on-premises and cloud applications.

    • It ensures data privacy and security during transfer.

    • It allows for data integration and synchronization across different systems.

    • Examples of applications that use secure agent include Salesforce, Workday, and SAP.

    • Secure agent also allows for sched

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare iics concepts,
What is secure agent and why it is

Skills evaluated in this interview

Informatica Developer Interview Questions Asked at Other Companies for undefined

asked in BNP Paribas
Q1. if we dont specify anything in group by aggregator what will happ ... read more
asked in Cognizant
Q2. 1. What is factless fact. 2. Star schema vs snowflake schema. And ... read more
asked in BNP Paribas
Q3. what kind of transformation is update strategy? explain
asked in Wipro
Q4. What is the difference between iics and power center
asked in Capgemini
Q5. Given 2 table A and B. Find count of left join, right join, inner ... read more

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SOLID principals, oops, c# basics, SQL server, azure, design pattern

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear basics of oops and design pattern

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. 1.Describe a situation where you have taken a quick decision and failed, and a situation where you succeeded. 2. What is a skill you have tried to achieve but failed? 3. Describe a decision you have taken ...

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Always try to take risk in small problems . When you face the consequences, you would be able to tackle bigger problems.
2. Every skill you learn, even if you didn't excel in it is not to be considered a waste of time/failure, you learn something simply by participating.

Interview Questionnaire 

1 Question

  • Q1. HTML, CSS, BOOTSTRAP, PHP. SQL

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Simple program
  • Q2. I wrote a simple program in C

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about Yourself, some questions related to machine learning, and I was asked more questions to differentiate like differences between ml and ai, python and c, c and java and procedural and functiona...

Interview Preparation Tips

Interview preparation tips for other job seekers - Get a complete grip on your resume and be confident about what you say, If you don't know the answer it is okay to agree that you don't know the answer so that interviewer can ask the next questions.

I was interviewed before Jun 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 180 minutes
Round difficulty - Easy

It was an mcq + coding round. There were aptitude and ouput based question in mcq. And coding questions were easy

  • Q1. 

    Find the Duplicate Number Problem Statement

    Given an integer array 'ARR' of size 'N' containing numbers from 0 to (N - 2). Each number appears at least once, and there is one number that appears twice. Yo...

  • Ans. 

    Find the duplicate number in an array of integers from 0 to (N-2).

    • Iterate through the array and keep track of the frequency of each number using a hashmap.

    • Return the number with a frequency greater than 1 as the duplicate number.

    • Time complexity can be optimized to O(N) using Floyd's Tortoise and Hare algorithm.

  • Answered by AI
  • Q2. 

    Reverse String Operations Problem Statement

    You are provided with a string S and an array of integers A of size M. Your task is to perform M operations on the string as specified by the indices in array A...

  • Ans. 

    Given a string and an array of indices, reverse substrings based on the indices to obtain the final string.

    • Iterate through the array of indices and reverse the substrings accordingly

    • Ensure the range specified by each index is non-empty

    • Return the final string after all operations are completed

  • Answered by AI
Round 2 - Video Call 

Round duration - 60 Minutes
Round difficulty - Easy

It was technical + hr round. there were 2 people as interviewer. They stated from intro and asked some basic puzzles and hr questions. After that they asked about my projects, technologies and some ds algo and dbms questions.

Interview Preparation Tips

Eligibility criterianaAccenture interview preparation:Topics to prepare for the interview - Data Structures, Pointers, OOPS, System Design, Algorithms, Dynamic ProgrammingTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice aptitude
Tip 2 : Focus on practicing coding
Tip 3 : Learn from mistakes

Application resume tips for other job seekers

Tip 1 : Mention some projects that you have done
Tip 2 : Try to have skills that are required for the role

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Oops Concepts,JAVA 8

Interview Preparation Tips

Interview preparation tips for other job seekers - Quite simple and easy. 1st round technical.2nd round HR

Wipro Interview FAQs

How many rounds are there in Wipro Informatica Developer interview for experienced candidates?
Wipro interview process for experienced candidates usually has 2-3 rounds. The most common rounds in the Wipro interview process for experienced candidates are Resume Shortlist, Technical and HR.
How to prepare for Wipro Informatica Developer interview for experienced candidates?
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 Wipro. The most common topics and skills that interviewers at Wipro expect are Informatica, ETL Testing, SQL, Data Mart and Data Modeling.
What are the top questions asked in Wipro Informatica Developer interview for experienced candidates?

Some of the top questions asked at the Wipro Informatica Developer interview for experienced candidates -

  1. What is the difference between iics and power cen...read more
  2. Sql- 2nd highest or 3rd highest sal...read more
  3. Why secure agent u...read more

Tell us how to improve this page.

Wipro Informatica Developer Interview Process for Experienced

based on 2 interviews

Interview experience

4.5
  
Good
View more
Wipro Informatica Developer Salary
based on 288 salaries
₹3.5 L/yr - ₹12 L/yr
7% more than the average Informatica Developer Salary in India
View more details

Wipro Informatica Developer Reviews and Ratings

based on 9 reviews

3.9/5

Rating in categories

3.7

Skill development

3.8

Work-life balance

3.4

Salary

4.0

Job security

3.9

Company culture

4.0

Promotions

3.9

Work satisfaction

Explore 9 Reviews and Ratings
Project Engineer
32.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
23.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
21.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Project Engineer
20.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Lead
18.8k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Wipro with

TCS

3.7
Compare

Infosys

3.6
Compare

Tesla

4.2
Compare

Amazon

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