ETL Test Engineer - Data Warehouse (Cloud Data services/ AWS DynamoDB/ AWS Redshift/Databricks)

Company

Federal Reserve Bank of Philadelphia

When you join the Federal Reserve—the nation's central bank—you’ll play a key role, collaborating with leading tech professionals to strengthen and protect our economic, financial and payments systems. We dedicate more than $1 billion to technology each year to support the Federal Reserve and our economy, and we’re building a dynamic and diverse team for our future.

Bring your passion and expertise, and we’ll provide the opportunities that will challenge you and propel your growth—along with a wide range of benefits and perks that support your health, wealth, and life. In addition to competitive compensation, we offer a comprehensive benefits package that includes tuition assistance, generous paid time off, top-notch health care benefits, child and family care leave, professional development opportunities, a 401(k) match, on, and more. All brought together in a flexible work environment where you can truly find balance.

This Job Description is for the Information Technology Job Family and could include anyone within the ITS department that performs these tasks. An ideal candidate must have knowledge of, be 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 has full operational knowledge of all phases of testing and is able to work at a high level of complexity related to quality assurance with minimal supervision. Directs and reviews work of lower-level personnel and/or may perform as an individual contributor on large and complex systems. Has working knowledge of one or more FRS system testing platforms.

This position will follow the DATABASE/ DATA TRANSFORMATION/ DATA VALIDATION TESTING TRACK

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 languages like Python and R with a modern IDE (Anaconda, Jupyter notebook, Databricks, AWS Glue, Informatica Power Center, 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 (Oracle Exadata preferred), Data Warehouse products and other industry tools approved for use at FRS as applicable.

Work closely with Sr. QA Engineers and key SMEs such as the Product Owner, System Architect, and/or Scrum Master to plan the test strategy/approach for scalable/risk-based test coverage, inculcating 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 PostgresSQL, Oracle, AWS Redshift or similar.

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.

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.

Knowledge and Skills:

• Strong written and oral communications skills. Independently, presents both orally and in writing, findings and assessments; prepares and presents information and responses to higher complexity 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. 
• Strong analytical and problem-solving skills. 
• Logical, analytical, and creative approach to problems; Demonstrates strong 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. 
• Strong 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; draws on experience to resolve higher complexity