Database / ETL Test Engineer

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 requirements to test cases to ensure coverage for full system integration test 

• Coordinate the resolution of problems inhibiting test progress 

• Define, execute, and track status of test cases 

• Execute and analyze results of automated tests 

• Detect, communicate, and track defects through the use of trend analysis 

• Escalate risks and progress reporting to Scrum team and QA management 

• Assess and enhance overall testing effectiveness and efficiency 

• Perform all other responsibilities as requested or assigned 

What You Have: 

 Technologies: 

• GIT, RDBMS concepts (Oracle, MSSQL, Teradata), SOAP/XML, Strong SQL writing skills, ETL designers like Informatica, Test Data Management, Test Scheduling techniques 

• Knowledge of Python and Docker, CI/CD pipeline tools is helpful. 

Knowledge:  

• Experience troubleshooting issues with users.  

• Independently, presents 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; transfer technical knowledge; diffuse conflict and builds agreement.  

• Experience approaching a problem from different angles, analyzing pros and cons of different solutions and problem-solving skills. Have a logical, analytical and creative approach to problems; Demonstrate expert level analytical and problem-solving skills; organize information in a manner that communicates issues; identify underlying issues and recognizes symptoms that indicate more severe issues.  

• Excellent interpersonal skills. Demonstrates the ability to lead and participate 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.  

• Excellent time management skills.  

•  Identify and assess higher complexity supervisory issues; manage higher complexity issues to meet our goals.  

• Excellent knowledge of different 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; serve as coach and provides constructive feedback to less experienced staff; engage 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.  

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

To see the full job description, click the link below, you will follow the : DATABASE/DATA VALIDATION TESTING TRACK 

The salary grade for this position is: salary grade 15. Final salary and offer will be determined by the applicant’s background, experience, and skills, and internal equity and alignment with market data. 

To be considered for the position, please submit a resume and cover letter. 

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 $100 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 “[email protected]”. 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 [email protected]. 

• The Federal Reserve Bank of Philadelphia believes that diversity, equity and inclusion among our employees is essential to our success as an organization, and we want to recruit, develop and retain the most accomplished people from a diverse candidate pool. To support a workplace culture of belonging, we offer nine employee resource groups (ERGs) and a 100 percent rating on the Human Rights Campaign (HRC) Corporate Equality Index. The Federal Reserve Bank of Philadelphia is proud to be an equal opportunity workplace. 

• We have nine employee resource groups (ERGs) to support a diverse workforce. Abilities (supporting disabilities and allies), African Heritage, Asian-Pacific, Freedom (supporting LQBTQ+ and allies), Talent Forward (supporting career growth), Women United, Latin and Hispanic Heritage, Working Families and Veterans. ERGs are open to all employees. 

• 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 [email protected]. 

• All Federal Reserve Bank of Philadelphia employees must comply with the Bank's 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 Bank's 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 moderate or 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 they sign a declaration of intent to become a permanent resident and a U.S. citizen and meet other eligibility requirements. In addition, all candidates must undergo an applicable background check and comply with all applicable information handling rules. 

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

• This is NOT a 100% remote opportunity. You will be available to work on-site in at least a hybrid capacity. 

• Learn more about the Philly Fed and its culture. Learn more about working for the Philly Fed.