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 Federal Reserve Bank of Philadelphia is looking to fill a position in the Software Quality Assurance group of the Information Technology Services (ITS) Department.

We promote new ways for building and delivering software solutions for the various departments of the Federal Reserve System. 

We are looking for a motivated ETL and Database Test Engineer who will review design and data flow documentation, verify target system structure and its schema, and the constraints applied in the system.

You will perform data completeness and reconciliation, and data quality validation.

We ask that you have QA experience with a focus on data, knowledge of data pipelines from raw data to reporting, and SQL expertise.

You will work with the Data modeler, Scrum teams and Product Manager to address how to provide better quality coverage for the applications supported. 

Job Summary: 

You are a creative problem-solver, comfortable both navigating an application front-end and running scripts on the back end.

A Willingness to participate in professional development activities to stay current on industry knowledge is important.

To be successful in this role, you will be asked to understand business logic and our needs, by Experience communicating updates and resolutions to customers and other partners, innovative thinking and curious attitude.

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, Linux / curl scripting, Python, and REST API knowledge, will be immediately applicable to project work.

The project assignment will involve understanding a complex system with on-prem and cloud resources separated into DEV, QA, and PROD regions.

Think systemically.

Experience working a dynamic Agile team is helpful. 

 

What You Will Do: 


* Develop and execute data and ETL test scenarios/scripts for complex business rules using available testing tools 



* Review interface design documents, analyze requirements and work with flat files, database dumps, XML/XSD to achieve expected results 



* Perform root cause analysis, database validation, and data defect identification using SQL 



* Create/Identify test data to validate functional and technical requirements 



* Activities supporting Database testing: 



* Trace re...