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