Senior Test Automation Engineer for API & Data Pipeline

Software Guidance & Assistance, Inc., (SGA), is searching for a Senior Test Automation Engineer for API & Data Pipeline for a CONTRACT assignment with one of our premier Financial Services clients in lower Manhattan, New York City. Fully remote is possible for exceptional candidates.

Responsibilities :

• Design, develop, and maintain automated framework and tests for RESTful APIs using Python-Requests or Java-RestAssured, Postman, and other tools.
• Build reusable and modular automation framework tailored API validations and data comparison against DBs - Mongo and Oracle.
• Develop test scenarios to validate functional, regression, performance, and security aspects of APIs.
• Implement edge case and negative testing strategies to ensure API robustness.
• Automate validation of Kafka data ingestion pipelines, verifying data flow through Kafka topics.
• Monitor and verify Kafka message delivery, consumption, and processing accuracy.
• Validate and verify backend data in MongoDB, Oracle, and data lake environments programatically.
• Write complex SQL and NoSQL queries to confirm business logic and data transformation accuracy.
• Ensure data consistency and completeness across systems after ingestion and processing.
• Integrate automation frameworks into CI/CD pipelines using tools like Bamboo and GitHub Actions.
• Create and maintain test documentation, including test plans, test cases, and result reports.
• Work closely with developers, QA, DevOps, and product teams to align on testing strategy.
• Track and report defects; provide root cause analysis and test metrics to stakeholders.
• Support knowledge transfer through documentation and collaboration.
• Provide regular status updates during daily stand-ups, weekly syncs, and bi-weekly reports.

Required Skills :

• 6+ years of experience in API test automation with a strong focus on backend and data pipeline validation.
• Hands-on experience with Postman, Requests, RestAssured, JMeter, or similar tools.
• Strong programming/scripting skills in Python and/or Java.
• Experience with Apache Kafka, including message validation and monitoring.
• Solid understanding of data storage systems like MongoDB, Oracle, and data lakes.
• Experience writing complex queries (SQL and NOSQL) for data validation and transformation testing.
• Proficiency in integrating automation with CI/CD tools like Bamboo, GitHub, or Bitbucket.
• Familiarity with backend testing best practices including mock services and test data strategy.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently and lead testing efforts across distributed teams.
• Bachelor's degree in Computer Science, Engineering, or a related technical discipline
• Financial services is a plus

SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .

SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.