QA Engineer 3 - ETL QA

Posted 15 Days Ago
Be an Early Applicant
Pune, Mahārāshtra, IND
In-Office
Mid level
Information Technology • Travel
The Role
Design and execute functional and non-functional tests, define test strategy and plans, maintain CI/CD regression suites, assess and implement test automation, manage defects, report test progress, mentor peers, and drive QA process and tooling improvements while ensuring compliance with quality and sustainability guidelines.
Summary Generated by Built In

Job Title

QA Engineer 3 - ETL QA

Key Responsibilities 

  • Design, write, and execute test cases and SQL-based validations for ETL/ELT pipelines and data ingestion jobs. 

  • Perform source-to-target (S2T) reconciliation against the mapping specification — counts, values, and transformation rules. 

  • Validate data transformations: business rules, derivations, aggregations, joins, lookups, and cleansing logic. 

  • Test batch, incremental / change-data-capture (CDC), and streaming ingestion, including re-run and recovery behavior. 

  • Validate dimensional models — fact and dimension tables, surrogate/natural keys, referential integrity, and SCD handling. 

  • Build and maintain automated data-quality checks and regression suites; embed them as gates in CI/CD. 

  • Log, track, and triage defects; partner with data engineers to root-cause and retest. 

  • Perform performance and volume testing to confirm loads complete within SLA / batch windows. 

  • Contribute to data-quality frameworks, audit/control checks, lineage documentation, and reporting. 
     

Required Skills & Qualifications 

  • Strong SQL — complex joins, window functions, aggregations, set operations, and analytical queries for validation. 

  • Solid grasp of data warehousing and dimensional (Kimball) modeling — facts, dimensions, grain, and SCDs. 

  • Hands-on ETL/ELT testing experience with the org's stack [e.g., Informatica / Talend / SSIS / dbt / Azure Data Factory / AWS Glue]. 

  • Understanding of the data-quality dimensions: completeness, accuracy, consistency, validity, uniqueness, and timeliness. 

  • Experience testing both batch and incremental / CDC pipelines, including reject handling and idempotent re-runs. 

  • Scripting for test automation — Python (pandas) or equivalent. 

  • Familiarity with cloud data platforms [Snowflake / BigQuery / Databricks / Synapse] and/or big-data (Spark, Hive). 

  • Version control (Git), CI/CD pipelines, and defect tracking (JIRA). 

  • BI/report validation exposure (Power BI / Tableau) is a plus. 

  • Should understand Linux systems
     

Common accountabilities:
- Has the required technical/functional knowledge and experience in own discipline. Knowledge of the Amadeus business and how it is related to own area. ​
- Works using existing procedures or guidelines and provides inputs to support/influence area decisions. Makes recommendations on new solutions and proposes improvements by analyzing different sources of information.​
- Works with a moderate level of guidance and direction from manager.
Specific accountabilities:
Test strategy
* Attend to specification/architecture reviews (also on customer specification reviews when applicable), and provide feedback along with any potential impact, risk, issue or missed gap based on experience,
* Define test strategy and test plan containing test cases (functional and non-functional), ensure traceability with specifications and customer requirements,
* Ensure compliance of test strategy with CI/CD guidelines, Green IT guidelines and all quality guidelines (SDL, STDL), QA best practices/standards from the industry (ISTQB..),
Test expertise
* Design test cases and write test case scripts.
* Prepare test environment, test data, and execute test cases.
* Provide sign-off (go/no-go) on tested features based on defined exit criteria,
* Continuously assess the need to add/update/remove test cases to existing regression and CI/CD pipeline when new product features are delivered and based on metrics (stabilization, deletion of flaky tests...),
* As part of maintenance activities, investigate PTRs, test the fixes, and enrich test suites accordingly,
Test automation
* Assess necessity to automate subset of (or all) test scripts,
* Use test automation framework and contribute to its improvement,
Defect management
* Open defects for software or documentation, assign relevant level of severity based on the importance of the issue, provide relevant investigation and information in order to fix defects,
* Check defect fix, and give go/no-go for the load of production defects,
Reporting
* Report and communicate on test activities to the line organization, software developers and product definitions analysts,
* Provide visibility on testing campaign/milestones to all stakeholders,
Technicity
* Efficiently use QA tooling stack and frameworks,
* Be a force of proposition for improvement of existing ones, or development of new ones,
* Be proactive about any issue/change that is likely to affect QA peers daily job
Continuous and sustainable improvement
* Be a driving force behind proposals to improve current quality processes in a constantly evolving development lifecycle framework (SAFE...),
* Participate to the understanding, measurement and reduction of the environmental impact of the tested applications and associated QA activities

Diversity & Inclusion

Amadeus aspires to be a leader in Diversity and Inclusion in the tech industry, enabling every employee to reach their full potential by fostering a culture of belonging and fair treatment, attracting the best talent from all backgrounds, and as a role model for an inclusive employee experience.  

Amadeus is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to gender, race, ethnicity, sexual orientation, age, beliefs, disability or any other characteristics protected by law.  

Be aware of recruitment scams


Amadeus Group never charges fees, requests payment, or asks for financial information during recruitment. All legitimate opportunities are communicated solely through official Amadeus channels, including our careers website. Any payment request or outreach via unofficial platforms (e.g., WhatsApp, Telegram) should be treated as fraudulent.

Skills Required

  • Technical/functional knowledge and experience in QA discipline
  • Knowledge of the Amadeus business and its relation to QA activities
  • Define test strategy and test plan with traceability to specs and customer requirements
  • Ensure compliance with CI/CD guidelines, Green IT, SDL, STDL and QA best practices (ISTQB)
  • Design test cases and write test case scripts (functional and non-functional)
  • Prepare test environments and test data and execute test cases
  • Provide go/no-go sign-off on tested features based on defined exit criteria
  • Continuously assess and maintain regression and CI/CD pipeline tests, address flaky tests
  • Investigate production/test reported issues (PTRs) and validate fixes
  • Assess need for test automation, use and contribute to test automation frameworks
  • Open defects, assign severity, provide investigation details, and verify defect fixes
  • Report and communicate test activities and milestones to stakeholders
  • Mentor newcomers and provide support to QA peers
  • Share knowledge across QA community and propose quality process improvements
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Madrid
10,001 Employees
Year Founded: 1987

What We Do

Travel powers progress. Amadeus powers travel. Amadeus’ solutions connect travelers to the journeys they want, linking them via travel agents, search engines and tour operators to airlines, airports, hotels, cars and railways. Technology has always been critical to developing global travel, increasing scale, choice and access. We have developed our technology in partnership with the travel industry for 30 years. We combine a deep understanding of how people travel with the ability to design and deliver the most complex, trusted, and critical systems our customers need.

Similar Jobs

Capco Logo Capco

Credit - Hybrid Developer

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Capco Logo Capco

ESG Reporting

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Capco Logo Capco

Executive PMO- Banking

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

SailPoint Logo SailPoint

Senior Solution Engineer

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
India
2461 Employees

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
PRIMA Thumbnail
Travel • Software • Marketing Tech • Hospitality • eCommerce
US
15 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account