Good overall, a fair process that asks you about data. Asks about etl, data warehouse, sql questions, pipeline, I thought it was average difficulty and asked fair questions. The process was about 3 stages. The stages were hr interview, technical, and manager conversation.
I applied online. I interviewed at Pingahla (New York, NY) in Jul 2020
Interview
Standard 4 person interview;
The 1st interview is with HR. This is nothing more than your standard HR questions.
2nd interview is around your tech knowledge. A lot of standard DW 101 questions, ETL/ELT, and they do get into Cloud and Big Data questions.
3rd interview is the Pingahla team asks you to build a solution and present it. They also ask you to build an ETL data pipeline using a tool of your choice.
The 4th interview is with leadership.
Interview questions [1]
Question 1
Tech Questions:
What is Datawarehousing?
What is BI?
Name a few Datawarehousing types of models?
What is the difference between a Snowflake and Star schema?
What is Dimension Table?
What is Fact Table?
What is OLTP?
What is OLAP?
What is ODS?
What is the difference between View and Materialized View?
What is ETL?
What is SCD and what are the types of SCD?
What is AWS or Azure?
Benefits of the cloud.
Which are the different layers that define cloud architecture?
Which platforms are used for large scale cloud computing?
What are the different layers in cloud computing? Explain working of them.
What do you mean by software as a service?
What is private cloud and what is public cloud?
What are hybrid clouds?
What is the difference between scalability and elasticity?
Why API's is used in cloud services?
What are the five V’s of Big Data?
Tell us how big data and Hadoop are related to each other.
Define respective components of HDFS and YARN
Why is Hadoop used for Big Data Analytics?
What are the main differences between NAS (Network-attached storage) and HDFS?
What is Docker?
What is meant by Continuous Integration?
What is the need for DevOps?
Define Microservice Architecture
How is DevOps different from Agile/SDLC?
What are the success factors for Continuous Integration?
What does Containerization mean?
What is the difference between a Docker image and a container?