QA Engineer - Python automation + Data expertise - SGA Inc.
New York, NY
About the Job
Software Guidance & Assistance, Inc., (SGA), is searching for a QA Automation Engineer with Strong Python and Data Testing experience for a short-term CONTRACT assignment with one of our premier Financial Services clients in lower Manhattan, NYC. This is a short-term contract position through the end of 2024, with the possibility of extension in 2025 based on project needs. The position is fully remote, and candidates must be based in the U.S.
Responsibilities:
Automated Test Script Development:
Preferred:
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.
Responsibilities:
Automated Test Script Development:
- Design, develop, and maintain automated test scripts in Python to validate data integrity and business logic for large data sets.
- Create automated solutions to verify data migration and transformation processes between different database systems (e.g., Oracle, MongoDB).
- Develop automated tests to compare and validate data between source and target databases.
- Ensure data accuracy and integrity by verifying that all transformations, aggregations, and mappings are correctly implemented.
- Develop test plans and test cases based on functional and non-functional requirements for data migration and other testing scenarios.
- Execute and manage test cases, track defects, and ensure comprehensive test coverage for all relevant scenarios.
- Write complex SQL queries to extract and validate data from Oracle databases.
- Utilize MongoDB queries to validate unstructured or semi-structured data, ensuring data completeness and accuracy.
- Perform thorough testing of data migration processes to ensure data is accurately moved, transformed, and stored in the target system.
- Identify, report, and track data-related issues and work with development and data teams to resolve them.
- Work closely with data engineers, developers, and business analysts to understand data requirements and ensure proper test coverage.
- Communicate test results, findings, and recommendations to stakeholders in a clear and concise manner.
- Document test plans, test scripts, and test results.
- Provide detailed reports on test execution, defects, and overall data quality status to project stakeholders.
- 3+ years of experience in test automation using Python.
- Strong experience in database testing, including writing complex SQL queries and validating data in Oracle and/or MongoDB or equivalent.
- Experience with data migration testing, validating ETL processes, and ensuring data accuracy across different systems.
- Proficient in creating automated test frameworks and scripts to validate data integrity and business logic.
- Strong analytical and problem-solving skills, with attention to detail.
- Excellent communication and documentation skills, with the ability to work independently in a remote environment.
- Bachelor's degree in Computer Science, Information Technology, or a related field.
Preferred:
- Financial Services
- Familiarity with Agile methodologies and working in a collaborative team setting.
- Experience with testing tools and frameworks such as PyTest, Robot Framework, or similar.
- Knowledge of data integration tools like Informatica, Talend, or Apache NiFi.
- Familiarity with Agile methodologies and experience in an Agile development environment.
- Experience with version control tools such as Git and CI/CD pipelines for test automation.
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.
Source : SGA Inc.