Overview
You will design and execute test plans for ETL processes, validate data transformations using SQL, and perform reconciliation across source systems, data warehouses, and data lakes. Working closely with data engineering and BI teams, you will play a key role in identifying issues, improving data pipelines, and driving high-quality data delivery. This is an excellent opportunity for a detail-oriented professional with strong SQL and ETL testing experience to contribute to EXL's mission of leveraging data and AI to transform businesses. The role offers exposure to modern data platforms, QA frameworks, and cloud technologies, alongside the opportunity to develop your skills in a global, collaborative, and innovative environment.
As part of your duties, you will be responsible for:
- Understand business requirements and data flows to create comprehensive test plans and test cases for ETL jobs.
- Perform data validation and reconciliation between source systems, staging, and target data stores (DWH, data lakes, etc.).
- Develop and execute automated and manual tests to ensure data accuracy and quality.
- Work with SQL queries to validate data transformations and detect anomalies.
- Identify, document, and track defects and inconsistencies in data processing.
- Collaborate with data engineering and BI teams to improve ETL processes and data pipelines.
- Maintain QA documentation and contribute to continuous process improvements.
Qualifications
- Strong SQL skills - ability to write complex queries for data validation and transformation testing.
- Hands-on experience in ETL testing - validating data pipelines, transformations, and data loads.
- Knowledge of data warehousing concepts - dimensions, facts, slowly changing dimensions (SCD), etc.
- Experience in test case design, execution, and defect tracking.
- Experience with QA tools like JIRA, TestRail, or equivalent.
- Ability to work independently and collaboratively in an Agile/Scrum environment.
Desirable Skills
- Experience with ETL tools like Informatica, Talend, DataStage, or AWS/GCP native ETL services (e.g., Dataflow, Glue).
- Knowledge of automation frameworks using Python/Selenium/pytest or similar tools for data testing.
- Familiarity with cloud data platforms - Snowflake, BigQuery, Redshift, etc.
- Basic understanding of CI/CD pipelines and QA integration.
- Exposure to data quality tools such as Great Expectations, Deequ, or DQ frameworks.
- Understanding of reporting/BI tools such as Power BI, Tableau, or Looker.
Education
- Bachelor's or Master's degree in Computer Science, Information Technology, or related field.
About EXL
Job Description: EXL (NASDAQ: EXLS) is a global data and artificial intelligence ("AI") company that offers services and solutions to reinvent client business models, drive better outcomes and unlock growth with speed. EXL harnesses the power of data, AI, and deep industry knowledge to transform businesses, including the world's leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 59,000 employees spanning six continents. For more information, visit the EXL website.
Role Details
- Role Title: Data Quality Analyst
- BU/Segment: Insurance
- Location: London, United Kingdom (Flexible hybrid working)
- Employment Type: Permanent
- Summary of the role: We are seeking a Data Quality Analyst to join our Insurance business unit in London. In this role, you will be responsible for ensuring the accuracy and reliability of data across systems.
What we offer
- A competitive salary with a generous bonus, private healthcare, critical illness life assurance at 4x your annual salary, income protection insurance, and a rewarding pension.
- Employee benefits such as cashback offers, a Cycle Scheme, and other financial well-being programs.
- Professional and personal development opportunities, including access to online courses, seminars, and workshops to stay current with trends and technologies.
- Equal Opportunity Employer statement: EXL is committed to diversity and does not discriminate based on race, religion, colour, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, age, or disability status.
- Employee stock purchase plan (ESPP) eligibility.
- Flexible hybrid working model to support work-life balance and collaboration.
To be considered for this role, you must already be eligible to work in the United Kingdom.