drjobs ETL Tester

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Irvine - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Role: ETL Tester (with Python Expertise)

Location: Irvine CA- Onsite

Experience: 8

Core Responsibilities

  • Thoroughly test ETL processes-extract transform and load-to ensure data accuracy integrity and alignment with business requirements
  • Validate transformations data reconciliation regression checks and detect missing or duplicate records
  • Develop and maintain Python scripts to automate data testing workflows using libraries like pandas NumPy and frameworks such as pytest or unittest
  • Write and execute complex SQL queries for comparing source and target data spot-checking data loads and slicing data for analysis
  • Collaborate with ETL developers data engineers analysts and stakeholders to understand data models mappings and translate them into effective test cases
  • Create test plans test cases and maintain documentation-including test strategies test scripts result logs and defect tracking
  • Automate test suites and integrate into CI/CD pipelines using tools like Jenkins or Git-based workflows
  • Desirable Technical Stack
  • Python (scripting) plus data-handling libraries (e.g. pandas NumPy PySpark)
  • SQL-especially for data validation across various database platforms (Oracle MS SQL Snowflake Hive etc.)
  • Familiarity with ETL tools like Informatica Talend SSIS or cloud platforms like AWS Glue S3 Snowflake or Hadoop ecosystems
  • Experience in scripting frameworks in big data environments using PySpark
  • Cloud experience (AWS Azure) and orchestration tools like Airflow; knowledge of data lakes data warehousing and modeling concepts such as star/snowflake schemas
  • Experience with CI/CD version control (Git) and test management tools (JIRA Jenkins Quality Center etc.)

Employment Type

Full-time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.