ETL Data Analyst & Validation Specialist

Tata Consultancy Services; Midvale (UT); On-site; USD 100,000 - 118,000; Full time

Benefits offered by this job

Discretionary Incentive

Medical Coverage

Dental & Vision

Disability Insurance

Pet Insurance

Commuter Benefits

Training Reimbursement

Vacation & Holidays

Legal Assistance

401K Plan

Performance Bonus

College Fund

Student Loan Refinancing

Job summary

Tata Consultancy Services in Utah seeks a Business Data Analyst / ETLTester to validate conversion code and perform data profiling using SQL and Python. You will collaborate with data engineers and analysts to ensure accurate data translations and comprehensive validation results.

The role emphasizes ETL discipline, automation, and strong communication. Prior lending domain knowledge is preferred, with a salary range disclosed in the posting.

Qualifications

• Advanced SQL experience with basic query building for profiling data.
• Automation, regression, and end-to-end testing for ETL.
• Experience with Python and PySpark.
• Basic understanding of database platforms and utilities.
• Familiarity with ETL disciplines and data translation.
• Strong analytical and communication skills.
• Self-motivation and ability to work independently.
• Good organization and time management skills.
• Commercial lending knowledge is preferred.

Responsibilities

• Collaborate with business analysts and data engineers to validate conversion code.
• Document gaps in requirements and remediation options.
• Build SQL queries for data profiling and validation using Python.
• Perform other duties as assigned.

Skills

SQL

ETL Testing

Python

PySpark

Data Profiling

Data Validation

Communication

Self-Motivation

Time Management

Lending Knowledge

Education

Bachelor of Computer Science

Job description

Tata Consultancy Services in Utah seeks a Business Data Analyst / ETLTester to validate conversion code and perform data profiling using SQL and Python. You will collaborate with data engineers and analysts to ensure accurate data translations and comprehensive validation results.

The role emphasizes ETL discipline, automation, and strong communication. Prior lending domain knowledge is preferred, with a salary range disclosed in the posting.