SSIS ETL Validation Engineer

SmartLogix

United States

Remote

USD 90,000 - 120,000

Full time

14 days+

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Job summary

SmartLogix is seeking a Technical Tester with strong SSIS knowledge to validate ETL processes during an SSIS migration initiative. The role focuses on backend data validation, ensuring data accuracy across environments and functional parity between legacy and upgraded systems.

The candidate will execute SSIS jobs, perform end-to-end ETL testing, document results, and collaborate with developers and QA leads to resolve data discrepancies. A strong analytical mindset and teamwork are essential.

Qualifications

3–5 years of experience testing and validating ETL/ELT using SSIS.
Bachelor’s degree in Computer Science, Information Technology, Systems Engineering, or related field preferred.
Strong SQL Server and T-SQL skills for data verification and troubleshooting.
Experience with Azure DevOps for documentation, validation tracking, and reporting.

Responsibilities

Execute and validate backend processes developed in SSIS 2016/2022.
End‑to‑end testing of ETL workflows, data flows, and file generation.
Compare outputs between legacy and upgraded environments to confirm data parity.
Document validation results, test cases, and evidence in Azure DevOps.
Collaborate with developers and technical leads to resolve data/configuration discrepancies.
Support QA/UAT certification by providing test evidence and validation reports.