1. Given a case with 3 different data sources, how would you move ahead to process data for analytics purpose? 2. Difference between Tableau and Power BI 3. Window functions 4. Cardinality 5. How to programmatically handle SCDs 6. Troubleshooting in SSIS 7. ER Diagram 8. DAX queries (SUM vs SUMX)
Can you recall a time you were given misinformation and how did you deal with it?
Do you have python experience?
What areas of tech are you interested in?
What is data vault, Priority (Having or Where), CTE, How to check df size (pandas) Formats of files(CSV, TSV, Avro, etc) What is blob
Questions mostly about my background, interest in the company, where I want to go in company, and some general knowledge of big data technology.
questions in data science and multithreading
>>Intr--Education, background,experince & project >>Where you have used python? >>What u have done with PII data? >>Masking >>Can we do unmasking >>Masking business logic >>Encryption & decyption >> Medallian Architecture >>Can other guy access silver layer from medalliaon architecture? >>Stream processing >>which tools are required for streaming process >>If due to some reason stream pipeline get break/fail, will the data will resume or start from begining? >>What is Data warehousing >>Optimization techniues used >> Have u worked with AWS?
How would you iterate through a variable
They asked me what the MERGE statement was in SQL?
Viewing 361 - 370 interview questions