Database / ETL Test Engineer

Must have a Bachelor’s degree with a concentration in Information Technology or Computer Science or equivalent significant experience in information technology and software testing.
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 in the posting.
Technical skills including complex SQL, Databricks, Apache Spark, Tableau, and AWS cloud platform are required.
Knowledge of Python, Linux scripting, and REST APIs is also relevant.

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