ETL QA Analyst - Financial Services - Princeton, NJ (Hybrid - 2-3 days per week onsite)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+24 more
Job description
We are seeking an experienced QA Analyst with a strong background in database testing, data validation, ETL testing, SQL, and Business Intelligence (BI) solutions. The ideal candidate will have experience testing complex financial systems, validating large volumes of data, comparing reports, and ensuring data accuracy and integrity. This role focuses heavily on database and data-driven testing, including the use of BusinessObjects, SQL, and Beyond Compare to identify discrepancies across large datasets and reports. Important candidate preferences: Candidates should demonstrate career stability, with no frequent job changes. Candidates with extensive contracting-heavy work histories are not preferred. BusinessObjects experience is mandatory. Key Responsibilities Develop comprehensive test strategies, test plans, test cases, and use cases to ensure high-quality software delivery. Review business requirements and functional specifications to identify testing scenarios and validate expected system behavior. Perform database testing, SQL-based data validation, ETL testing, and report comparisons. Use Beyond Compare to analyze and compare large volumes of data across different formats. Test BusinessObjects reports and validate the accuracy, completeness, and consistency of business data. Perform manual and automated testing of user interfaces, business intelligence solutions, transaction-processing systems, and middleware applications. Execute SQL queries and investigate database records, application logs, and system behavior to identify defects. Track test failures, document defects, coordinate remediation, and validate fixes. Develop and maintain automated regression testing tools, scripts, and procedures. Perform testing using Linux command-line tools and database utilities. Collaborate with developers, business analysts, and other stakeholders to resolve complex technical issues. Required Qualifications
Requirements
Bachelor’s degree or equivalent in Computer Science, Engineering, or a related field. 5+ years of experience in software QA and testing. 2+ years of experience with automated testing tools. Strong SQL skills, including writing, debugging, and validating queries. Experience with relational databases such as Oracle, SQL Server, or MySQL. Mandatory experience with BusinessObjects testing. Experience with database testing, data integrity validation, and large-volume data comparisons. Experience with Beyond Compare or a similar data comparison tool. Thorough knowledge of the Linux command-line interface. Experience with Selenium WebDriver. Understanding of ETL workflows and data validation processes. Familiarity with database tools such as TOAD. Strong analytical, troubleshooting, and problem-solving skills. Excellent communication, organization, and teamwork skills. Preferred Qualifications Experience in regulated financial markets across multiple asset classes. Familiarity with stock market terminology and financial transaction-processing systems. Experience with OneTick or similar time-series databases. Basic knowledge of Python, Shell, Perl, or other scripting languages. Experience developing automated regression testing scripts. Familiarity with CI/CD platforms such as Jenkins. Experience with open-source test automation frameworks, preferably BDD tools such as Cucumber. Basic knowledge of Java. Ideal Candidate Profile The ideal candidate will be a hands-on QA professional with strong database and data-centric testing experience, capable of validating complex financial data and identifying discrepancies across reports and systems. Candidates should have a stable employment history and be comfortable working in a hybrid environment in Princeton, NJ. Core technical skills: SQL, BusinessObjects, Beyond Compare, Database Testing, ETL Testing, Linux, Selenium WebDriver, Data Validation, and Regression Testing.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this role…