Interview Guides

You're discussing how you approach building data pipelines and how you choose the tools behind them. The interviewer wants to understand your preferences, but also the reasoning you use when selecting extraction, transformation, and orchestration technologies.
What tools and technologies do you prefer for data extraction and transformation, and why?