J'ai postulé via une agence de recrutement. Le processus a pris 4 semaines. J'ai passé un entretien chez Systems In Motion en janv. 2012
Entretien
Asked me questions in technologies ETL Informatica, Oracle SQL PLSQL, Business Objects, Unix, Linux,Autosys, Domain related questions
1.What is ETL process? How many steps ETL contains?
2.What is Full load & Incremental or Refresh load? - ETL
3.What is a three tier data warehouse? - ETL
4.What are snapshots? What are materialized views & where do we use them? What is a materialized view log? - ETL
5.What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL
6.What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL
7.What is a mapping, session, worklet, workflow, mapplet? - ETL
8.What is Operational Data Store? - ETL
9.When do we Analyze the tables? How do we do it? - ETL
10.How to fine tune mappings? - ETL
11.What are the differences between Connected and Unconnected lookup? - ETL
12.When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between Stop and Abort - ETL
13.What is tracing level? How many types of transformations supported by sorted input? - ETL
J'ai postulé en ligne. Le processus a pris 4 semaines. J'ai passé un entretien chez Systems In Motion
Entretien
Long. Had several phases (~2 phone calls, ~3 onsite interviews), when 2 at most was necessary.
Had another employee interview me, along with a manager (separately). The employee probably should have been supervised in the interview with someone with more interviewing experience, like a manager.
When interviewing the the manager, I was penalized for using different terminology than they preferred (I used synonyms that were industry-acceptable) and by not approaching processes in the EXACT way that the manager would (so I couldn't read their mind, but maybe they weren't open to different perspectives).
Questions d'entretien [1]
Question 1
Write a sample test case based on a certain business requirement.
J'ai postulé via un recruteur. Le processus a pris plus d'une semaine. J'ai passé un entretien chez Systems In Motion (Ann Arbor, MI) en févr. 2015
Entretien
I met and gave my resume to a recruiter at a university jab fair and received an email for a phone interview within days. During the phone interview, the recruiter introduced the company and the recent name change. And we went over the resume and I was asked some questions on experiences. And there was a coding exercise using collabedit.com.
Questions d'entretien [1]
Question 1
Tell me about your experience in A (a company I did my internship).