Informatica

  www.informatica.com
  www.informatica.com

Informatica Interview Questions

Updated Oct 30, 2014
Updated Oct 30, 2014
149 Interview Reviews

Interview Experience

Interview Experience

70%
15%
13%

Getting an Interview

Getting an Interview

32%
28%
20%

Interview Difficulty

3.3
Average

Interview Difficulty

Hard

Average

Easy

Candidate Interview Reviews

Sort: Popular Date Difficulty
  1.  

    Senior Consultant Interview

    Anonymous Interview Candidate in New York, NY
    Anonymous Interview Candidate in New York, NY
    Application Details

    The process took 3+ monthsinterviewed at Informatica in July 2011.

    Interview Details

    The entire interview process started in first week of May with the HR contacting me directly. I don't remember where/how i applied but i believe i found an opening on indeed and applied directly with the company.

    First, here is a little background about myself. I have about 7 years of total experience in DW/BI and most of it has been on Informatica Power Center client.

    After the initial background discussion with the HR, she said i will have 2 technical interviews. The interviews were scheduled and re-scheduled multiple times. I understand that most of the folks who conduct interviews are busy with their assignments, but so am i or any other candidate so i was a little disappointed with so many re-scheduled interviews.

    Anyways, the first 2 were pure technical interviews. You can't pretend to know something or prepare for the interviews. Unless you have hands on experience you can't answer. Few of the questions are as below

    1) Informatica 7x, 8x, 9x architecture, (need to explain about SOA etc)
    2) Can you install multiple instances of powercenter on same host? if you can, then how will you invoke different instances from a client since you provide same host name? configuring different ports is not the right answer.
    3) Can you invoke a mapplet variable from a worklet? and vice-versa? Can you use a mapping variable inside a mapplet? and all such combinations!
    4) different types of partitions. In depth usage of each partitions and different scenarios(need to provide examples where you have used them in your project, not just the concepts)
    5) dynamic cache, and dynamic partitioning questions
    6) Configuring grid on informatica server, configuring domains, pmrep command usage etc.

    I am not gonna get into more details, basically they are gonna ask everything and anything! These guys know the product in and out, so be prepared for anything! They were very keen on my knowledge of Powerconnect for Tibco/SAP etc but i had never used them in a project even though i had working knowledge.

    They absolutely didn't care about my knowledge in UNIX, shell/perl scripting, DW/BI knowledge, Meta data management or data modeling. All they were interested was Informatica products experience.

    Anyways, I did clear both the technical interviews. I had 3 other interviews with 2 VP's and a Regional Manager. Again, all these interviews were re-scheduled multiple times dragging the whole interview process to over 3 months. The VP's and regional managers were more interested in my consulting background and softskills and just a high level understanding of my informatica knowledge.

    I did clear all the interviews. The final interview was with a VP face to face in their NY office.

    Interview Questions
    • Can you install 2 instances of Informatica on the same server? if you do, how do you invoke the 2 instances from the same client?   Answer Question
    Reasons for Declining

    After almost 3 months since the process started i finally received an offer. The offer was substantially lesser than what i was expecting ( the base component) . In the meanwhile i got better offer with one of the top consulting firms. I was definitely inclined to join informatica, but they was not much room for negotiation. They were willing to bump up 2.5k above their previous offer, which was still substantially lesser than the other offer i had in hand.

    The other offer i had required no travelling and better pay, more personal time in my life! With informatica professional services, you would travel ALOT! and i expect them to pay for that inconvenience.

    Regarding all the other people talking great things about Informatica benefits, they have either never worked for a big company or this is their first job! The other offer i got has better benefits than Informatica in every single category Healthcare/Vacation days/401k/bonus. Informatica offerred me NO bonus? really? for a high growth company, no bonus? common!!

    Declined Offer
    Neutral Experience
    Difficult Interview
  2.  

    Software Engineer Interview

    Anonymous Interview Candidate in Delhi (India)
    Anonymous Interview Candidate in Delhi (India)
    Application Details

    I applied through college or university. The process took 2 daysinterviewed at Informatica in October 2012.

    Interview Details

    Applied through campus placements.
    2 written rounds + 3 tech rounds + 1 HR
    Written round 1: Questions on OS, Databases, OOPs, data structures, trees/graphs
    Written round 2: Option to choose either C or Java. I chose Java, Very deep questions from java concepts. Classes/ nested classes, inheritance, constructors etc. Types of questions included finding errors and predicting outputs. Also reaons had to be given for each answer as to why that was an error or why a particular output would come. 5 theoritical questions.
    What data structures would you use in some given scenarios etc.

    Interview: Could not clear round 1. Algorithm for shortest path in a binary matrix, A question from the written paper was asked, Some ques on OS

    Interview Questions
    No Offer
    Neutral Experience
    Difficult Interview
  3. 1 person found this helpful  

    QA Engineer Interview

    Anonymous Interview Candidate in Bangalore (India)
    Anonymous Interview Candidate in Bangalore (India)
    Application Details

    I applied through college or university. The process took a dayinterviewed at Informatica.

    Interview Details

    First Online Aptitude Round (consisting of objective questions from all core subjects)
    Second Online Round consisted of theory questions and programs
    Followed by 3 technical interview
    Finally had 1 HR interview

    Interview Questions
    Negotiation Details
    No Negotiation
    Accepted Offer
    Positive Experience
    Difficult Interview
  4. Is this helpful? The community relies on everyone sharing – Add Anonymous Interview Review


  5. 1 person found this helpful  

    Software Engineer Interview

    Anonymous Interview Candidate in Bangalore (India)
    Anonymous Interview Candidate in Bangalore (India)
    Application Details

    I applied through college or university. The process took 3 daysinterviewed at Informatica in June 2012.

    Interview Details

    The first question, was explaining about work profile which was good start to demonstrate technical capabilities and make good impression of expertise in domain and technologies. ( this is what we already write in our resume/profile, but it was chance given to explain out yourself).

    Next question was to explain out current project architecture and implementation on big board. Here, had interactive session for 5-10 mins on process flow, different pros and cons of architecture design and explaining out how this design works with actual use cases. ( This works out to be good demonstration for what currently doing, so started with explaining project architecture SOA based layered architecture, emphasizing more on J2EE core design pattern, GOF design pattern for creational, behavioral and structural, also talking of solution components and how they are integrated like EJB, Webservices, JMS, Database, Quartz batch scheduler.

    Next questions was sort in debate mode on clustering (application running on multiple server) and how application works. More specifically on batch scheduler running in cluster environment. Expectation was high level explanation how Quartz scheduler handlers cluster deployment.

    Next question was on making MQ messages transactional in synchronous communication environment. Let's say I have an application which need to send out messages to two databases oracle and sybase, part of record is written in oracle remaining part of same message goes in sybase, so let's say if sybase transaction failed then how would you roll back whole transaction so that data in oracle is not inconsistency with sybase database

    Interview Questions
    Declined Offer
    Positive Experience
    Difficult Interview
  6.  

    QA Engineer Interview

    Anonymous Interview Candidate
    Anonymous Interview Candidate
    Application Details

    I applied through college or university. The process took 2 daysinterviewed at Informatica.

    Interview Details

    1 round objective test: 4 sections
    logical,c/c++,os,dbms
    immediatly after the test results are announced
    shortlisted students have to appear for 2nd subjective test which is a written test
    OS,shell Scripting,c program,dbms
    the selected students have to go through 2-3 technical rounds
    finally there is hr round

    Interview Questions
    No Offer
    Difficult Interview
  7.  

    Senior Software QA Engineer Interview

    Anonymous Interview Candidate in Bangalore (India)
    Anonymous Interview Candidate in Bangalore (India)
    Application Details

    I applied online. The process took 2 weeksinterviewed at Informatica in September 2014.

    Interview Details

    The most difficult interview i have faced so far in my career. There were 8 rounds in total,
    4 rounds of technical interview (each 1hr) and the rest 4 rounds were non-technical.
    All the 8 rounds were completed in a single day. The complete Interview process was done very professionally and the interview panelists were very patient and supportive throughout.

    Interview Questions
    • Design your own hash map. Multiple programs were asked during the technical rounds (around 5-6 pgms). They test your technical knowledge very thoroughly. Make sure you are well prepared before attempting interviews in Informatica.   Answer Question
    Accepted Offer
    Positive Experience
    Difficult Interview
  8.  

    Staff Engineer Interview

    Anonymous Interview Candidate in Bangalore (India)
    Anonymous Interview Candidate in Bangalore (India)
    Application Details

    I applied through a recruiter. The process took 4 weeksinterviewed at Informatica in April 2014.

    Interview Details

    Recruiter approached me via social media connection. Very proactive and great in communication (makes you feel comfortable). Total 9-10 rounds of interview cycles varying from technical to the leadership level questions. Also made a presentation to the Senior leadership team of technical architects and managements. Each interview lasted for about an hour.

    Started with telephonic interview with questions around connection pooling, sorting for unknown size of a streaming data, etc.

    Later onsite full day interviews most of them being technical and few with the senior management and one with HR Business partner.

    Technical questions are mostly in the area Informatica is working on like data cleansing, optimization for data staging, metadata management, handling hierarchical structure data, etc. In one of the interview, they made me write the code (of my preferred language) on alteration of binary tree management.

    Leadership orientated questions includes how to deal with the situation where you don't know much technical insights but critical for the business; will you accept the challenge or will reject due to lack of confidence behind the technicality of the subject, etc.

    Overall great experience with the interview process; however, request to HR to be punctual on the schedules. I had to wait for one hour for one of the interview :(

    Interview Questions
    • Already mentioned type of question in previous section.   Answer Question
    Negotiation Details
    It's a fixed price offer! May be you can negotiate on the stock options; from salary point of view, I doubt if you will have success negotiating. But nothing to loose trying out!
    Accepted Offer
    Positive Experience
    Difficult Interview
  9.  

    Senior Software Engineer Interview

    Anonymous Interview Candidate in Bangalore (India)
    Anonymous Interview Candidate in Bangalore (India)
    Application Details

    I applied online. The process took 3 daysinterviewed at Informatica in August 2014.

    Interview Details

    Round 1 : telephonic (Basic java with collections questions)
    F2f : 3 rounds : Each round had one coding exercise (Java File i/o, threads, remove duplicates in a list, print fibonocci series using recursion , binary tree traversal), one design exercise ( Design a logging utility, tiny URL service architecture), SQL Join queries,

    Interview Questions
    No Offer
    Neutral Experience
    Difficult Interview
  10.  

    Senior Software Engineer Interview

    Anonymous Interview Candidate
    Anonymous Interview Candidate
    Application Details

    interviewed at Informatica in August 2014.

    Interview Details

    Had 6 rounds of technical discussion. Questions were mostly on Core Java basic concepts and data structures and design patterns. Also had HR round where the salary expectations were discussed.

    Interview Questions
    No Offer
    Positive Experience
    Difficult Interview
  11.  

    Professional Services, Analyst Interview

    Anonymous Interview Candidate
    Anonymous Interview Candidate
    Application Details

    The process took 2 daysinterviewed at Informatica.

    Interview Details

    There was an aptitude test which consisted of two sections:
    1. Logical section
    2. Basic CS

    The logical section was simple, but the CS section was a little bit difficult. It mainly consisted questions related to OS, Networking, Java and algorithms.

    After clearing this round we had 5 rounds of interview. 3 technical, 1 managerial and 1 HR.

    The technical rounds mainly consisted of questions of OS(Unix scripting), DBMS(basic/complex queries), PL/SQL, Data warehousing, programs and puzzles.

    The managerial round mainly consisted of questions related to HR and also puzzles.

    Each round was an elimination round.

    Interview Questions
    • Read records from a .txt file and update the records in database using PL/SQL or Java   Answer Question
    No Offer
    Positive Experience
    Difficult Interview

Work at Informatica? Share Your Experiences

Informatica

 
Click to Rate
or

The difficulty rating is the average interview difficulty rating across all interview candidates.

The interview experience is the percentage of all interview candidates that said their interview experience was positive, neutral, or negative.

Your response will be removed from the review – this cannot be undone.