Software Test Engineer (Database, DWH and ETL Testing)

Company Description

Visa is a world leader in payments and technology, with over 259 billion payments transactions flowing safely between consumers, merchants, financial institutions, and government entities in more than 200 countries and territories each year. Our mission is to connect the world through the most innovative, convenient, reliable, and secure payments network, enabling individuals, businesses, and economies to thrive while driven by a common purpose – to uplift everyone, everywhere by being the best way to pay and be paid.

Make an impact with a purpose-driven industry leader. Join us today and experience Life at Visa.

Job Description

At Visa, the Finance Technology organization enables Visa's revenue growth through flexible rule-based pricing engines and global revenue platforms built on next-generation technologies.

We are seeking a motivated and detail-oriented QA Engineer to join our dynamic team. This role is perfect for a candidate with a strong passion for data and a commitment to quality. The successful candidate will be responsible for ensuring the integrity and accuracy of our data pipelines, data warehouses, and associated applications. This will involve rigorous database, DWH, and ETL testing, alongside the development and maintenance of our Test Automation frameworks.

• Ability to translate requirements to functional test cases, execute tests and create data needed for testing without assistance.
• Strong skills in debugging, looking at logs, isolate problem scenarios and communicating more precise information to developers.
• Perform thorough testing of Batch/ETL processes, including data extraction, transformation logic, and loading into the data warehouse.
• Write and execute complex SQL queries for data validation, data integrity checks, and back-end testing.
• Build automation tools and test automation frameworks from scratch.
• Collaborate with software engineers to comprehend application design and specifications, subsequently creating detailed test automation suites based on application functions.
• Design and develop test automation frameworks for both web-based user interfaces and backend batch processes.
• Build automation tools and test automation frameworks from scratch.
• Design and build automation tools for test data generation, data analysis, pattern recognition and monitoring.
• Work with the team in identification of opportunities for automated test executions and drive adoption of automated testing and tools thru the product/project lifecycle.
• Stay abreast of emerging technologies and proactively assess and evaluate the adoption thereof into the organization.
• Support agile activities: sprint planning, stand ups, sprint review and sprint retrospective.
• Must be self-motivated with ability to work in a fast-paced agile delivery model.
• Productively work with teams in multiple geographical locations and time zones
• Support agile activities: sprint planning, stand ups, sprint review and sprint retrospective.
• Must be self-motivated with ability to work in a fast-paced agile delivery model.
• Productively work with teams in multiple geographical locations and time zones

Required Skills And Qualifications:

• A Bachelor's degree in Computer Science, Information Technology, or a related field.
• Strong proficiency in SQL and hands-on experience with relational databases (e.g., PostgreSQL, MySQL, SQL Server).
• A solid understanding of data warehousing concepts, ETL tools (Talend, Informatica, or SSIS), and database testing methodologies.
• Knowledge in ORMB is plus
• Basic understanding or hands-on experience in Unix commands, writing shell scripts
• Experience with at least one programming or scripting language for automation, such as Python or Java.
• Very proficient in test automation frameworks and tools like Selenium, Appium, TestNG, or Pytest.
• Exceptional analytical and problem-solving skills with a keen eye for detail.
• Excellent verbal and written communication skills.
• The ability to work effectively both independently and as part of a collaborative team.

This is a hybrid position. Expectation of days in office will be confirmed by your hiring manager.

Qualifications

Basic Qualifications
•Bachelor's degree in a Computer Science or other Engineering discipline with 2+ years or more of demonstrated experience in application analysis/design, testing, test automation, business system analysis and quality assurance.

Preferred Qualifications
•Proficiency with 2+ years of experience in testing ORMB batches, UIs and interfaces.
•Expert on ORMB functionality, testing, data model and SQL.
•Hands on experience in writing/executing functional test cases for testing applications end to end.
•Hands on experience in building test automation with tools such as Selenium, Test NG, Cucumber etc. is a plus.
•Strong interest in new automation technology and trends with the ability to relate concepts to practical application.
•Experience preparing test data based on business scenarios and creating tools and scripts to manufacture test data.
•Experience in performing batch testing in data warehousing environments.
•Hands on experience working with RDBMS and NO SQL and should be proficient writing complex SQL queries to validate and analyze data.
•Hands on experience in building test automation with tools such as Selenium, Protractor, Test NG, Cucumber, SoapUI etc.
•Experience working with one of the modern JavaScript frameworks such as Angular, Node JS or React.
•Having knowledge in Oracle Revenue Management and Billing (ORMB) is a plus.
•Strong interest in new automation technology and trends with the ability to relate concepts to practical application.
•Strong interpersonal, facilitation, and leadership skills along with effective communication (both written and verbal) skills and the ability to present complex ideas in a clear, concise way.
•Experience working with Performance and load testing tools such as JMeter or LoadRunner is a plus.
•Knowledge of Prompt Engineering and OpenAI's GPT is a plus.
•Ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.
•Candidate must be able to proficiently multi-task and should be able to work with teams across multiple geographies.
•Strong teamwork focus and the ability to foster collaboration within and across teams.

Additional Information

Visa is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.