ETL Tester Job at Tata Consultancy Services, Charlotte, NC

  • Tata Consultancy Services
  • Charlotte, NC

Job Description

ETL Testing EngineerPrimary Skill: ETL testing Secondary: ETL Testing, Autosys, SQL, Shell Scripting, Exposure to IDMC/Informatica Experience: Minimum 10 yearsRoles & 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 frameworkTools & Skills: IDMC, Informatica Power center, Hive, Kafka Knowledge SQL, Oracle, PL/SQLDomain: Banking knowledge, Payments knowledge preferred. Concept: Data Warehousing, Data Transformation, ETL/ELT, Data Quality.Salary Range- $100,000-$120,000 a year Location Charlotte, NC

Job Tags

Similar Jobs

Marathon Staffing

Assembler/Packer — 12-Hour Shifts, Weekly Pay, Benefits Job at Marathon Staffing

 ...general labor roles in Townsend, MA. Training is provided on the job, no prior experience required, and shifts are 12 hours with a rotating schedule.Weekly pay, direct deposit or pay card, and benefits start on day one. You will package products, prepare items for... 

Concentric Healthcare Staffing

Travel Nurse RN - Oncology in Reno, NV Job at Concentric Healthcare Staffing

 ...Registered Nurse (RN) | Oncology Location: Reno, NV Agency: Concentric Healthcare Staffing Pay: Competitive weekly pay...  ...February 20, 2026). Preferred Experience / Skills Experience with remote telemetry monitoring in an oncology or medical-surgical setting.... 

Eastridge Workforce Solutions

Sr Medical Affairs Specialist Job at Eastridge Workforce Solutions

 ...Sr. Medical Affairs Specialist Job Snapshot Location: Acton, MA | Hybrid (3 days/week onsite) Pay: $93.52 - $93.52/hour Employment Type: Contract Work Type: Full-time Experience Level: Mid Level Duration: 6 months, with likely extension... 

Couvillier Advisors

Medicare Sales Agent Job at Couvillier Advisors

 ...They Deserve Without the Cold Calling Are you an experienced Medicare sales professional who loves helping people? At Couvillier Advisors,...  ...on what you do best: serving clients. As a Medicare Sales Agent , youll meet with Medicare beneficiaries, assess their needs... 

Abbott

Associate Creative Director Job at Abbott

 ...LaboratoriesLocation: United States - California - AlamedaJob Type: Full timeCategory: MarketingIndustry: HealthcarePosted Date: 2026-08-...  ...for a Head of Copy who can match that ambition with world-class creative work. This is a leadership role for a creative who has built...