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: utomated 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).
Data Validation and Verification:
- 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.
Test Planning and Execution:
- 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.
Database Testing and Query Writing:
- 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.
Data Migration Testing:
- 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.
Collaboration and Communication:
- 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.
Documentation and Reporting:
- Document test plans, test scripts, and test results.
- Provide detailed reports on test execution, defects, and overall data quality status to project stakeholders.
Required Skills:
- 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 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 EEO page to request an accommodation or assistance regarding our policy.