SQL DEVELOPER

Overview

Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)

Skills

t SQL
t-sql
testing

Job Details

Role: SQL DEVELOPER
Location: Remote. Needs to be okay working Eastern Hours. Duration: 3-6 Months Contract
Required Skills: T-SQL Expertise, Data Reconciliation, Azure DevOps, JIRA
Job Description:
Qual notes:
Focuses on validating the integrity, performance, and functionality of SQL-based processes. This role will not just be writing queries will include testing, profiling, and ensuring correctness of data flows and transformations.
Core Responsibilities

  1. Unit Testing SQL Code
    • Validate logic in stored procedures, views, and functions.
    • Write test cases to verify expected vs. actual outputs.
    • Use frameworks or custom scripts to automate test execution.
  2. Functionality Checks
    • Ensure SQL code performs as intended across different scenarios.
    • Validate joins, aggregations, filters, and business logic.
    • Confirm that data transformations align with business rules.
  3. SQL Profiling & Performance Analysis
    • Use tools like SQL Profiler to monitor query execution.
    • Identify bottlenecks, long-running queries, and inefficient operations.
    • Recommend indexing or query refactoring.
  4. EDI & ETL Validation
    • Validate incoming/outgoing EDI files for structure and content.
    • Ensure ETL pipelines correctly extract, transform, and load data.
    • Perform reconciliation between source and target systems.
  5. Query Search for Automation
    • Develop reusable queries/scripts to automate repetitive QA tasks.
    • Build utilities for data comparison, anomaly detection, or regression testing.

Skills Needed

  • T-SQL Expertise: Deep understanding of joins, subqueries, CTEs, window functions, etc.
  • SQL Profiler: For performance tuning and debugging.
  • Data Reconciliation: Ability to compare large datasets efficiently.
  • Version Control: Git or similar tools for managing test scripts.
  • Unit Testing Frameworks: Like tSQLt or custom-built solutions.
  • Defect Tracking: Use of tools like Azure DevOps, JIRA, etc.

Nice to have

  • ETL Tools: Familiarity with SSIS or other ETL platforms.
  • EDI Standards: Understanding of formats like X12, EDIFACT, etc.

Soft Skills

  • Analytical Thinking: Ability to dissect complex logic and find edge cases.
  • Communication: Ask clarifying questions and document findings clearly.
  • Initiative: Proactively identify issues and suggest improvements.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.