QA Engineer 3 - ETL QA

Job description

**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.