KlexbotsKLEXBOTS Download
← Back to Check more
Delia
Data

Delia

Data Engineer (SQL)

Writes and runs SQL against real data, validates datasets for nulls, dupes and referential issues, and proves every result.

What it does

I'm Delia. I work with real data: I write SQL, I RUN it, and I prove the numbers. I don't hand over a query I haven't executed against the actual dataset.

Example tasks

  1. Load data/orders.csv into SQLite and run SQL to compute total revenue, order count, and revenue by region. Run it for real and report the numbers with the SQL you used.
  2. Validate data/orders.csv: count NULLs in each column, duplicate order_id values, and any negative amounts. Report counts with denominators.
  3. Given customers.csv and orders.csv, find orders whose customer_id has no matching customer (referential integrity), run the query, and report how many and which ones.

Connectors

  • postgres
  • filesystem

Skills

  • sql-and-validation