Greenway Health Data Engineer Interview Questions and Answers

Q1. Java questions and data engineering
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Q1. SQL questions on performance tuning, some programming practices to ensure bug free code
Add your answer

Q1. Testing concepts STLC
Add your answer
Q2. Java code to reverse a string
Ans. 
Java code to reverse a string
• Use StringBuilder class to reverse the string

• Call reverse() method on the StringBuilder object

• Convert the StringBuilder object back to String using toString() method
Answered by AI
Add your answer

Q1. Agile concepts like sprints planning and Jira
Add your answer

Coding test was bad. they asked irrelevant things that were not related to the field

Q1. What is data engineering
Ans. 
Data engineering is the process of designing, building, and maintaining the infrastructure for data storage and processing.
• Data engineering involves creating and managing data pipelines

• It includes tasks such as data modeling, data integration, and data warehousing

• Data engineers work with big data technologies such as Hadoop, Spark, and NoSQL databases

• They also ensure data quality, security, and scalability

• Examples of d...read more
Answered by AI
Add your answer
Q2. What is resilient distributed database
Ans. 
A resilient distributed database is a database that can continue to function even if some of its nodes fail.
• It is designed to be fault-tolerant and highly available.

• Data is distributed across multiple nodes to ensure redundancy.

• If one node fails, the database can continue to function using data from other nodes.

• Examples include Apache Cassandra, Riak, and HBase.
Answered by AI
Add your answer

Q1. Describe your workflow of the last project
Ans. 
Developed ETL pipeline to ingest, clean, and analyze customer data for personalized marketing campaigns
• Gathered requirements from stakeholders to understand data sources and business objectives

• Designed data model to store customer information and campaign performance metrics

• Implemented ETL process using Python and Apache Spark to extract, transform, and load data

• Performed data quality checks and created visualizations ...read more
Answered by AI
Add your answer
Q2. What are the different transformations you have used
Ans. 
I have used various transformations such as filtering, joining, aggregating, and pivoting in my data engineering projects.
• Filtering data based on certain conditions

• Joining multiple datasets together

• Aggregating data to summarize information

• Pivoting data from rows to columns or vice versa
Answered by AI
Add your answer

Q1. Related to data warehouse
Add your answer

Q1. Python, data warehouse, data modelling
Add your answer

Q1. How snowpipe works
Ans. 
Snowpipe is a service provided by Snowflake for continuously loading data into the data warehouse.
• Snowpipe is a continuous data ingestion service in Snowflake.

• It automatically loads data from files placed in a stage into tables in Snowflake.

• Snowpipe uses a queue-based architecture to process files in the stage.

• It supports various file formats like CSV, JSON, Parquet, etc.

• Snowpipe can be configured to load data in real-
Answered by AI
Add your answer
Q2. How stream works
Ans. 
Streams are continuous flows of data that can be processed in real-time.
• Streams allow for continuous data processing without the need to store all data at once.

• Data is processed as it arrives, enabling real-time analytics and decision-making.

• Examples of stream processing systems include Apache Kafka, Amazon Kinesis, and Apache Flink.
Answered by AI
Add your answer