The process took 2 months - interviewed at Informatica in October 2011.
Interview Details –
I sent my resume directly to a hiring manager at Informatica. She responded to me very quickly and set me up with phone interviews with a recruiter and herself. I ended up interviewing with many, many people and came in to the office many times. They were extremely thorough. I was consistently informed of status, which I appreciated a great deal as I was interviewing with a few other companies.
Interviews were typically 45 minutes. I spoke with people from many parts of the organization so I didn't mind getting a lot of repeat questions. They were very specific in getting the information they needed. Lots of behavior interviewing where they asked me exactly what I did in previous situations, what the outcomes were, anything I might have done differently etc.
The interviews could be somewhat daunting, but the interviewers were very nice and respectful even when digging deep.
My advise is to hang in there through the interview process. They take longer and they really want to make sure you are the right person. The result is that if you get in you get to work with a lot of exceptionally talented people. You can get a job a lot faster and easier, but it won't be as good a job.
Interview Question – I think the toughest questions were the 'how would you solve x problem' questions. The reason is that they were usually based on real situations that the interviewee didn't have all the necessary information about. You kind of felt like you were giving a 'meh' answer because you just knew there was a lot more data that you'd like to be able to consider. They really just wanted to understand your process and see how you would apply your experience though. Answer Question
Negotiation Details – Managers and recruiters are flexible. Tell them where you're at, what other offers you have and just be open and honest. They'll take care of you and make sure you are paid fairly compared to your peers and also compared to the general market.
The process took 4+ weeks - interviewed at Informatica in September 2011.
Interview Details – Never applied , HR saw my profile on LinkedIn and contacted , i dont work on Informatica anymore though i do i have Informatica experience i think they were more interested in my "big data" experience.The interview was very technical and i was not satisfied with my performance at all ,nevertheless i was called to face to face interview with VP and a regional manager . Base salary that they offered me was not that great but the bonus was considerable .
Interview Question – They ask each an every informatica powercenter question under the sun , but they look for heterogenous experience of other ETL and connectivity tools . Answer Question
Negotiation Details – Did not negotiate much
I applied through an employee referral and the process took 2 weeks - interviewed at Informatica in September 2011.
Interview Details – The process is fairly traditional. Each individual that I met with was terrific. There was no high pressure or negative feeling that came across to me. They were all professional and truly cared to find the right fit for the position. It was a terrific experience and one of the few that I was able to relax into.
Interview Question – There is no one question that particularly stands out as difficult or unexpected. Each question was individual to my background and how that experience would contribute to the position that I was interviewing for. Answer Question
Very Difficult Interview
The process took 3 months - interviewed at Informatica in September 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 Question – 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
Reason 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!!
I applied online and the process took 1 week - interviewed at Informatica in May 2011.
Interview Details – started with phone interview which went for 1 hours than interview with manager , following a Panel interview. It was all about the technical skills in this company as it is for engineering. Good people and best work culture
Reason for Declining – I got good offer from some other place in a start up
I applied online and the process took 5 weeks - interviewed at Informatica in January 2011.
Interview Details – 2 separate phone interviews with each of the national managers then 2 1:1 interviews with regional managers and district managers. Everyone was professional and the questions were specific to the point where I thought I was taking a test. Definitions and all. Presentation of 3 separate case studies to be displayed on a white board.
Interview Question – Draw the internet. Answer Question
I applied through an employee referral and the process took a day - interviewed at Informatica in August 2010.
Interview Details – The hiring process was very smooth. I received a call from the recruiter about the position. Later, I got a call from 2 developers who asked me some technical questions related to java. Then I spoke to the team members one by one who asked me pretty basic java related questions. Finally spoke to the manager and the director for the offer and salary.
I applied online and the process took a day - interviewed at Informatica in February 2010.
Interview Details – Interview with Internal Head Hunter over the phone for them to understand your background. As long as they feel you fit the role, they will schedule for in-person interview. Had a series of 4 interviews with Hiring Manager, VP or SVP of group, and Technical People.
Interview Question – What was your most difficult customer situation? View Answer
Negotiation Details – They called me with an offer either the same day or next day.
I applied online and the process took 3 days - interviewed at Informatica in September 2009.
Interview Details –
I applied online and the process started when the recruiter contacted me to schedule phone interviews. The hiring manager spoke to me to get a feel of my education, experience, availability location, salary details etc...and then the interviewing began. My resume was quite detailed and as it turns out, I was not a perfect fir for the role advertised. But I considered myself a good fir because I had the ability to quickly fill any gaps in my skill levels.
First a team of three members asked questions thoroughly about my skills and back ground. At this point, they should have known very well that I fell a little short. However, they interviewed me one more time and then a team leader interviewed me. It was the same set of questions by the same set of people for at least 2 or three rounds. I gave the same answers. Then the recruiter wanted to schedule face 2 face interviews. At this point I was quite encouraged that they would consider hiring me. For that reason, I traveled on my personal expense to attend those interviews (Skimpy company policy that they wouldnt pay for interview travel). Same set of people who interviewed on the phone and same questions again! Sounded like the phone interviews were simply a waste of time. What followed was perhaps the most frustrating time in my career. The director of the group spoke to me and started asking some stupid questions - like why did I change my jobs frequently in the past etc...Well all that is already in my resume - why ask me now and this far into the process after making me travel on my own? After a few minutes of talking to him, I started to get a feel that the result would be negative and was mentally prepared for it. And then they proved they were total nut jobs when it comes to handling prospective talent. The director said that my skills were not up to the mark - but they still liked to hire me for a different position (I was totally confused)....So I went through another F2F interview for the new position. Then they said it is all done and that I would be contacted later. I left confused but confident that I would get an offer. They emailed me a week later that there was no interest in hiring me. I was totally dejected that I had to go through all the pain, travel, effort, cost and expectation for no good. They could have easily made that decision after the phone interviews. I am writing this hoping this would be a good example for prospective candidates.
Pros: “Good health benefits, gym facility” – Full Review
We Put Potential to Work We believe the information potential is endless—and data integration is more important than ever. We believe it is the bedrock of truth that enables organizations to ask and answer even more… — Full Overview
Provided by employer [?]
This is the employer's chance to tell you why you should work for them. The information provided is from their perspective.
Your feedback has been sent to the team and we'll look into it.
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.
Simply post an anonymous review for a recent interview experience or current/former employer. Your post is anonymous – and if you're worried someone will be able to identify your review, you can even post without telling us your job title and location. Learn More.
No thanks –