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