Database ETL Test Engineer

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.

The job description below is a dual grade job posting.

Candidates who possess a slightly lower level of experience, education, or qualifications may also be considered.

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 throughout 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:

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 and Subversion.


* 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.


* 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.


* Mentors QA Engineers by providing direction and guidance when needed.


* Participate on project teams as a senior QA Engineer.


* Participate on Bank, department, or system projects of moderate to high complexity.

Demonstrates effective Core Competency skills for gr...