Staff Test Engineer

Teradata; Hyderabad; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Teradata is seeking an experienced QA/DevTest professional to advance testing for the Teradata Query Optimizer. You will develop SQL test cases, performance tests, and help shape testing methodologies within the Optimizer Group.

With 10–12 years in RD/DevTest, you will lead a small team, work with Developers and Project Lead, and contribute to CI/CD pipelines and tooling improvements.

Qualifications

• BS or MS/MCA in Computer Science or related field.
• Experience in Testing/QA for databases or optimizer testing is a plus.
• Knowledge of Teradata/any RDBMS is desirable.

Responsibilities

• Develop a framework for improved testing of the Teradata Query Optimizer.
• Create SQL test cases, test plans, CI/CD pipelines and analyze test reports.
• Identify critical performance areas and high-risk optimizer issues with developers.
• Fix issues in the database code when needed.
• Collaborate with offshore/onshore associates on projects.

Skills

SQL

Python

Perl

Shell Scripting

C

CI/CD

Education

BS or MS/MCA in Computer Science or related field

Job description

Our Company:

At Teradata, we believe that people thrive when empowered with better information. Teradata Autonomous Knowledge Platform activates enterprise intelligence by unifying data, knowledge and business context to achieve tangible outcomes. With Teradata, organizations can provide agents with full context for impact when it matters. Our solution lets businesses connect and scale on premises, in the cloud, or through a hybrid approach. Teradata delivers real business value with AI.

What You’ll Do

Responsible for development of new test cases(SQL), and performance tests focusing on the Teradata Query Optimizer. Participate as part of a team to develop new testing methodologies to improve Optimizer quality and robustness and analyze the effectivity of the TD cost based optimizer. This is not a traditional testing team and is considered part of the Optimizer Group which sometimes involve development assignments in the Optimizer area. We want associates with development experience(6-9 years) and overall experience of 10-12 years to find innovative ways to improve Optimizer testing. Some development of additional testing tools may be required at times. Need to have the ability to technically lead a small team of feature testers. Monitoring of Optimizer problem areas and incorporation of results into the testing methodology is expected. Exposure to CI/CD and DevOps is an added plus. They are also occasionally required to fix issues in the database code.

What Makes You a Qualified Candidate

• BS or MS/MCA in Computer Science or related field

Development experience required.

• Testing and/or Quality Assurance experience is a strong plus.
• Knowledge of Programming & DS & Python/Perl/Shell Scripting desirable.
• Should be comfortable with SQL(ANSI/Database specific)
• Ability to work with a Project Lead, Senior Developers, and Support Associates required.
• Teradata knowledge a plus.

Key Areas of Responsibility:

• Develop a framework for improved testing.
• Develop SQL test cases, test plans, CI/CD pipelines and test report analysis.
• Work with Developers and Project Lead to identify critical performance areas and high-risk areas of the Teradata Query Optimizer performance.
• Participate in Closed Loop Corrective Action analysis to improve Optimizer quality, robustness, and predictability.
• Work with developers to identify proposed new testing tools that can be used to improve Optimizer quality.
• Work on discrepancy reports and resolve them with database fixes

Other Items that will be desirable :

• Analyze optimizer bugs, design fix and unit test changes.
• Develop new features/change requests.
• Interact with offshore/onshore associates on projects/assignments

Scope:

• Individual Contributor
• Works with Project Lead, reports to Engineering Manager

Work Environment

• Requirements Analysis, Software development, Unit/Integration testing, bug fixing.

What You’ll Bring

• 10-12 years of experience with 6-9 Years of experience in R&D based Dev/Test teams
• Understand and be able to develop CI/CD piplelines. Software development skills including software design specification, test specification, coding, testing.
• Strong programming skills with C. Shell scripting and Perl programming a plus.
• SQL knowledge
• Good verbal and written communication skills
• Be a Team Player
• Knowledge of Teradata/any other RDBMS

#LI-AH1