Automation/SDET Test Engineer

Software Guidance & Assistance, Inc. (SGA, Inc.); New York (NY); On-site; USD 83,000 - 152,000; Part time

Job summary

Software Guidance & Assistance, Inc. (SGA), is seeking an Automation/SDET Test Engineer for a contract role with a premier financial services client in New York, NY.

The role focuses on building reusable automation components, API testing, data profiling, and DevOps-enabled test strategies. You will work in an Agile, cross-functional team environment, designing and maintaining integration test suites, handling data masking and test data pipelines, and validating REST APIs across AWS services.

Qualifications

• Hands-on experience in Java for test automation.
• Experience with Selenium or Cypress for automation testing.
• Experience in performance testing on the Cloud with LoadRunner.
• Experience designing and masking test data for data pipelines.
• Experience with SQL and relational databases.
• Experience building test automation frameworks and data integration concepts.
• Strong debugging and analytical skills to troubleshoot data transformations.
• Experience with AWS services: Data Glue, Databricks, Athena, Collibra Data Quality.
• Experience with AWS web services: S3, CloudWatch, RDS, Lambda, IAM.
• Experience in a DevOps environment with GitLab and CI/CD for test data pipelines.
• Spark knowledge to leverage Spark.
• REST API testing experience.

Responsibilities

• Develop configurable, maintainable test automation components and enable DevOps through continuous testing.
• Create test approaches aligned with business requirements and keep plans updated.
• Design, develop, and maintain integration testing suites with reusable components.
• Perform API testing and data profiling across end-to-end data tasks.
• Develop, execute, and maintain complex test cases to verify requirements.
• Analyze root causes and troubleshoot data transformation issues.
• Assist with setup/maintenance of test environments and metrics; manage automation tools and frameworks.
• Collaborate in Agile cross-functional teams to deliver high-quality solutions across environments.

Skills

Java

Selenium

Cypress

SQL

REST APIs

Data profiling

Debugging

Spark

AWS

Education

Computer Science degree preferred

Tools

Selenium

Cypress

LoadRunner

Postman

Databricks

S3

Job description

Software Guidance & Assistance, Inc., (SGA), is searching for an Automation/SDET Test Engineer for a contract assignment with one of our premier Financial Services clients in New York, NY.

Responsibilities:

• Developing configurable, maintainable, reusable, and dependable test automation components and enabling DevOps through continuous testing.
• Creating test approaches and understanding how a system works. Ensuring that test plans properly align with business requirements and are kept up to date.
• Designing, developing, and maintaining integration testing suite to ensure reusable common components meeting quality and security standards.
• API Testing
• Data profiling included end to end starting with data ingestion and all related data tasks including test data creation.
• Develops, executes, and maintains complex test cases to ensure the system functions according to requirements and document defects with supporting documentation.
• Analyze moderate to complex problems to determine the root cause of the issue and conduct tests that will help in duplicating or troubleshooting.
• Assists with setup and maintenance of test environments; developing and maintaining metrics related to software testing and ongoing application performance; implementation, upgrades, and training of automated test management tools; research and evaluation of testing tools and frameworks; planning and development of test strategy and plans; and analyzing test process automation strategy and framework.
• Collaborating in Agile cross-functional teams to deliver solutions with high quality across different technical environments.
  

Required Skills:

• Hands-on experience in a programming language like Java to build test automation
• Experience with automation testing frameworks like Selenium, Cypress etc
• Experience in performance testing on the Cloud with tools such as LoadRunner
• Hands-on experience designing and masking test data based on the user scenarios/rules and building scripts to test data pipelines for data lake/ data warehouse ecosystem
• Data validations using SQL, strong understanding of the relational database concepts and models
• Experience building test automation frameworks, tools, and strong SQL, data management concepts including data profiling, data mapping and data integration
• Strong debugging/analytical skills including dissecting transformation rules, data inconsistencies, incompleteness of data
• Demonstrated ability of working with AWS services such as Data Glue, Databricks, Athena, and Collibra Data Quality Platform
• Hands-on experience using webservices in AWS Cloud like S3, CloudWatch, RDS, Lambda and IAM
• Experience working in a DevOps environment, Gitlab and hands on experience using CI/CD systems preferred to enable test data pipeline
• Methodologies and practices need to be followed to make a good Quality Assurance Engineer
• Solid knowledge in Spark and experience in leveraging Spark
• Experience in REST APIs
  

Preferred Skills:

• Education: Computer Science Major preferred
• Knowledge in Python is preferred
• Experience in Postman is preferred
  

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.