Flagstar -AWS Data Engineer

This is a full-time role focused on building and maintaining robust ETL/ELT pipelines and data models in Snowflake supporting data integration from multiple source systems.

What you'll do

• Design, develop, and maintain scalable data pipelines and data transformation frameworks using AWS, Snowflake, and dbt.
• Develop robust ETL/ELT pipelines to ingest, transform, and integrate data from multiple source systems into Snowflake.
• Build and maintain data models in Snowflake.

What they ask for

• Strong hands-on AWS experience
• Strong hands-on Snowflake experience
• Strong hands-on SQL experience
• Strong hands-on dbt experience

Good to have

• Python
• PySpark
• Airflow
• Informatica

Tap what's true for you. Your answers are saved for every other job too.

Put these words in your resume and practise these questions before the interview.

Technical

1. How do you optimize query performance in Snowflake?
2. Can you explain how you use dbt for data modeling and transformations?
3. What are the key differences between delete and truncate in SQL?

Scenario

1. What would you do if an ETL pipeline fails midway during incremental data loading?
2. How would you handle missing or corrupted source data coming into your AWS data lake?

HR

1. Can you describe a challenging technical problem you solved recently?
2. How do you prioritize your tasks when working on multiple data engineering pipelines?

About Ness Digital Engineering

1. How does Ness Digital Engineering deliver digital transformation solutions for its enterprise clients?

Practice questions written from the job listing, not this company's real interview questions.

Applied here? Tell the next person what happened. It's anonymous and takes one tap.