Data Warehouse Developer Interview Questions

Just Crack Interview Providing interview questions and answers to help you in clearing the interview with ease. Data Warehouse Developer interviews are tough, but they are solvable. Data Warehouse Developer extends thousands of job offers a year, and you could be one of the engineers receiving one of those offers. Data Warehouse Developer Interview Questions will be based on subjects of your interest and based on projects you have done. Here we will discuss the most frequently asked interview questions in the Data Warehouse Developer Interview Process as well as the Data Warehouse Developer Interview experiences of candidates.

How to Crack Data Warehouse Developer Interview

Management Round: All relating previous experience including offshore & onsite experience (onsite exp will be value added)

I also Faced E-Mail Answers View Answers

HR Round: This is all about remuneration, location and other benefits if any..

I also Faced E-Mail Answers View Answers

Table1//column1—1,2,3 table2/column2—-4,2,2,3 // output of each join,,what is maplet,, materelize view,,,

I also Faced E-Mail Answers View Answers

It’ as per your profile

I also Faced E-Mail Answers View Answers

Basically wanted to know what is ur expectation and if ur expectations are met , will u stay long term in HP

I also Faced E-Mail Answers View Answers

Why HP, why leaving last company, flexibility to switch technology, work in shifts, long hours, tough technical, short term and long term goal in HP

I also Faced E-Mail Answers View Answers

UNIX Internal and SQL performance tuning related questions

I also Faced E-Mail Answers View Answers

Tell me about ur self,why software,why mindtree,tell me about ur college,any interest for further studies,one program to develope

I also Faced E-Mail Answers View Answers

Questions from c and c++,questions from mpmc

I also Faced E-Mail Answers View Answers

Questions from DBMS and 1 programming language in detail.Asked to write programmes and good no of questions were asked from DBMS.Asked abt hobby.

I also Faced E-Mail Answers View Answers

Tell me somthing about You?

I also Faced E-Mail Answers View Answers

How aggresive are you for this job?

I also Faced E-Mail Answers View Answers

Difference between HAVING and WHERE?

I also Faced E-Mail Answers View Answers

Technical Questions (Top Priority and very Deeply), Communication Round and Managerial Round.

I also Faced E-Mail Answers View Answers

Can Full Backup be performed when the database is open ?

I also Faced E-Mail Answers View Answers

1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance of DataStage? 4.what are the Job parameters? 5.what is the difference between routine and transform and function? 6.What are all the third party tools used

I also Faced E-Mail Answers View Answers

What are the steps involved in Database Shutdown ?

I also Faced E-Mail Answers View Answers

In my report contain Product name, Amount, Country, Sales person.I want to create one prompt: Sales Territory.( Ex: asia, US, UK, AUS), but territory column is not there in my model and source.if u select the Asia in prompt page-?ll Asian country results

I also Faced E-Mail Answers View Answers

How i create datastage Engine stop start script.Actually my idea is as below.!#bin/bashdsadm – usersu – rootpassword (encript)DSHOMEBIN=/Ascential/DataStage/home/dsadm/Ascential/DataStage/DSEngine/binif check ps -ef | grep DataStage (client connection is

I also Faced E-Mail Answers View Answers

What other ETLs you have worked with?

I also Faced E-Mail Answers View Answers

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

I also Faced E-Mail Answers View Answers

How can u implement slowly changed dimensions in datastage? explain?2) can u join flat file and database in datastage?how?

I also Faced E-Mail Answers View Answers

How can I connect my DB2 database on AS400 to DataStage? Do I need to use ODBC 1st to open the database connectivity and then use an adapter for just connecting between the two? Thanks alot of any replies.

I also Faced E-Mail Answers View Answers

What is DS Director used for – did u use it?

I also Faced E-Mail Answers View Answers

Six bells commence tolling together and toll at intervals of 2, 4, 6, 8 10 and 12 seconds respectively. In 30 minutes, how many times do they toll together ? (a) 4 (b) 10 (c) 15 (d) 16

Asked In: athamas technologies Interview Questions , no1 currency Interview Questions , Oap Interview Questions ,

I also Faced E-Mail Answers View Answers

What are the limitations of pushdown optimization technique ?Advance thanks

I also Faced E-Mail Answers View Answers

Name at least six file extensions of Microsoft Access?

I also Faced E-Mail Answers View Answers

What does the Log Reader agent in SQL Server 2005 replication do?

I also Faced E-Mail Answers View Answers

Have you ever been in a situation, at work, when you have been motivated to question an ethical issue?

Asked In: Maarga Systems Interview Questions , winwire technologies india Interview Questions ,

I also Faced E-Mail Answers View Answers

What is normalization? explain 1st NF, 2nd NF, 3rd NF

I also Faced E-Mail Answers View Answers