Senior API Test Automation Engineer for API and Data Pipeline Testing

Title: Senior API Test Automation Engineer for API & Data Pipeline Testing

Location: NYC - Candidate should follow EST Time - Remote

Duration: 6+ months

Rate: $Market All Inclusive

1. Purpose

The purpose of this Statement of Work (SOW) is to define the responsibilities and deliverables of a Senior API Test Automation Engineer engaged to design, develop, and maintain automated testing solutions for REST APIs, Kafka data ingestion pipelines, and backend validations for FDR Squad.

2. Scope of Work

The Senior API Test Automation Engineer will be responsible for the following:

• API Testing:
• Design, develop, and execute automated tests for RESTful APIs.
• Create test cases to validate API endpoints for functional, regression, performance, and security requirements.
• Implement negative and edge case testing to ensure robust API behavior.
• Kafka Data Ingestion Testing:
• Develop automated tests to validate data ingestion and processing through Kafka topics.
• Ensure data integrity, completeness, and correctness as data flows through Kafka pipelines.
• Implement mechanisms to monitor and verify message delivery and processing.
• Backend Validation:
• Perform data validation and verification in backend data stores (e.g., Mongo and Oracle databases, data lakes) post-ingestion.
• Develop and execute queries/scripts to validate business logic and data transformations.
• Ensure data consistency and accuracy across integrated systems.
• Automation Framework & Tools:
• Design and maintain scalable, reusable automation frameworks using industry-standard tools (e.g., Postman, RestAssured, Pycharm, JMeter, Apache Kafka clients, etc.) and languages - Python, Java etc.
• Integrate test automation into CI/CD pipelines like Bamboo, Github etc.
• Document test plans, test cases, and results.
• Collaboration & Reporting:
• Work closely with developers, DevOps engineers, QA, and product teams to understand requirements and resolve issues.
• Provide regular status updates, defect reports, and metrics to stakeholders.

3. Deliverables

• Automated test scripts and frameworks for REST APIs and Kafka data pipelines.
• Comprehensive test cases, execution report and supporting documentation.
• Documentation of automation setup and maintenance procedures.