Photon Logo

Photon

QA Engineer(Automation & ETL) - Dallas, TX

Posted 2 Days Ago
Be an Early Applicant
In-Office or Remote
Hiring Remotely in United States
38K-133K Annually
Expert/Leader
In-Office or Remote
Hiring Remotely in United States
38K-133K Annually
Expert/Leader
Design, develop, and execute automated test strategies for data pipelines, ETL processes, and data warehouses. Create and maintain automation frameworks and CI/CD-integrated test suites, perform data validation and reconciliation using complex SQL and PySpark, identify and track defects, and collaborate with development and data teams to improve data quality and system reliability.
The summary above was generated by AI

Job Summary: We are seeking a highly motivated and skilled Quality Engineer (QE) with a strong focus on test automation and extensive experience in ETL (Extract, Transform, Load) testing. The ideal candidate will play a critical role in ensuring the quality, reliability, and performance of our data pipelines, data warehouses, and applications. You will be responsible for designing, developing, and executing automated test strategies for complex data-driven systems, working closely with development, product, and data teams.

Responsibilities:

Test Strategy & Planning:

  • Develop comprehensive test plans and strategies for data pipelines, data warehouses, and business intelligence solutions, with a strong emphasis on automation.
  • Participate in requirements analysis and design reviews to ensure testability and quality attributes are considered early in the development lifecycle.
  • Define and implement test data management strategies for various testing phases (unit, integration, system, regression, performance).

Automation Development & Execution:

  • Design, develop, and maintain robust automated test scripts and frameworks using industry-standard tools and programming languages (e.g., Python, Java, SQL, PySpark, Selenium, Playwright).
  • Implement and maintain CI/CD pipelines for automated testing, integrating tests into the development workflow.
  • Execute automated test suites, analyze results, and report defects accurately and in a timely manner.
  • Contribute to the continuous improvement of our automation framework and testing processes.

ETL Testing Expertise:

  • Design and execute tests to validate data extraction, transformation, and loading processes, ensuring data accuracy, completeness, and consistency.
  • Perform data reconciliation and validation between source and target systems, identifying data discrepancies and integrity issues.
  • Develop and execute complex SQL queries for data validation, profiling, and comparison.
  • Understand data models, schemas, and data flow to effectively test ETL processes.

Quality Assurance & Collaboration:

  • Collaborate closely with software developers, data engineers, product managers, and business analysts to understand system functionalities and data requirements.
  • Identify, document, and track software defects and work with development teams to ensure timely resolution.
  • Proactively identify potential risks and issues related to data quality and system performance.
  • Participate in root cause analysis of production issues and contribute to preventive measures.
  • Promote a culture of quality throughout the development lifecycle.

Qualifications:

Education: Bachelor's degree in Computer Science, Engineering, or a related field.

Experience: 9+years of experience in Quality Engineering, with a strong focus on test automation.

Technical Skills (Must-Have):

  • Proven experience in designing and implementing test automation frameworks and scripts.
  • Proficiency in at least one programming language (e.g., Python, Java).
  • Extensive experience with SQL for data validation, complex queries, and database testing.
  • Solid understanding of ETL concepts, data warehousing principles, and data modeling.
  • Experience with ETL testing tools and methodologies.
  • Familiarity with version control systems (e.g., Git).
  • Experience with test management tools (e.g., Jira, Azure DevOps, TestRail).

Compensation, Benefits and Duration

Minimum Compensation: USD 38,000
Maximum Compensation: USD 133,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is not available for independent contractors
No applications will be considered if received more than 120 days after the date of this post

Photon Chicago, Illinois, USA Office

11 East Adams Street Suite 1100, Chicago, IL, United States, 60603

Similar Jobs

2 Hours Ago
Remote or Hybrid
176K-308K Annually
Senior level
176K-308K Annually
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead AI FinOps governance to track and optimize AI spend across multi-cloud providers. Build KPI frameworks, anomaly detection, guardrails, and cost-reduction programs. Coordinate engineering, finance, and cloud vendors, deliver VP-level reporting, and operate as an independent program owner driving measurable savings and contractual correctness.
Top Skills: AnthropicAWSAws BedrockAws BudgetsAzureAzure Cost ManagementAzure OpenaiBilling ApisGCPGcp Billing ControlsGcp Vertex AiGenai GatewayLlm Proxy PlatformsOpenaiPythonSQLToken Metering
2 Hours Ago
Remote or Hybrid
114K-178K Annually
Senior level
114K-178K Annually
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Lead federal customer relationships to drive product value, adoption, and growth. Onboard and advise executive sponsors, translate business needs into product solutions, iterate onboarding strategy, gather customer feedback, and collaborate cross-functionally to meet transformational goals.
2 Hours Ago
Remote or Hybrid
81K-124K Annually
Senior level
81K-124K Annually
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Provide day-to-day technical support for an AI Assistant platform built on ServiceNow: troubleshoot AI responses, agentic workflows, and API integrations; analyze logs/telemetry (Kibana, Grafana); reproduce and document bugs; perform configuration changes; triage and escalate issues; maintain SLAs and contribute to knowledge bases.
Top Skills: GitGoogle WorkspaceGrafanaJSONKibanaMicrosoft Active DirectoryOktaPythonRest ApisServicenowWorkdayXMLYaml

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account