Intermediate Application Software Quality Engineer (ETL Testing)

About the role

UPS is looking for a skilled tester with strong experience in ETL testing, data validation and database workflows. The ideal candidate has a solid foundation in manual testing, a deep understanding of software testing principles and hands-on experience with ETL processes, SSIS packages and SSRS reports. Exposure to test automation is a plus but not a core requirement.

Key responsibilities

• Develop and execute manual test cases based on requirements, data mappings and system flows.
• Perform ETL testing: source-to-target mapping validation, data transformation and data quality checks, and validation of SSIS workflows, jobs and stored procedures.
• Test SSRS reports for accuracy, layout, filters and performance.
• Run database tests using complex SQL queries for data verification.
• Ensure functional, regression, smoke and database test coverage.
• Work with developers, data engineers, BI teams, product owners and QA leads to ensure end-to-end data quality.
• Carry out root cause analysis and propose preventive measures for recurring issues.
• Evaluate and recommend tools, techniques and improvements for ETL and data testing.
• Help design or support automated test scripts for ETL, web or API testing if required.

Required profile

• 4-8 years of experience in ETL testing and database testing.
• Strong SQL skills for data validation and troubleshooting.
• Hands-on experience with SSIS (ETL packages) and SSRS (reporting).
• Understanding of data warehousing concepts and ETL workflows.
• Experience testing stored procedures, SQL jobs and data integrations.
• Knowledge of test management tools (JIRA, TestRail, Zephyr).
• Experience with cloud platforms (AWS, Azure or GCP).
• Strong analytical, problem-solving and communication skills, with a curiosity for continuous learning.

Required skills

• Familiarity with REST API testing (Postman, RestAssured, Karate)
• Exposure to CI/CD pipelines and version control (Git, Jenkins)
• Test automation tools such as Selenium, Playwright, Cypress or API automation frameworks are a plus