Technical Tester – Backend Validation
Posted 2
views
Summary
Remote technical tester supporting an SSIS migration: day to day you execute and validate SSIS 2016/2022 ETL workflows, compare legacy vs. upgraded environments for data parity, and document test evidence in Azure DevOps. Core tech: SSIS, SQL Server/T-SQL, Azure DevOps, workload orchestration tools.
This is a remote position.
Job Objective: Technical Tester with strong knowledge of SQL Server Integration Services (SSIS) and backend data validation to support an SSIS migration initiative. This role is highly technical, focusing on validating ETL processes, verifying data accuracy across environments, and ensuring full functional parity between legacy and upgraded systems.
Responsibilities:
- Execute and validate backend processes developed in SSIS 2016/2022.
- Perform end-to-end testing of ETL workflows, data flows, and file generation.
- Compare outputs between legacy and upgraded environments to confirm data parity and functional equivalence.
- Document validation results, test cases, and comparison evidence in Azure DevOps.
- Collaborate with developers and technical leads to identify and resolve data or configuration discrepancies.
- Support QA and UAT certification by providing test evidence and validation reports.
Requirements
3–5 years of experience in: Testing and validating ETL/ELT processes using SSIS.
Plus: Bachelor’s degree in computer science, Information Technology, Systems Engineering, or a related field.
Required Skills:
- Experience testing and validating ETL/ELT processes in SSIS.
- Strong SQL Server and T-SQL skills for data verification and troubleshooting.
- Familiarity with CA Workload Automation (ESP dSeries) or similar orchestration tools.
- Experience with Azure DevOps for documentation, validation tracking, and reporting.
- Understanding of SSISDB catalog deployments, environment variables, and package configurations.
- Highly detail-oriented with strong analytical and documentation skills.
- Excellent collaboration and communication abilities with technical teams.
Soft Skills:
- Analytical thinking & attention to detail – Crucial for identifying data discrepancies and ensuring accurate validation.
- Effective communication – To clearly document findings and collaborate with technical teams.
- Problem-solving mindset – To troubleshoot and resolve issues in complex ETL processes.
- Team collaboration – Ability to work closely with developers, QA, and leads in a technical environment.
- Time management & organization – Essential for meeting deadlines in a fast-paced, short-term project.
Benefits
We offer a competitive package with several advantages.