Test Engineer (2+ years in ETL testing)

About Gartner IT:

Join a world-class team of skilled engineers who build creative digital solutions to support our colleagues and clients. We make a broad organizational impact by delivering cutting-edge technology solutions that power Gartner. Gartner IT values its culture of nonstop innovation an outcome-driven approach to success and the notion that great ideas can come from anyone on the team.

About the role:

Gartner is looking for a Test Engineer with strong ETL data warehousing SQL scripting & BI report validation experience to join their team to understand and implement best-fit approaches to testing ensuring quality delivery while following the industry best practices. Working knowledge of MDM system and experience in API testing will be a plus.

What youll do:

• Review functional and technical documents to understand the data lineage.

• Create and execute manual and automated test plans for ETL data pipeline functionality acceptance regression performance testing.

• Engage and partner with developers and BA in an agile development environment to understand requirements and perform testing.

• Create test scenarios run functional tests create regression suite create testing artifacts and raise defects with detailed information.

• Follow coding standards build appropriate unit tests integration tests and deployment scripts and review project artifacts created by peers.

• Design and develop automation scripts.

What youll need:

2-4 years hands-on experience in ETL concepts and testing in data warehouse/data driven projects. Working knowledge of MDM system.

Must have

• Strong command in writing complex PL/SQL scripts for Datawarehouse/ETL testing.

• Understanding and testing experience in Data Warehousing/MDM and Data modelling.

• Should have worked on cloud platform such as Azure or AWS.

• Experience in testing ETL pipelines BI dashboards & Self-Service reports

• Hands on experience of Test management tools JIRA QC etc.

• Experience in testing APIs using Postman or automation tool will be a plus.

• Excellent analytical problem-solving and debugging skills with strong ability to learn adapt and comprehend business processes.

• Perform root cause analysis on the issues reported.

Good to Have:

• Knowledge of testing MDM solutions - match and merge algorithm testing NRT messages API messages

• Good understanding of API Testing and best practices.

• Experience in automation using any programmatic languages e.g. Python Java is a plus.

• Experience in Performance testing with tools like JMeter is a plus.

• Experience/knowledge about ETL automation tools like DataOps ETLValidator
  

Who you are:

• Passionate about open-source technologies self-learner and curious.

• Passion for automation and developing infrastructure as code.

• A team player who can comfortably work with distributed teams across the globe.

• Attentive to details and well organized.

• Able to solve complex problems and successfully manage ambiguity and unexpected change.

• Coachable and embracing of best practices and feedback as a means of continuous improvement

• Consistently high achiever marked by perseverance humility and a positive outlook in the face of challenges
  

Dont meet every single requirement We encourage you to apply anyway. You might just be the right candidate for this or other roles.

#LI-NS4

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 insight helping enterprise leaders and their teams succeed with their mission-critical priorities.

Since our founding in 1979 weve grown to more than 21000 associates globally who support 14000 client enterprises in 90 countries and territories. We do important interesting and substantive work that matters. Thats 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 sustained success creates limitless opportunities for you to grow professionally and flourish personally. We have a vast virtually untapped market potential ahead of us providing you with an exciting trajectory long into the future. 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.

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 its productive to do so and getting together with colleagues in a vibrant community that is purposeful engaging and inspiring.

Ready to grow your career with Gartner Join us.

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 Companys career webpage as a result of your disability. You may request reasonable accommodations by calling Human Resources at 1 or by sending an email to.

Gartner Applicant Privacy Link: efficient navigation through the application please only use the back button within the application not the back arrow within your browser.