QA Analyst - ETL and API

Overview

R5774

Employment type: Full time

Worksite flexibility: Remote Who we are
CAI is a global technology services firm with over 8,500 associates worldwide and a yearly revenue of $1 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary We are seeking a skilled Manual Tester specializing in ETL and API testing to join our team. The ideal candidate will have a strong foundation in SQL, data migration, and data integration testing, with a keen eye for detail and a methodical approach to validating complex systems and are looking for your next career move, apply now.

Job Description
We are looking for a QA Analyst (ETL and API) to perform data migration and data integration testing, validating ETL processes, data quality, and transformation rules. This position will be Full Time and remote.

What You’ll Do

Utilize strong hands-on experience in SQL to validate data across multiple layers and systems (OLTP to OLAP).

Perform data migration and data integration testing, validating ETL processes, data quality, and transformation rules.

Conduct API testing using Postman to validate REST APIs, request/response structures, and business logic.

Automate testing in Postman using JavaScript, creating test scripts for dynamic validations and workflow chaining.

Exposure to performance testing using JMeter, creating and executing load/stress test plans and analyzing performance metrics.

Employ working experience with Rest Sharp and Rest Assured libraries for API automation testing.

Develop and execute test automation frameworks using NUnit.

Identify test scenarios, create test cases, and execute tests with a focus on data-driven validation.

Familiarize with CI/CD pipelines and integrate automated tests in the deployment workflow.

Demonstrate strong debugging and analytical skills to investigate test failures and data mismatches.

Exhibit excellent communication and documentation skills for reporting test results and collaborating with cross-functional teams.

What You'll Need

Required:
Bachelor’s degree in Computer Science, Information Technology, or a related field.

Experience: 3 – 5 years

Proven experience in manual testing with a focus on APIs.

Proficient in SQL, Postman, and JavaScript for test automation.

Experience with performance testing tools like JMeter.

Familiarity with API automation testing libraries such as Rest Sharp and Rest Assured.

Knowledge of NUnit for test automation framework development.

Experience with CI/CD pipelines.

Physical Demands

Ability to safely and successfully perform the essential job functions

Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.

Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable accommodation statement
If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.