Tata Consultancy Services · 14 hours ago
ETL Tester
Charlotte, NC
Full-time
Onsite
Senior Level, Lead/Staff
$100K/yr - $120K/yr
10+ years expTata Consultancy Services is looking for an ETL Tester with extensive experience in ETL testing. The role involves analyzing data mapping documents, designing test plans, performing data reconciliation, and automating test scripts to ensure data quality and integrity.
Business Information SystemsConsultingInformation TechnologyIT Management
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
Qualification
Required
Minimum 10 years of experience
Primary Skill: ETL testing
Secondary Skills: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica
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)
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
Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality
Preferred
Familiarity with Hadoop or Spark
Domain: Banking knowledge, Payments knowledge preferred
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
10001+ employees
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
2026-01-25
Business Standard India
2026-01-25
Company data provided by crunchbase