QA Automation Tester with AWS cloud Integration - Hybrid in Mercer County, New Jersey

Seeking a Senior QA Analyst with 7+ years of experience to validate enterprise data pipelines & cloud integrations. This role balances automated testing with essential manual validation to ensure absolute data integrity across our cloud data stack.

You will own data quality and regression testing for our cloud data platform, ensuring seamless data flow and transactional consistency from our source systems into our data warehouse. This role requires a balance of building automated checks and performing hands-on manual data reconciliation to quickly isolate anomalies.

• Build and maintain scalable test automation frameworks while performing strategic manual data validation across cloud data pipelines.
• Write complex, high-performance SQL queries for deep-dive data reconciliation, schema validation, and end-to-end data integrity checks.
• Validate transactional consistency and data object mapping between Salesforce and downstream data platforms.
• Utilize automated testing tools to support Salesforce environments, with experience in Copado Robotic Testing considered a major plus.
• Integrate automated quality gates and data tests directly into DevOps and CI/CD deployment pipelines.
• Collaborate closely with data engineering and cloud architecture teams to troubleshoot and resolve pipeline anomalies.

Required/Desired Skills

Skill	Required /Desired	Amount	of Experience
Data / QA Automation Experience	Required	7	Years
Advanced SQL Querying	Required	7	Years
Manual Backend / Data Validation	Required	7	Years
AWS Core Cloud Services	Required	3	Years
Snowflake (or competitor like Databrick/BigQuery/Reshift)	Required	3	Years
DBT (data build tool) Validation	Highly desired	2	Years
Salesforce Data Integration	Highly desired	3	Years
Copado Robotic Testing	Desired	1	Years

Questions

No.	Question
Question1	Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question2	Please list candidate's email address HERE.
Question4	Where is the candidate currently geographically located?