ETL Tester

Description

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 this role:

The Test Engineer position is responsible for building, executing, and automating test cases based on test plans and functional requirements across our products.

What you will do: 

The responsibilities include, but are not limited to the following: 

· Build, execute, and automate test cases based on test plans and functional requirements

·Conduct functional testing of new requirements and enhancements of applications

·Perform peer reviews of test scripts, results and documentation

· Interpret and report testing results and advocate for quality in every phase of the development process

· Work with Software Development Engineers to understand the overall technical architecture and how each feature is implemented

What you will need 

Strong IT professional with 2-4 years of experience in ETL testing. The candidate should have strong qualitative and quantitative problem-solving skills along with high on ownership and accountability. 

Must have:

· 2+ years of QA experience

·  Strong knowledge in writing complex queries for validation of ETL process.

·  Ability to write and optimize complex SQL queries, including all types of joins, aggregations, window functions, and advanced filtering.

·  Proficiency in using SQL for data validation, profiling, and reconciliation.

· Hands-on experience with Power BI for data visualization, and testing dashboards.

· Ability to validate BI reports against source data and ensure data accuracy and integrity

· Understanding of platforms like Azure Synapse Analytics.

·  Experience in testing data pipelines in cloud environments.

·  Experience with any of the tools such as iCEDQ, DataOps, QuerySurge, Informatica, Talend, or SSIS for automating ETL testing.

·  Ability to design and implement automated test cases for ETL processes.

·  Involvement in data migration projects, including planning, execution, and validation of migrated data.

·Ability to perform row count, data integrity, and transformation validation during migrations.

· Ability to interpret source-to-target mapping documents and convert them into test cases or complex SQL queries for validation.

·  Experience in validating mapping logic and ensuring accurate data transformation.

·  Perform data verification and reconciliation between source and target systems.

· Collaborate with stakeholders to understand business requirements and ensure alignment with testing efforts.

·Generate and maintain test data for various scenarios.

·Deep understanding of data warehousing concepts, data modelling, and data integration.

·Strong analytical and problem-solving skills with meticulous attention to detail.
 

Good to have:

·Exposure to Data ops, Data bricks Tools

· Experience in BI report testing using Business Objects, BI Publisher

· Good to have Sql Server Management Studio exposure

Who you are

· Graduate/Post graduate in BE/Btech, ME/MTech or MCA is preferred. 

· Excellent communication and prioritization skills.

·  Able to work independently or within a team proactively in a fast-paced AGILE-SCRUM environment.

· Owns success – Takes responsibility for successful delivery of the solutions.

· Strong desire to improve upon their skills in software development, frameworks, and technologies

Don’t 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 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 21,000 associates globally who support ~14,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.

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.

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 Company’s career webpage as a result of your disability. You may request reasonable accommodations by calling Human Resources at +1 (203) 964-0096 or by sending an email to  [email protected] .

By submitting your information and application, you confirm that you have read and agree to the country or regional recruitment notice linked below applicable to your place of residence.

Gartner Applicant Privacy Link: https://jobs.gartner.com/applicant-privacy-policy

For efficient navigation through the application, please only use the back button within the application, not the back arrow within your browser.