Database / ETL Test Engineer Position Available In Philadelphia, Pennsylvania

Philadelphia, PA
3 DAYS AGO
21551683
Summary
Philadelphia, PA
Competitive Salary
7 Years Experience
Bachelor’s degree
No Commisssion
40.00 hours per week / Day Shift /Full-Time
Description Reference #:

R-0000028082

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

The jobdescriptionfor 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 “rb@myworkday.com”. 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 TalentAcquisition@phil.frb.org.
We are an… For full info follow application link. The Federal Reserve Bank of Philadelphia believes that diversity and inclusion among our employees is critical to our success as an organization, and we seek to recruit, develop and retain the most talented people from a diverse candidate pool. The Federal Reserve Bank of Philadelphia is proud to be an equal opportunity workplace.