Have you worked with Apache NiFi?
Data Engineer
How do you pass data between different Airflow tasks?
Describe an end-to-end technical task: from source to storefront, including layers and actions at each stage.
Do you have any questions at this stage?
What are your motivations and development plans for the next few years? Where do you want to grow?
If an SQL query takes too long, what will you do?
You received a task with number ABC. What is your order of actions in Git at the start of work?
Have you worked with Informatica or Oracle? Did you use SQL procedures and functions?
Did you write DAGs in Airflow? What types of tasks did you use?
Did you use indexes in your work? Which ones did you use most often?
What data volumes did you have to process?
What optimization methods did you use for SQL code?
Why do you have doubts about offers?
Tell us about your experience, the tasks you solved, and the stack.
How do you evaluate a new, unfamiliar task? Where do you start?
What is the most complex SQL you have written? What window functions did you use?
When is it more advantageous to use hash partition, and when range partition?
Which fields did you distribute data in Greenplum?
Have you worked with Oracle and PL/SQL?
[name] tell us about your current project: what did you do, what interesting tasks, technologies, and the complexity of the project.