ETL Tester Job at Tech3pillars Technologies, Irvine, CA

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

Custom Protective Services

Overnight Corporate Security Guard Job at Custom Protective Services

 ...Seeking professional Security Officer with commercial building experience to staff one of our Midtown Manhattan locations. CORPORATE...  ...communication skills We are currently ONLY hiring for weekend overnight shifts. Do not apply if you are not available for these hours.... 

Johnstone Supply

Customer Support Rep Job at Johnstone Supply

 ...to join Johnstone Supply. The Customer Service Representative is responsible for delivering...  ...payments in accordance with SOPs. Answer incoming customer telephone calls and provide...  ...prioritizes safety, both at work and at home, while ensuring those who work for you... 

Black Fodder Coffee Co.

Experienced and Passionate Barista - Specialty Coffee Shop in River Forest Job at Black Fodder Coffee Co.

 ...About us At Black Fodder Coffee, we believe coffee truly makes everything better but only the good kind. Picked at its ripest, patiently processed, roasted fresh in small batches to highlight its natural tasting notes, and skillfully brewed with deep appreciation... 

Insight Global

Data Entry Specialist Job at Insight Global

 ...Rights" Poster is available here ( .To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: .Skills and RequirementsQualifications:High school diploma or equivalent; additional... 

Echelon Solar Power

Solar Sales Consultant Job at Echelon Solar Power

 ...Solar Sales Consultant Position: As a Solar Sales Consultant Representative for Echelon Solar Power, you are on the frontlines of lead generation and client acquisition helping homeowners get rid of their expensive dirty power bill, and transitioning them to clean,...