ETL QA Analyst - Financial Services - Princeton, NJ (Hybrid - 2-3 days per week onsite)

Stellent IT LLC
Princeton, NJ, United States
5 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Working hours
Regular working hours

Tech stack

Testing (Software) Java (Programming Language) Automation of Tests Bash Shell Big Data Databases Continuous Integration Data Validation Data Integrity Extract Transform Load (ETL) Relational Databases Database Queries
+24 more
Database Testing Software Debugging Linux Middleware Perl (Programming Language) Python (Programming Language) Linux Commands Microsoft SQL Server MySQL Open Source Technology Oracle (Applications) Regression Testing Data Driven Tests SQL Databases Software Testing Automation Framework Data Processing Scripting Sap Business Objects Information Technology Toad (Software) Cucumber (Software) Selenium Webdriver Jenkins Database Tools and Utilities

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.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…