ETL Tester Job at Tata Consultancy Services, Charlotte, NC

  • Tata Consultancy Services
  • Charlotte, NC

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 #J-18808-Ljbffr Tata Consultancy Services

Job Tags

Similar Jobs

Talentify.io

Flexible Auto Parts Delivery Driver Job at Talentify.io

 ...NAPA is hiring Delivery Drivers to deliver automotive parts across the metropolitan area. Join a Fortune 200 company and become a NAPA Brand Ambassador with competitive pay and benefits, plus flexible schedules.You will safely deliver parts, build customer relationships... 

Burger King

Repair & Maintenance Team Job at Burger King

 ...We are in search of a Full-time Restaurant Hot Side and General Repair team member to help fix and maintain our Atlanta Burger King Locations...  ...employee, if hired you would receive a company vehicle, phone stipend, and a gas card. You would also be eligible for a quarterly... 

Emerging Blue Jobs

Temp Jewelry Designer Job at Emerging Blue Jobs

 ...Job Description Job Description Temporary Technical Designer Jewerly Location: San Francisco (primarily onsite with some flexibility for remote work) Hourly Rate: $40$65/hour Overview We are seeking a Temporary Technical Designer to support product development... 

Wentzville R-IV School District

Assistant Basketball Coach Job at Wentzville R-IV School District

 ...Position Type: X - Extra Duty - Athletics/Activities/Coach Date Posted: 9/29/2026 Location: Timberland High School Location: Timberland High School Schedule: Paid during Dec/Jan/Feb Pay: 9% of the extra duty salary schedule starts at step 1... 

Thin Line Environmental

Local Truck Driver Class A or B Job at Thin Line Environmental

 ...Company parties ~ Competitive salary ~ Employee discounts Job Summary We are seeking an experienced and professional Truck Driver to join our team. In this role, you will transport a variety of goods and materials from one location to another. You will plan...