ETL Tester Job at Tech3pillars Technologies, Irvine, CA

aGRqQlFmY1k2Y1JabEhkZGFNYWFXWGJuZ0E9PQ==
  • Tech3pillars Technologies
  • Irvine, CA

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.)

Job Tags

Similar Jobs

K.A. Recruiting, Inc.

Clinical Laboratory Supervisor with NYS CLT license Job at K.A. Recruiting, Inc.

CLINCAL LABORATORY SUPERVISOR NEEDED IN WESTERN NEW YORK full time, permanent position extremely competitive pay excellent benefits NYS CLT license required Minimum six years of clinical laboratory experience great location easily commutable from both Buffalo and Rochester...

Crown Equipment Corporation

Sales Representative Job at Crown Equipment Corporation

 ...External Job Duties Sell select products in a geographical territory and/or assigned accounts. May work in a team approach and assist other sales positions with territory management and communication. Participate in corporate and local campaigns. Make sales... 

ATC Northeast NJ

Long-Term Substitute School Nurse Job at ATC Northeast NJ

Job Description: Long-Term Substitute School NurseHiring Organization: ATC Healthcare Services - New JerseyClient: East Orange Board of EducationLocation: New Jersey Position Overview:The Long-Term Substitute School Nurse will serve as the primary healthcare... 

OnWay Transport, LLC

Independent Contractor Courier Job at OnWay Transport, LLC

 ...Job description Independent Contractor Courier Independently contracted Couriers are needed to transport time sensitive life saving Medical supplies. 24/7 availability for deliveries Responsibilities/Requirements: Medical deliveries Being on call... 

Fareway Stores Inc

Warehouse Order Picker (Day, Part Time) Job at Fareway Stores Inc

 ...Job Function: As a Warehouse Order Picker, you will play a pivotal role in the timely and accurate fulfillment of retail store orders...  ...efficiently in the process of order fulfillment Pick cases (up to 50 pounds) from warehouse locations as indicated on an order...