Database / ETL Test Engineer

Jobs via Dice; Philadelphia (Philadelphia County); On-site; USD 90,000 - 105,000; Full time

Job summary

A leading financial institution, the Federal Reserve Bank of Philadelphia seeks a talented QA Engineer specialized in data quality assurance. This role involves designing test procedures, collaborating with diverse teams, and ensuring quality across complex systems while providing mentorship to junior staff. Candidates should bring extensive experience in testing and automation, alongside a collaborative, innovative mindset.

Benefits

401k with employer match

Flexible Work Schedule

Tuition Reimbursement

Paid Vacation/Sick Time & Holidays

Onsite Fitness Center

Qualifications

• Minimum 7 years of experience in software testing.
• 5 years of automation development experience required.
• CTFL and Product Specific Certifications preferred.

Responsibilities

• Develop data verification and validation procedures for ETL processes.
• Automate testing workflows using various tools and programming languages.
• Mentor junior QA Engineers in quality assurance practices.

Skills

Complex SQL

Data validation

Agile methodologies

Problem-solving

Collaboration

Testing automation

Education

Bachelor's degree in Information Technology or Computer Science

Tools

Databricks

Apache Spark

Tableau

AWS cloud platform

Python

Linux scripting

Job description

1 week ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Federal Reserve Bank of Philadelphia, is seeking the following. Apply via Dice today!

Company

Federal Reserve Bank of Philadelphia

The Federal Reserve Bank of Philadelphia is one of the 12 regional Reserve Banks that, together with the Board of Governors in Washington, D.C., make up the Federal Reserve System. It helps formulate and implement monetary policy, supervises banks and bank and savings and loan holding companies, and provides financial services to depository institutions and the federal government. The Federal Reserve Bank of Philadelphia serves eastern and central Pennsylvania, southern New Jersey, and Delaware.

This Job Description is for the Information Technology Job Family and could include anyone within the ITS department that performs these tasks. You have knowledge of and are able to perform actions that are related to activities in the designated business line. The QA Engineer position designs or modifies testing/data validation/quality assurance for automated applications and procedures for solutions to business problems of moderate to high complexity. Also have full operational knowledge of all phases of testing and can work at a high level of complexity related to quality assurance, while working automatously. You will Direct and review work of lower-level personnel and may perform as an individual contributor on large and complex systems. Have a working knowledge of one or more FRS system testing platforms.

The Federal Reserve Bank of Philadelphia works two days per week onsite. Starting on September 2nd, 2025, all Bank employees will work full-time on site. By applying to this position, you agree you will be available to work on-site in a full-time capacity starting on September 2nd, 2025.

You are a creative problem-solver, and an experienced tester with a focus on data testing over the length of your career. A willingness to participate in professional development activities to stay current on industry knowledge is important. You should bring innovative thinking and a curious attitude. You will have an essential role in migrating an on-prem data warehouse/data visualization solution to the cloud. A collaborative mindset is necessary, as the knowledge required to fulfill responsibilities will be obtained through conversation with developers, the product owner, and other QE resources.

Technical skills including complex SQL, Databricks, Apache Spark, Tableau, and AWS cloud platform will be immediately applicable. Knowledge of Python, Linux scripting, and REST APIs will also be relevant.

Experience Working With a Dynamic Agile Team Is Helpful.

What You Will Do:

• Develop comprehensive data verification and validation for backend data-oriented systems using modern frameworks such as Pandas, Informatica and other industry tools approved for use at FRS as applicable. Using scripting/programming languages like Python and R with a modern IDE (Anaconda, Jupyter notebook, or similar), and source code management products like GIT.
• Develop solutions to automate testing of databases and ETL processes built using technologies and frameworks such as SSIS, Oracle Integration products, Data Warehouse products and other industry tools approved for use at FRS as applicable.
• Work with key SMEs such as the Product Owner, System Architect, and Project Manager to plan the test automation strategy/approach for scalable/risk-based test coverage; inculcate the development and execution of scripts/scenarios and mining/creation of custom and applicable testing data.
• Incorporate the tests aligned with the application under test database schemas using complex stored procedures and queries in environments such as SQLServer, Oracle, or similar.
• Participate in Bank, department, or system projects of higher complexity.
• Demonstrate Core Competency skills for grade and position.
• Involved in the accomplishment of departmental and Bank wide quality projects.
• Comply with all applicable information, security policies, guidelines, and practices.
• Mentor junior QA Engineers by providing direction and guidance when needed. with a concentration in Information Technology or Computer Science or equivalent significant experience in information technology and software testing is required.
  
  

What You Have:

Knowledge and Skills:

• Independently, present both orally and in writing, findings and assessments; prepare and present information and responses to higher complexity inquiries; demonstrate the ability to manage the communication process; communicate with clients, colleagues and management to explain complex issues concisely.
• Engage in transferring technical knowledge; diffuse conflict and build agreement.
• Experience weighing specific technical tradeoffs to maximize impact for effort and problem-solving skills.
• Possess a logical, analytical and creative approach to problems; Demonstrate expert level analytical and problem-solving skills; organize data in a manner that communicates issues; identify underlying issues and recognizes symptoms that indicate more severe issues.
• Lead and participate effectively on a team; lead complex and diverse team efforts by virtue of both technical expertise and leadership skills of influence; draw on experience to resolve higher complexity issues; display strong interpersonal skills in dealing with people at all levels of an organization.
• Have a meticulous and organized approach to work; Identify and assess higher complexity supervisory issues; manage higher complexity issues to meet our objectives and goals.
• Excellent knowledge of multiple systems and technologies with an ability to stay informed about relevant technology trends and developments.
• An awareness of current issues affecting the industry and its technologies.
• Subject to minimal or no oversight in work performed; serve as mentor and coach and provide constructive feedback to less experienced staff; engages other partners in collecting feedback and input to complete work activities.
  
  

Education and Experience:

• Bachelor's degree with a concentration in Information Technology or Computer Science or equivalent significant experience in information technology and software testing is required.
• CTFL and Product Specific Certifications as applicable per track are preferred.
• Minimum 7 years of experience designing and developing tests for ETL and Data Warehouse solutions using a software development approach. Minimum 5 years of automation development experience with technologies described above.
  
  

This position has been identified to follow the DATABASE/DATA VALIDATION TESTING TRACK.

Description

The job description for this role includes multiple tracks.

The salary grade for this position is: Grade 15. Final salary and offer will be determined by the applicant's background, experience and skills, as well as internal equity and alignment with market data.

We offer a great benefits package that features:

• Medical (4 options), Prescription, Dental (3 options), and Vision Insurance with no waiting period
• 401k/Thrift Plan with generous employer match
• Employer-funded Pension Plan
• Paid Vacation/Sick Time & Holidays
• Monthly $120 Commuter Allowance
• Flexible Spending Accounts and Healthcare Spending Accounts
• Flexible Work Schedule available in most departments
• Life Insurance and Long Term Disability Insurance
• Tuition Reimbursement (undergraduate and graduate)
• Parental Leave
• Free onsite 24/7 Fitness Center including training classes, Peloton bikes and locker room / shower facilities
• Onsite Cafeteria & Coffee Shop
• Additional Convenience Benefits, Discounts and More...
  
  

Additional Information:

• The Federal Reserve Bank of Philadelphia takes your information privacy seriously. Federal Reserve Bank of Philadelphia staff will only email you from the "@ phil.frb.org " domain or through the Workday system " ". If you are initially contacted by phone, feel free to request that the caller provide you with their email address to validate their identity. If you have any questions about the validity of someone who contacts you regarding this position, please email the Talent Acquisition team at .
• We are an equal opportunity employer committed to hiring the best candidates and to providing equal employment opportunity to all persons without regard to race, color, religion, sex, pregnancy, national origin, age, genetic information, disability, military service, or any other basis protected by law.
• We will ensure that individuals with disabilities are provided reasonable accommodations to participate in the job application or interview process, to perform essential job responsibilities, and to receive other benefits and privileges of employment. If you need assistance or an accommodation due to a disability, please email us at
• All Federal Reserve Bank of Philadelphia employees must comply with the Bank's ethics rules, which generally prohibit employees, their spouses/domestic partners, and minor children from owning securities, such as stock, of banks or savings associations or their affiliates, such as bank holding companies and savings and loan holding companies. If you or your spouse/domestic partner or minor child own such securities and would not be willing or able to divest them if you accepted an offer of Bank employment, you should raise this issue with the Recruiter for this posting, who can provide you contact information for our ethics officer if necessary. You should review the Bank's Employee Code of Conduct to ensure compliance with conflict of interest rules and personal investment restrictions.
• Background investigations and drug testing are required for all new hires as a condition of employment, after the job offer is made. Candidates for positions deemed as "safety sensitive" will also be screened for the presence of marijuana. Employment may not begin until the Bank accepts the results of the background investigation.
• Due to the nature of the information, you will have access to, we require that you also complete a more in-depth enhanced background screening (Peraton high).
• All employees will be subject to FBI fingerprint / criminal background and Patriot Act/ Office of Foreign Assets Control (OFAC) watch list checks at least once every five years.
• This position requires access to confidential supervisory information and/or FOMC information, which is limited to "Protected Individuals" as defined in the U.S. federal immigration law. Protected Individuals include, but are not limited to, U.S. citizens, U.S. nationals, and U.S. permanent residents who either are not yet eligible to apply for naturalization or who have applied for naturalization within the requisite timeframe. Candidates who are permanent residents must sign a declaration of intent to become a U.S. citizen when eligible to do so and pursue a path to citizenship. Candidates who are not U.S. citizens or U.S. permanent residents may be eligible for the information access required for this position if they sign a declaration of intent to become a permanent resident and a U.S. citizen and meet other eligibility requirements. In addition, all candidates must undergo an applicable background check and comply with all applicable information handling rules.
• The above statements are intended to describe the general nature, level of work and the requirements of this position. They are not intended to be an exhaustive list of all responsibilities associated with this position or the personnel so classified. While this job description is intended to be an accurate reflection of this position, management reserves the right to revise this or any job description at its discretion at any time.
• The Federal Reserve Bank of Philadelphia works two days per week onsite. Starting on September 2nd, 2025, all Bank employees will work full-time on site. By applying to this position, you agree you will be available to work on-site in a full-time capacity starting on September 2nd, 2025.
• Learn more about the Philly Fed and its culture. Learn more about working for the Philly Fed.
  
  

Full Time / Part Time

Full time

Regular / Temporary

Regular

Job Exempt (Yes / No)

Yes

Job Category

Information Technology Family Group

Work Shift

First (United States of America)

The Federal Reserve Banks are committed to equal employment opportunity for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.

Always verify and apply to jobs on Federal Reserve System Careers ( ) or through verified Federal Reserve Bank social media channels.

Privacy Notice

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Software Development

Referrals increase your chances of interviewing at Jobs via Dice by 2x

Sign in to set job alerts for “Test Engineer” roles.

Quality Assurance Engineer III: 25-05169

Malvern, PA $90,000.00-$105,000.00 3 days ago

Quality Assurance Engineer, Ring Subscriptions

Philadelphia, PA $95,000.00-$105,000.00 7 hours ago

AI / Machine Learning Engineer (early-career, on-site full time)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.