ETL Tester

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

Job Description

Must Have Technical/Functional Skills

Primary Skill: ETL testing

Secondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica

Experience: Minimum 10 years

Roles & 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.
• Experience with tools such as Informatica and IDMC.
• Understanding of data warehouse concepts and architectures (e.g., star/snowflake schema).
• Familiarity with Hadoop or Spark is often preferred.
• Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster.
• Strong analytical and troubleshooting skills.
• Excellent communication for collaborating with developers and stakeholders.
• Knowledge in Metadata dependent ETL process and batch/job framework

Tools & Skills

IDMC, Informatica Power center, Hive, Kafka Knowledge

SQL, Oracle, PL/SQL

Domain: Banking knowledge, Payments knowledge preferred.

Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality.

Salary Range- $100,000-$120,000 a year