Software Test Engineer (database, Dwh and Etl Testing)

Visa Visa · Fintech · Bengaluru, India, IN

Visa is seeking a QA Engineer with a strong passion for data and a commitment to quality to ensure the integrity and accuracy of data pipelines, data warehouses, and associated applications. The role involves rigorous database, DWH, and ETL testing, alongside developing and maintaining test automation frameworks. Responsibilities include translating requirements to test cases, debugging, performing ETL process testing, writing SQL queries for validation, building automation tools and frameworks from scratch, collaborating with engineers on test suites, and supporting agile activities.

What you'd actually do

  1. Ability to translate requirements to functional test cases, execute tests and create data needed for testing without assistance.
  2. Strong skills in debugging, looking at logs, isolate problem scenarios and communicating more precise information to developers.
  3. Perform thorough testing of Batch/ETL processes, including data extraction, transformation logic, and loading into the data warehouse.
  4. Write and execute complex SQL queries for data validation, data integrity checks, and back-end testing.
  5. Build automation tools and test automation frameworks from scratch.

Skills

Required

  • database testing
  • data warehouse (DWH) testing
  • ETL testing
  • SQL
  • RDBMS
  • NoSQL
  • batch testing
  • test data design
  • test automation frameworks
  • Selenium
  • TestNG
  • Cucumber
  • Protractor
  • SoapUI
  • Python
  • Java
  • Unix commands
  • shell scripts
  • analytical skills
  • problem-solving skills
  • communication skills

Nice to have

  • Oracle Revenue Management and Billing (ORMB)
  • Performance and load testing tools (JMeter, LoadRunner)
  • Prompt Engineering
  • OpenAI's GPT
  • Talend
  • Informatica
  • SSIS
  • Appium
  • Pytest

What the JD emphasized

  • Build automation tools and test automation frameworks from scratch.