SQL Developer -tSQLt
Posted 1 day ago by 1762352618
Negotiable
Outside
Remote
USA
Summary: The SQL Developer with Testing role focuses on utilizing T-SQL expertise to perform data reconciliation and debugging using SQL Profiler. The position is fully remote and is expected to last for three months with potential extensions or conversion to a permanent role. Candidates must be W2 consultants and possess skills in version control and unit testing frameworks.
Key Responsibilities:
- Utilize T-SQL for complex queries and data manipulation.
- Perform performance tuning and debugging using SQL Profiler.
- Conduct data reconciliation by comparing large datasets.
- Manage test scripts using version control tools like Git.
- Implement unit testing frameworks such as tSQLt or custom solutions.
Key Skills:
- T-SQL expertise with knowledge of joins, subqueries, CTEs, and window functions.
- Experience with SQL Profiler for performance tuning.
- Ability to efficiently compare large datasets for data reconciliation.
- Familiarity with version control systems like Git.
- Experience with unit testing frameworks, particularly tSQLt.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Position : SQL Developer with Testing -2 Opening
Location : 100% Remote
Duration: 3 month + extensions and possible conversion (CTH)
Only W2 Consultants
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