ETL Tester
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.)
Recommended Jobs
Senior Client Relations Manager
Louis Vuitton seeks a Senior Client Relations Manager in Costa Mesa to lead client relations activities and strategies. The role involves developing and executing plans to ensure exceptional service a…
Get rewarded for taking part in surveys
Turn your opinions into cash by participating in surveys. YouGov is trusted by brands and the media to accurately measure opinion. The results of surveys you take will feature in the news, and be us…
Brand Designer
Job Description Job Description Department: Marketing & Communications Reports to: Creative Director Status: 100% Full-Time, Exempt Probation: 180 days Benefits: Medical, Dental, Visi…
Occupational Therapist
Job Description Job Description Position: Travel: Occupational Therapist (OT) - Outpatient M-F, DAYS. $1,000 completion bonus.
Jr Customer Service Representative
Steelgem provides marketing and admission support for Orange County’s best rehab and recovery treatment centers. Join our Customer Experience team and support people’s recovery journey from addiction,…
IVIG Account Executive - Home Infusion Pharmacy
IVIG Account Executive – Infusion Therapy Services Bakersfield / Fresno / Sacramento / SF (Greater NorCal area) $125,000–$175,000 base | $225,000–$250,000+ expected in year one | $400,000–$500,000…
SHIFT SUPERVISOR (FULL TIME)
We are hiring immediately for a full time SHIFT SUPERVISOR position. Location : C3. AI - 1400 Seaport Boulevard, Redwood City, CA 94063. Note: online applications accepted only . Sc…
Chief of Staff
Job Description Job Description About Etched Etched is building Sohu, an AI inference chip that's 10x faster than NVIDIA GPUs . Sohu is hyper-specialized for running transformers: the archit…
Food Server
Title: Food Server Type: 3+ months contract Location: Irvine 92618 Shift: Shifts are based on business needs. Candidate must be available to fill in ALL shifts as needed. Note…
Social Media Channel Operations Specialist
Job Description Job Description Salary: $25 - $30/hr. DOE Social Media Channel Operations Specialist A2O Entertainment is a Global Culture and Technology Enterprise led by Producer Soo Ma…