Senior Data Quality Engineer - ETL & Analytics

LTM; Irvine (CA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Comprehensive Medical Plan

Short & Long Term Disability

401(k) Plan with Company match

Life Insurance

Vacation Time, Sick Leave, Paid Holyd\

Paid Paternity and Maternity Leave

Job summary

LTIMindtree is seeking a Data Testing Engineer to validate data integrity across ETL, data warehouse, and analytics platforms in Irvine, CA. You will design and execute test cases, develop SQL queries, and ensure data quality end-to-end for BI solutions.

The role requires strong SQL skills, hands-on ETL testing experience with tools like Informatica/Talend/DataStage/SSIS, and familiarity with cloud platforms such as Azure Data Factory, Databricks or AWS Glue.

Qualifications

• Extensive experience in database testing and ETL validation.
• Strong SQL skills across Oracle, SQL Server, PostgreSQL and Snowflake.
• Hands-on experience with Informatica, Talend, DataStage or SSIS.
• Familiarity with Azure Data Factory, Databricks or AWS Glue.

Responsibilities

• Validate data integrity across ETL, data warehouse and data lake.
• Design and execute test cases for ETL pipelines and BI reporting.
• Develop SQL queries to validate large datasets.
• Perform data quality, reconciliation and data integrity testing.
• Collaborate in Agile ceremonies with cross-functional teams.
• Identify and resolve data discrepancies with development teams.

Skills

SQL

Data testing

ETL validation

Agile ceremonies

Python / PySpark

Big data testing

GenAI testing tools

Tools

Informatica

Talend

DataStage

SSIS

JIRA

Azure DevOps

HP ALM

Databricks

AWS Glue

Oracle

PostgreSQL

Snowflake

Job description

LTIMindtree is seeking a Data Testing Engineer to validate data integrity across ETL, data warehouse, and analytics platforms in Irvine, CA. You will design and execute test cases, develop SQL queries, and ensure data quality end-to-end for BI solutions.

The role requires strong SQL skills, hands-on ETL testing experience with tools like Informatica/Talend/DataStage/SSIS, and familiarity with cloud platforms such as Azure Data Factory, Databricks or AWS Glue.