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.

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.

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