Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: SQL/QA Developer DS.
Woonsocket Jobs | Expertini

Urgent! SQL/QA Developer - DS - Local Job Opening in Woonsocket

SQL/QA Developer DS



Job description

Core Responsibilities
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.
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.
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.
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.
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.


Required Skill Profession

Computer Occupations



Your Complete Job Search Toolkit

✨ Smart • Intelligent • Private • Secure

Start Using Our Tools

Join thousands of professionals who've advanced their careers with our platform

Rate or Report This Job
If you feel this job is inaccurate or spam kindly report to us using below form.
Please Note: This is NOT a job application form.


    Unlock Your SQL QA Potential: Insight & Career Growth Guide