Software Guidance and Assistance, Inc.
Senior Test Automation Engineer for API & Data Pipeline
Software Guidance and Assistance, Inc., New York, New York, us, 10261
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 AI tools for help with writing automated tests 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 https://sgainc.com/ .
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 EEO page to request an accommodation or assistance regarding our policy.
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 AI tools for help with writing automated tests 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 https://sgainc.com/ .
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 EEO page to request an accommodation or assistance regarding our policy.