What data stores have you worked with? Is PostgreSQL a relational database? Have you worked on Azure Data Factory?

S: In my previous role I was responsible for designing data pipelines that extracted data from multiple sources and loaded it into a data warehouse. T: One of my key tasks was to integrate data from on‑prem SQL Server, PostgreSQL, and Azure Blob Storage into Azure Synapse. A: I used Azure Data Factory to orchestrate the pipelines, creating linked services for each source, and built data flows to transform the data. I also set up incremental loads using watermark columns and monitored the pipelines with ADF monitoring. R: As a result, we reduced the data refresh time from 12 hours to 2 hours and improved data quality by automating schema validation. PostgreSQL is indeed a relational database; it supports ACID transactions, SQL querying, and relational modeling. I have used it extensively for staging data before moving it to the warehouse. ADF was my primary orchestration tool, and I leveraged its copy activity, mapping data flows, and trigger mechanisms to build robust, scalable pipelines.