SQL QA Automation Engineer (NYC,NY)
job summary: W2 only- no C2C, no visa candidates
must be local to NYC--- hybrid onsite role
possible temp to perm
The ideal candidate will have:
- A background in Software Development
- BA in CS or Engineering
- Experience coding in Java/Python/Groovy/OOPs
- Specifically: Intermediate -> Advanced coding in Java/Python or any other OOP and Basic -> Intermediate SQL experience
Roles and responsibilities:
- Interpreting Business Requirement Documents (BRDs)
- Communicating with stakeholders to determine accuracy of testing requirements
- Communicating with developers to keep them abreast of testing work and problems uncovered
- Building out testing suites and then running test cases through the suites developed by themselves or by others as needed
- Investigating issues in our trading stack using SQL/Kafka/Java to diagnose the loci of the issues and subsequently communicating with teams needed to fix issues as they arise
- Keeping track of issues identified using JIRA and multiple databases (MYSQL/Oracle)
Nice to haves:
- Knowledge of FIX protocol
- CAT/OATS
- Financial Knowledge
- Experience presenting results in a group setting while adhering to industry best practices
additional notes:
Seeking a Jr/Mid level OOP (Java preference but open to Python, JS or C++)- candidates must additionally have SQL experience. They will be coding up to 60% of the time depending on workflow. Okay with candidates right out of college who have an interest in investment banking.
Any automation testing exp w/ tools like java gradle or testNG framework or groovy thats a huge bonus. Open to candidates with some selenium exp as well. Team doesnt use it but could be useful.
Looking for strong Java and strong SQL candidates. All candidates must sit in NYC, 3 days/week.
Team is responsible for back-office and trade records. There are millions of stock transactions every day that need to be reported to FINRA and other government regulators. The government uses this data to see trade positions. Most reporting is automated and errors will occur.Example the data is ran through 30+ systems and in one system loses the .OQ on the report - which is a different stock purchase. The team must "find the needle in the haystack" of why/how this happened and what effect did the bad data have. Josh's team will use SQL to find the bad data and Hua's team will use Java to fix the system.
Domain experience is not required. Prior finanical expereince or related education is a plus. Polished communication skills are more important than dev skills -need to be able to work on a team. There is a possibility for full-time conversion.
Interview process: 3 roundslocation: New York, New York
job type: Contract
salary: $71.59 - 101.67 per hour
work hours: 8am to 4pm
education: Bachelors
responsibilities:Roles and responsibilities:
- Interpreting Business Requirement Documents (BRDs)
- Communicating with stakeholders to determine accuracy of testing requirements
- Communicating with developers to keep them abreast of testing work and problems uncovered
- Building out testing suites and then running test cases through the suites developed by themselves or by others as needed
- Investigating issues in our trading stack using SQL/Kafka/Java to diagnose the loci of the issues and subsequently communicating with teams needed to fix issues as they arise
- Keeping track of issues identified using JIRA and multiple databases (MYSQL/Oracle)
qualifications:
- Experience level: Experienced
- Education: Bachelors (required)
- Automated QA Testing (4 years of experience is required)
- Automated QA Testing (5 years of experience is required)
- automation testing (5 years of experience is required)
- Selenium (4 years of experience is required)
- SQL (5 years of experience is required)
- java coding (5 years of experience is required)
- python (3 years of experience is required)
- JIRA (5 years of experience is required)
- oracle (4 years of experience is required)
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.
Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).
This posting is open for thirty (30) days.