ETL Tester Job at Tata Consultancy Services Limited, Charlotte, NC

OHNVVy9qbW1LaGY3dGIweXBkSDljU3NV
  • Tata Consultancy Services Limited
  • Charlotte, NC

Job Description

Job Title ETL Tester Location Charlotte, NC Experience 6 - 10 years of experience 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 such as JIRA, HP ALM, or Octane. Automate test scripts and validate data volume, performance, and scalability. Validate HiveQL, HDFS file structures, and data processing within the Hadoop cluster. Exhibit strong analytical and troubleshooting skills. Communicate effectively with developers and stakeholders. Work with metadata‑dependent ETL processes and batch/job frameworks. Qualifications Minimum 10 years of experience with ETL testing. Proficient in SQL and SQL scripts for data analysis. Experience with Informatica and IDMC, Autosys, Shell scripting. Understanding of data warehouse concepts and architectures (star/snowflake schema). Familiarity with Hadoop or Spark preferred. Knowledge of metadata‑dependent ETL processes and batch/job frameworks. Domain knowledge in banking and payments preferred. Concepts: Data Warehousing, Data Transformation, ETL/ELT, Data Quality. Tools: SQL, Oracle, PL/SQL. Skills ETL testing, Autosys, SQL, Shell Scripting, Informatica, IDMC. #J-18808-Ljbffr Tata Consultancy Services Limited

Job Tags

Similar Jobs

The Root Restaurant & Bar

Hourly Managers Job at The Root Restaurant & Bar

 ...The Burger King Hourly Manager directs team, ensures excellent customer service and operations execution during assigned shifts. The Hourly Manager helps manage cash and inventory controls. The Hourly Manager is responsible for restaurant operations during assigned shifts... 

Intellibright

WordPress Developer (Elementor Expert) Job at Intellibright

 ...Job Description Job Description WordPress Developer (Elementor Expert) Contract-to-Hire (6 Months) Location : Austin, TX (Hybrid In-Office M/W/F, Remote Tues/Thurs) Reports To : Director of Design & Development Team : Web Development / Delivery... 

Shoppers World

Maintenance Job at Shoppers World

 ...rooms and prepare for pickup Periodically inspect the building roof and yards for any clogged drains, debris, etc Snow preparation and removal in the winter season Report required repairs to property managers Must be able to interact professionally with staff... 

Doggie Style Pets

Store Manager Job at Doggie Style Pets

 ...Job Description Job Description Doggie Style Pets is hiring a Store Manager for our Philly locations. They ensure operational excellence, maintain store standards, and support and manage store staff. All employees at Doggie Style Pets are expected to provide excellent... 

Children's Wisconsin

Community Health Asthma Management Program Coordinator Job at Children's Wisconsin

 ...primary care, specialty care, urgent care, emergency care, community health services, foster...  ...collection and analysis. The Asthma Management Program Coordinator provides a...  ...with in order to meet the recommended entry level for a professional nurse, BSN is preferred...