Sr. Software Test Engineer

  • Full-time

Company Description

For over 30 years, Silicon Valley Bank (SVB) has helped innovative companies and their investors move bold ideas forward, fast. SVB provides targeted banking services to companies of all sizes in innovation centers around the world. 

Job Description

Responsibilities

  • Lead the end-to-end QA delivery of data platform, data products and enterprise Datawarehouse initiatives. Act as key point of contact for all testing of data releases
  • Coordinate with project peers, business partners, IT leads and other stakeholders to design test strategies and develop test plans & test cases
  • Participate in Agile cadences for one or more Scrum teams
  • Ensure accuracy and consistency of structured relational data, big-data, data transformations, data quality, analytical results and reporting by implementing high quality test planning and test execution
  • Building Data automation framework, Creating Scripts and Reports  
  • Perform ETL testing to validate the data from Source to Core EDW Layers and downstream targets
  • Create mock test data and validate the data quality rules and exceptions
  • Perform Microservices/API testing for the in-bound and out-bound interfaces on the data platform
  • Validating the extracts generated from the EDW Layers and perform data attribute testing
  • Research, prioritize, and manage defect reports and resolution activities
  • Strategize and implement data test automation and recommended testing improvements through QA best practices, supporting other testers and sharing knowledge of test tools
  • Assure adherence to Enterprise Software Delivery Methodology
  • Effectively communicate test plans, test reports, and test metrics to Senior Leadership.
  • Engage with vendor partners in development, release management, and operations for test management and execution
  • Onboard, mentor and provide direction to IT Test team members

Qualifications:

  • Minimum 10 years of ETL/ Datawarehouse testing experience working with SAP BODS or related ETL tools (Informatica /Data Stage /Abinitio)
  • Minimum 8 years of data testing experience writing  complex SQL statements and PL/SQL to test data flow and to perform data validation and data analysis
  • Experience in data testing automation using any Open source tools
  • Minimum 3 years of experience in testing Big data Hadoop, Cloudera, YARN, Hive, Pig
  • Minimum 3 years of experience in testing AWS technologies EMR, Glue, S3, Redshift, Dynamo DB
  • Minimum 5 years of experience with QA automation in building test automation framework, scripting, scheduling and reporting using open source tools like (python, pytest framework etc.) for testing Datawarehouse /Bigdata projects.
  • Minimum 2 years of Hands on experience testing Data Quality tools like Informatica  IDQ, Talend data quality etc
  • Hands on experience in Web Services Testing using SOAP UI/SOA test/Junit
  • Kafka streaming integration testing experience preferred
  • Java/Python experience preferred
  • Experience in root cause analysis and defect diagnosis techniques. Ability to document software defects, conduct defect triage meetings and report defects to project stakeholders.
  • Experience with utilization of appropriate test methodologies and use of test management tool like JIRA, HP ALM
  • Ability to operate comfortably in a multi-task / multi priority environment across a global team.
  • Must be detail oriented and capable of analyzing issues from the perspective of customers/users.
  • BA/BS Bachelor’s Degree and a minimum of ten (10) years of professional experience
  • Experience working with SaaS solutions, including data interfaces is a plus

Additional Information

All your information will be kept confidential according to EEO guidelines.