AI Data Warehouse Automation Specialist
An AI Data Warehouse Automation Specialist architects and deploys intelligent systems that automatically design, build, optimize, …
Skill Guide
The systematic practice of designing, testing, and refining natural language instructions to elicit precise, reliable, and maintainable outputs from large language models for software engineering tasks.
Scenario
Given a PostgreSQL schema for a 'users' table (columns: id, email, created_at), generate a complete Python Flask blueprint with routes for create, read, update, and delete, including request validation and SQLAlchemy models.
Scenario
You have 5 sample JSON customer support tickets with varied fields. The goal is to infer a consistent JSON Schema, then generate corresponding Python Pydantic models and TypeScript interfaces for a cross-platform SDK.
Scenario
Build a CI/CD pipeline plugin that, on a pull request, analyzes the git diff of Python source files and automatically generates or updates corresponding sections in the project's Sphinx documentation.
Select based on task complexity, cost, and data sensitivity. Use structured output modes (JSON, function calling) for deterministic schema generation. Claude is strong for long-context analysis (large files). Ollama is critical for processing proprietary code.
Use LangChain for orchestrating multi-step prompt workflows. Use Promptfoo or a custom test suite to evaluate prompts against a set of sample inputs for correctness and robustness. DSPy treats prompts as learnable modules. Version-control prompts with the same rigor as code.
Leverage IDE integrations for real-time code generation assistance during development. Use CI/CD plugins to automate documentation and test generation as part of the pipeline, ensuring prompts run in a controlled environment.
Answer Strategy
The candidate must demonstrate a structured methodology: decomposing the problem, defining output constraints, and building in verification. A strong answer outlines: 1) Extracting entity-relationship rules from the PRD into a context snippet, 2) Specifying the target DB and ORM in the system prompt, 3) Using few-shot examples of correct migrations, 4) Adding a post-generation step where the LLM critiques its own script for SQL syntax and referential integrity, 5) Validating against a sandboxed database.
Answer Strategy
Tests for quality assurance mindset and system design. The answer should focus on implementing guardrails, not just manual checks. Sample response: 'The incident involved hallucinated parameter descriptions. Detection came from integrating a unit test that runs the generated doc examples against the actual API. Systemically, I implemented a two-pass prompt: first to generate, second to verify the doc against the source code context (provided via embeddings). I also added a metric tracking doc-test pass rate to our monitoring dashboard.'
1 career found
Try a different search term.