Experience Inc. Jobs

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.

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 responsibilitiesas 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; demons ratethe ability to manage the communication process;communicate with clients, colleagues and management to explain complex issues;transfertechnical knowledge; diffuseconflict and buildsagreement.

Experience approaching a problem from different angles, analyzing pros and cons of different solutions andproblem-solvingskills.Havea logical, analytical and creative approach to problems; Demonstrateexpert level analytical and problem-solving skills; organizeinformation in a manner that communicates issues;identify underlying issues and recognizes symptoms that indicate more severeissues.

Excellent interpersonal skills. Demonstrates the ability to lead and participateon a team; leadcomplex and diverse team efforts by virtue of both technical expertise and leadership skills of influence; drawon experience to resolve higher complexity issues; displaystrong 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 ofdifferent 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; engageotherpartners 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 fulljobdescription, clickthe linkbelow, you will follow the:DATABASE/DATA VALIDATION TESTING TRACK

Thesalary gradefor 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 "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