ETL Database Quality Engineer
ETL Database Quality Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Company
Federal Reserve Bank of PhiladelphiaThe 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 grade and position. Performs other related duties as assigned. Actively involved in the accomplishment of departmental and Bank wide quality initiatives. Complies with all applicable information security policies guidelines and practices.
Knowledge and Skills:
- Excellent written and oral communications skills.
- Independently presents both orally and in writing findings and assessments; prepares and presents information and responses to highly complex inquiries; demonstrates the ability to manage the communication process; the ability to communicate with clients colleagues and management to explain complex issues clearly and concisely; actively engages in transferring technical knowledge; diffuses conflict and builds consensus.
- Excellent analytical and problem-solving skills.
- Possesses a logical analytical and creative approach to problems; Demonstrates expert level analytical and problem-solving skills; organizes data and information in a manner that effectively communicates issues; identifies underlying issues or problems and recognizes symptoms that indicate more severe problems or issues.
- Excellent interpersonal skills.
- Demonstrates the ability to lead and participate effectively on a team; leads complex and diverse team efforts by virtue of both technical expertise and leadership skills of influence; recognizes the value that different perspectives and cultures bring to an organization; draws on experience to resolve highly complex issues; displays strong interpersonal skills in dealing with people at all levels of an organization.
- Excellent time management skills.
- Possess a meticulous and organized approach to work; Identifies and assesses highly complex supervisory issues; effectively manages highly complex issues to meet our objectives and goals.
- Excellent knowledge of various computer systems and technologies with an ability to learn new skills and technology quickly. An awareness of current issues affecting the industry and its technologies.
- Subject to minimal or no oversight in work performed; serves as mentor and/or coach and provides constructive feedback to less experienced staff; engages other stakeholders in collecting feedback and input to complete work activities.
Education and Experience:
- Bachelors degree with a concentration in Information Technology or Computer Science or equivalent significant experience in information technology and software testing is required.
- Minimum of 7 years of experience designing and developing tests for ETL and Data Warehouse solutions using a software development approach.
- Minimum of 5 years of automation development experience with technologies described above.
This document indicates the general nature and level of work performed by employees within this position. It is not a comprehensive inventory of all duties responsibilities and qualifications required of employees assigned to this job. An employees responsibilities tasks and duties might differ from those outlined in the job description and other duties as assigned are a part of the job. The Federal Reserve Bank of Philadelphia reserves the right to modify the elements of this job description as business needs require.
This position has been identified to follow the DATABASE/DATA VALIDATION TESTING TRACK.
The jobdescription for this role includes various testing tracks.
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 @ domain or through the Workday system . 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 .
We are an equal opportunity employer committed to hiring the best candidates and to providing equal employment opportunity to all persons without regard to race color religion sex pregnancy national origin age genetic information disability military service or any other basis protected by law.
We will ensure that individuals with disabilities are provided reasonable accommodations to participate in the job application or interview process to perform essential job responsibilities and to receive other benefits and privileges of employment. If you need assistance or an accommodation due to a disability please email us at
All Federal Reserve Bank of Philadelphia employees must comply with the Banks ethics rules which generally prohibit employees their spouses/domestic partners and minor children from owning securities such as stock of banks or savings associations or their affiliates such as bank holding companies and savings and loan holding companies. If you or your spouse/domestic partner or minor child own such securities and would not be willing or able to divest them if you accepted an offer of Bank employment you should raise this issue with the Recruiter for this posting who can provide you contact information for our ethics officer if necessary. You should review the Banks Employee Code of Conduct to ensure compliance with conflict of interest rules and personal investment restrictions.
Background investigations and drug testing are required for all new hires as a condition of employment after the job offer is made. Candidates for positions deemed as safety sensitive will also be screened for the presence of marijuana. Employment may not begin until the Bank accepts the results of the background investigation.
Due to the nature of the information you will have access to we require that you also complete a more in-depth enhanced background screening (Peraton r high).
All employees will be subject to FBI fingerprint / criminal background and Patriot Act/ Office of Foreign Assets Control (OFAC) watch list checks at least once every five years.
This position requires access to confidential supervisory information and/or FOMC information which is limited to Protected Individuals as defined in the U.S. federal immigration law. Protected Individuals include but are not limited to U.S. citizens U.S. nationals and U.S. permanent residents who either are not yet eligible to apply for naturalization or who have applied for naturalization within the requisite timeframe. Candidates who are permanent residents must sign a declaration of intent to become a U.S. citizen when eligible to do so and pursue a path to citizenship. Candidates who are not U.S. citizens or U.S. permanent residents may be eligible for the information access required for this position if theysign a declaration of intent to become a permanent resident and a U.S. citizen and meet other eligibility addition all candidates must undergo an applicable background check and comply with all applicable information handling rules. Certain eligibility rules apply. You will provide work authorization to prove your eligibility to work in the United States.
The above statements are intended to describe the general nature level of work and the requirements of this position. They are not intended to be an exhaustive list of all responsibilities associated with this position or the personnel so classified. While this job description is intended to be an accurate reflection of this position management reserves the right to revise this or any job description at its discretion at any time.
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.
Learn more about the Philly Fed and its culture. Learn more about working for the Philly Fed.
#LI-Onsite
Full Time / Part Time
Full timeRegular / Temporary
RegularJob Exempt (Yes / No)
YesJob Category
Information Technology Family GroupWork Shift
First (United States of America)The Federal Reserve Banks are committed to equal employment opportunity for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.
Always verify and apply to jobs on Federal Reserve System Careers ( or through verified Federal Reserve Bank social media channels.
Employment Type
Full-Time
