Senior ETL Test Engineer – Data Quality & Automation

Tata Consultancy Services; Charlotte (NC); On-site; USD 100,000 - 120,000; Full time

Job summary

Tata Consultancy Services in the United States seeks an experienced ETL Tester with 10+ years in ETL testing to join our data quality initiatives. You will design test plans, perform data reconciliation, and write advanced SQL to validate large data volumes.

Responsibilities include defect tracking, automation, and ensuring data transformation accuracy using Informatica/IDMC within a data warehousing environment. Strong communication with stakeholders is essential.

Qualifications

• Minimum 10 years of ETL testing experience.
• Strong SQL expertise for data validation.
• Experience with data warehouse concepts.
• Familiarity with Hadoop or Spark preferred.

Responsibilities

• Analyze data mapping documents and business requirements to design comprehensive test plans and cases.
• Perform source-to-target data reconciliation, check data loading, and ensure transformation rules are applied correctly.
• Write complex SQL scripts for validation (count, data completeness, data consistency, data truncation).
• Identify, log, and track data defects using tools like JIRA or HP ALM or Octane.
• Automate test scripts and validate data volume, performance, and scalability.
• Expert-level knowledge of SQL for data analysis.

Skills

ETL testing

SQL

Shell scripting

Autosys

IDMC/Informatica

Hadoop/Spark

Hive

Data warehousing

Data quality

Tools

IDMC

Informatica PowerCenter

Hive

Kafka

SQL

Oracle

PL/SQL

Job description

Tata Consultancy Services in the United States seeks an experienced ETL Tester with 10+ years in ETL testing to join our data quality initiatives. You will design test plans, perform data reconciliation, and write advanced SQL to validate large data volumes.

Responsibilities include defect tracking, automation, and ensuring data transformation accuracy using Informatica/IDMC within a data warehousing environment. Strong communication with stakeholders is essential.