ETL Tester Job at Tech3pillars Technologies, Irvine, CA

VGdBLzViM0RNZDNnelNNVlR4azNjYWc2R3c9PQ==
  • 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

BAS Healthcare

Physician Gastroenterology - Competitive Salary Job at BAS Healthcare

 ..., as the Garden City of the South and home of the globally-recognized Masters Tournament. History meets high-tech, sports meets with southern hospitality, industry meets with a growing technically-savvy workforce, and a love of the outdoors and recreation meets with a... 

Burrtec

Scale House Operator (Cashier) Job at Burrtec

 ...employee is in the organization.We have the following position at our Riverside/Agua Mansa Material Recovery Facility division:Scale House OperatorProvides a variety of customer service duties by interacting, servicing, and consulting with face-to-face customers as well... 

Get It - Real Estate

Real Estate Acquisition Consultant - Remote | WFH Job at Get It - Real Estate

We are looking for a dynamic and results-driven Real Estate Acquisition Consultant to join our growing team! In this fully remote role, you will be responsible for buying and selling homes by following up on leads, valuing properties, estimating repairs, and closing deals... 

Merryhill School

Assistant Preschool Teacher Job at Merryhill School

 ...Bonus ~ Student Tuition Discount About the Role As a teacher in our early childhood education program whether working with...  ...will help provide a foundation for lifelong learning. As an Assistant Preschool Teacher at Merryhill School, you're responsible for creating... 

urgent recruiting

Production Scheduler Job at urgent recruiting

About the job Production Scheduler The Production Scheduler is responsible for all production planning to meet customer supply and demand requirements with a high degree of accuracy. Scheduler will establish, communicate and maintain the manufacturing schedule...