JobHabor
Menu

Lead Engineer - II_ETL Testing

Futran Solutions · Chicago, IL, United States

Weak hiring record · median 69 days open

5353

Hiring signal

Stale

Open 69 days · Never reposted · Checked today · How we score

First seen
11 November 2026
Reposted
Not since September 2026
Last checked
Today · still on the employer's board
All reasons
  • Open 68 days
  • 53% of this employer's openings are over 60 days old

In its favour

  • Still listed on the employer's own board

Hide postings like this across the board

Did you apply?

Lead Engineer - II_ETL Testing at Futran Solutions. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

Lead Engineer - II_ETL Testing

Chicago, IL - In person interview and 3 days WFO.

Job Description

ETL Tester with AI Experience

What is in it for you?

Looking for a Senior QA professional skilled in ETL, SQL, Azure Databricks, Agentic AI evaluation, web testing, and test automation tools, driving data integrity, compliance, and scalable validation strategies to join our team in Chicago, IL

Roles and Responsibilities: -

  • We are building AI agents that generate the extraction queries and transformation logic instead plus the Workbench through which humans review and approve everything they produce.
  • The agents emit metadata; the client's existing data platform executes it.What you'll do Own test strategy and reconciliation methodology

Define the equivalence standard

what must match exactly, what may vary within tolerance, and at which layer each applies Design source-to-target validation across the redesigned path — raw ingestion, consolidated transformation, domain refined

  • Establish risk-based prioritisation; the schedule does not permit exhaustive coverage of hundreds of tables Author the Test Strategy and Test Plan for review with the client in Phase 2 Own agent evaluation Build and maintain a golden reference set from existing production extracts, validated with the Epic SME, with strict separation between evaluation data and anything used to develop or tune the agents Stand up the evaluation harness in MLflow — scoring runs, versioning, candidate comparison
  • Define and report the measures that matter mapping precision and recall, override rate, confidence calibration, run-to-run consistency, escalation correctness and cost per case Operate the regression gate — no prompt, skill or model change is promoted without passing evaluation.
  • A prompt change can silently degrade quality with no data-level symptom

Characterise how agents fail, not just how often

hallucinated tables, plausible-but-wrong column selection, silent omission of required fields, mis-selected join grain.

  • Own the automated regression harness Automated comparison of new-path output against current production extracts Row counts, aggregate reconciliation, field-level comparison, type and precision validation, null and duplicate profiling, referential integrity Repeatable execution so every agent revision can be re-validated cheaply
  • Design the control-critical test suites Member, health-system and facility isolation. Facility mapping is moving downstream, creating real regression risk against the guarantee that one member cannot see another member's data.
  • A cross-member leak is the highest-severity failure mode on this engagement Contract-scope validation.
  • Data-sharing contracts restrict access at facility, column and product level. Verifying that generated queries stay inside permitted scope is a testable control with legal consequences if missed Acquisition cost validation.
  • Confirm optimised queries touch fewer source tables than baseline and that facility consolidation genuinely works Lead and report Direct two QA engineers; set standards, review coverage, own the defect taxonomy
  • Confirm downstream compatibility across Databricks, SQL Server and Vertica Produce evidence packs suitable for client executive review, and defend methodology, sample sizes and statistical claims under scrutiny.

Experience: -

10+ Years

Location: -

Chicago, IL (Hybrid – 3 days' Work from Office)

Duration: -

Contract role with CitiusTech

Educational Qualifications: -

Engineering Degree – BE/ME/BTech/MTech/BSc/MSc.

Technical certification in multiple technologies is desirable.

Skills: -

Mandatory skills

  • 10+ years in data / ETL testing, including strategy ownership on at least one large migration or re-platforming programme
  • Proven reconciliation and equivalence testing — demonstrating that a rebuilt pipeline produces output equivalent to a legacy one, and defending that conclusion to stakeholders
  • Expert SQL — complex analytical validation queries written independently against unfamiliar schemas Databricks / PySpark for validation at data volume Python for test automation and harness development
  • Data quality and test automation frameworks — Great Expectations, dbt tests, pytest or equivalent Test strategy authorship — coverage models, risk-based prioritisation, entry and exit criteria, defect taxonomy multi-target validation across at least two of Databricks, SQL Server, Vertica or comparable
  • Experience testing PHI-scoped healthcare data, including de-identified or synthetic test data Defect management and reporting in Azure Boards Team leadership — setting standards and reviewing others' coverage
  • Ability to state an uncomfortable quality position to senior stakeholders and hold it Preferred Experience evaluating LLM or GenAI systems — MLflow, LangSmith, Weights & Biases or equivalent; LLM-as-judge design and its failure modes Applied statistics — sampling design, confidence intervals, significance testing, calibration measurement Epic EHR data experience

Caboodle or Clarity Clinical coding systems

ICD, CPT, SNOMED, LOINC Multi-tenant data isolation testing Experience testing code- or SQL-generation systems Prior work where test evidence was presented directly to client executives

Software Design and Best Practices

Apply software design principles such as SOLID and Domain-Driven Design.

  • Understand code patterns and practices.
  • Maintain currency in technical skills and industry trends.

Skills

ETL, SQL, Azure Databricks, Agentic AI testing, Web testing Any Data Automation tool.

Skills

  • ETL
  • QA
  • Agentic AI

More jobs at Futran Solutions

All 541

Similar roles