Sr Test Engineer -ETL

Gartner, Inc.; Gurugram District; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Gartner, Inc. is seeking a QA Engineer to develop and execute manual and automated tests ensuring the functionality and usability of the application under test.

The role emphasizes SQL-based data validation, database testing, integration and End-to-End testing, and API testing using Postman or similar tools. You will contribute test metrics, address issues affecting schedules, and collaborate with the Test Lead to mitigate risks.

Qualifications

• B.S. in Computer Science, Mathematics, Engineering or related disciplines with 3-5 years of software test experience.
• 3+ years of experience in creating and executing SQL queries.
• Strong experience in database testing and validation.
• 3+ years in an Integration environment; testing integration and End to End testing.
• Good knowledge in API testing using Postman or equivalent tool.
• Proficient with automated tools used to support testing (test mgmt, defect tracking).
• Keen to learn and adapt new AI tools to automate processes.

Responsibilities

• Create test plans ensuring ETL logic and data load meet requirements.
• Create data records to test boundary conditions of logic.
• Create SQL scripts with multi-table joins, unions, and filters.
• Create PL/SQL procedures to batch schedule DML/DDL scripts.
• Test scheduled and integrated jobs; perform data comparisons and End-to-End tests across apps.
• Write data sanity tests: counts, reconciliation, duplicates; audit and log job runs.

Skills

Software testing

SQL queries

Database testing

Integration testing

API testing

Automation tools

AI tools

Education

B.S. in Computer Science, Mathematics, Engineering

Tools

Postman

Test management

Defect tracking

Job description

Position Summary:

The QA Engineer will focus on the development and execution of manual and automated scripts which validate the functionality and useability of the application under test. We are seeking a skilled QA engineer with strong background in creating SQL queries, database usage, functional testing, integration testing and End to End testing. In addition, they will provide test metrics and address any issues and concerns which may affect project schedule to the Test Lead.

Requirement (Required Skills):

B. S. in Computer Science, Mathematics, Engineering, or related disciplines with 3-5 years of software test experience 3+ years of experience in creating and executing SQL queries. Strong experience in database testing and validation. 3+ years of experience of working in an Integration environment, well versed in testing integration and End to End testing. Good knowledge in API testing using Postman or any standard market tool. Proven functional testing experience. Proficient in the use of automated tools used to support testing (e.g. test management, defect tracking, etc.) Keen to learn and adapt new AI tools which can automate processes.

Preferred Skills:

Excellent written, oral and interpersonal skills. Excellent analytical and troubleshooting skills. Enthusiastic about learning new techniques, strong analytical and problem-solving skill. Good judgment, prompt decision-making ability, responsibility, and accountability Commitment to working in a team environment. Knowledge on Automation using Python and Pandas Library is good to have.

Responsibility:

Create test plans which ensures that ETL logic, the required data transformations and data load is as specified in the requirement documentation. Creation of data records which tests the boundary conditions of the logic defined. Creation of SQL scripts using multiple tables joins, unions, data filtering conditions based on technical mapping or design documents. Creation PL/SQL procedures to batch schedule series of DML, DDL SQL scripts. Test scheduled and integrated jobs, do data comparisons and have experience in doing E2E testing across different applications. Write data sanity tests like Count check, Reconcile records with the source data, duplicate check, etc. Create or Schedule database jobs to run at specified times, logging audits of job run in audit tables, to be referred while defect triage Provide test status and raise issues and potential risks to Test Lead Effectively document defects using automated defect tracking software.

Who are we?

At Gartner, Inc. (NYSE:IT), we guide the leaders who shape the world. Our mission relies on expert analysis and bold ideas to deliver actionable, objective business and technology insights, helping enterprise leaders and their teams succeed with their mission-critical priorities. Since our founding in 1979, we’ve grown to 20,000 associates globally who support over 13,000 client enterprises in ~90 countries and territories. We do important, interesting and substantive work that matters. That’s why we hire associates with the intellectual curiosity, energy and drive to want to make a difference. The bar is unapologetically high. So is the impact you can have here. What makes Gartner a great place to work? Our vast, virtually untapped market potential offers limitless opportunities – opportunities that may not even exist right now – for you to grow professionally and flourish personally. How far you go is driven by your passion and performance. We hire remarkable people who collaborate and win as a team. Together, our singular, unifying goal is to deliver results for our clients. Our teams are inclusive and composed of individuals from different geographies, cultures, religions, ethnicities, races, genders, sexual orientations, abilities and generations. We invest in great leaders who bring out the best in you and the company, enabling us to multiply our impact and results. This is why, year after year, we are recognized worldwide as a great place to work.

Gartner is the world authority on AI

At Gartner, you’ll join a company at the very center of the AI revolution. Gartner has proactive, objective guidance throughout clients’ AI journeys. We set the standard for how organizations leverage artificial intelligence to drive meaningful impact. You’ll have access to unmatched resources, expertise, and technology, and play a key role in helping Gartner and our clients innovate and grow as we leverage AI to transform business and technology landscapes. It’s an exciting time to be at Gartner, with limitless opportunities to make a real impact, grow your skills, and build a lasting, meaningful career in a field that’s reshaping the way we operate. If you’re passionate about AI and want to be part of a team that’s guiding the leaders who shape the world, Gartner is the place for you.

What do we offer?

Gartner offers world-class benefits, highly competitive compensation and disproportionate rewards for top performers. In our hybrid work environment, we provide the flexibility and support for you to thrive - working virtually when it's productive to do so and getting together with colleagues in a vibrant community that is purposeful, engaging and inspiring.

The policy of Gartner is to provide equal employment opportunities to all applicants and employees without regard to race, color, creed, religion, sex, sexual orientation, gender identity, marital status, citizenship status, age, national origin, ancestry, disability, veteran status or any other legally protected status and to seek to advance the principles of equal employment opportunity. Gartner is committed to being an Equal Opportunity Employer and offers opportunities to all job seekers, including job seekers with disabilities. If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to use or access the Company’s career webpage as a result of your disability. You may request reasonable accommodations by calling Human Resources at [phone] or by sending an email to [e-mail].