Skip to contentSkip to footer

Dwh Developer Interview Questions

Salaries
Interviews

36 dwh developer interview questions shared by candidates

In informatica, you need to load the table using a date window (for example, from a certain date, or X days ago from the current date). Where does this value come from? The answer is just described above: use a mapping variable, which can be filled from a parameter file or a lookup from a table.

Senior DWH Developer

Interviewed at Credit Bank of Moscow

4.1★
Dec 14, 2021

In informatica, you need to load the table using a date window (for example, from a certain date, or X days ago from the current date). Where does this value come from? The answer is just described above: use a mapping variable, which can be filled from a parameter file or a lookup from a table.

In informatics: 1) how to build a mapping for scd2, scd1. What transformations to use (lookup, router, filter, expression, update) 2) ways of transferring parameters to mapping (via mapping variables, lookup, parameter file) 3) how to create a session in a stream based on mapping 4) reverse the session. reusable session 5) ways of working with partitions when rolling changes to a partitioned target table. Example: you need to quickly update all the data on the partition, how can you do this? Answer: partition truncate and insert whole portion 6) Ways to accelerate the insert of delta data (difference from previous state). Howto: transformation of sorting, use of hash table Oracle questions: 1) what objects I know (table, view, materialized view, trigger, index, stored procedures, packages, context vars etc.) 2) advantages of package consolidation of procedures 2) types of physical joins (Merge, hash, etc.) 3) ways to optimize queries. Answer: the correct sequence for selecting data from tables in joins (from a smaller dataset to a larger one), using hints

Senior DWH Developer

Interviewed at Credit Bank of Moscow

4.1★
Dec 14, 2021

In informatics: 1) how to build a mapping for scd2, scd1. What transformations to use (lookup, router, filter, expression, update) 2) ways of transferring parameters to mapping (via mapping variables, lookup, parameter file) 3) how to create a session in a stream based on mapping 4) reverse the session. reusable session 5) ways of working with partitions when rolling changes to a partitioned target table. Example: you need to quickly update all the data on the partition, how can you do this? Answer: partition truncate and insert whole portion 6) Ways to accelerate the insert of delta data (difference from previous state). Howto: transformation of sorting, use of hash table Oracle questions: 1) what objects I know (table, view, materialized view, trigger, index, stored procedures, packages, context vars etc.) 2) advantages of package consolidation of procedures 2) types of physical joins (Merge, hash, etc.) 3) ways to optimize queries. Answer: the correct sequence for selecting data from tables in joins (from a smaller dataset to a larger one), using hints

Viewing 1 - 10 interview questions

Glassdoor has 36 interview questions and reports from Dwh developer interviews. Prepare for your interview. Get hired. Love your job.