Describe your previous projects
Data Interview Questions
133,136 data interview questions shared by candidates
Things you look for in a company
Differences between RAID levels. Power redundancy practices, equipment racking stuff.
You have this table - orders (order_id, customer_id, order_datetime, order_amt): 1)select top 10 paying customers for given month
write a code in R/SQL: Given a table with three column, (id, category, value) and each id has 3 or less category (price, size, color). Now, how can I find those id's for which the value of two or more category matches to one another? For eg: ID1 (price 10, size M, color Red), ID2 (price 10, Size L, Color Red) , ID3 (price 15, size L, color Red) Then the output should be two rows: ID1 ID2 and ID2 ID3
- What is over-fitting? How do you avoid it? - What types of regularization do we have? Which one is simpler to use? L1 or L2? - Explain decision trees? What are different metrics to classify dataset? - What is bagging? - We have two models, one with 85% accuracy, one 82%. Which one do you pick? - What is p-value and how can we use it?
Tell me about your self? What is Data Warehousing?
1. Tell us about yourself 2. What is the Difference between analog and digital system. 3.Between analog and digital which one do we use to Start up the system. 4. What is kW and kVA 5.Explain the Building Management Systems operation. 6.What is PDU. 7.Why do you think UPS are very essential to our network because they are expensive and they can only last for 20 seconds. 8. Explain N+1, 2N and N-1. 9.Mention three components that are in the UPS, AHU,Chillers,Cooling Towers and VFDs. 10. Why do we need to synchronize/parallel the Generators. 11. Explain Variable Frequency Drive (VFD)operation. 12. Explain the process that the Chillers use to heat fro the building. you must know the operation of the chiller here. 13.Explain a Difficult situation that was out of your role where you had to make a decision , what was the outcome. 14. How do you deliver results?
The interview was highly focused SQL questions such as finding the third high, finding the newest one.
Based on my experience in different projects and analytical functions in SQL
Viewing 831 - 840 interview questions
See Interview Questions for Similar Jobs
Computer OperatorCirculation ManagerDatacenter TechnicianConfiguration Management AnalystNoc OperatorMailroom ClerkManager AnalyticsMedical ClerkMail Room ClerkMedical Office ClerkMedical Office ReceptionistMedical Record Retrieval SpecialistMedical Claims ProcessorMail SorterManual Software TesterManager Marketing AnalyticsMedical Billing ClerkMedical Office SpecialistMarketing Analytics Manager