Technical Tester – Backend Validation

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 Dev Ops.
• 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.

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 Dev Ops 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.

• 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.