Sr. ETL Tester

Robotics Technologies LLC; Las Vegas (NV); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology solutions provider in Nevada seeks a Test Automation Engineer with expertise in writing and executing test cases, SQL, and automation for ETL processes. The ideal candidate will work closely with data professionals and contribute to the data validation and testing strategies. A solid understanding of automation tools and agile methodologies is essential. This role offers an inclusive work environment valuing diversity and equal opportunity.

Qualifications

• Expertise in writing and executing test cases.
• Ability to manage and analyze large data sets.
• Experience in creating automation scripts.

Responsibilities

• Collaborate with data professionals to understand reporting needs.
• Create and maintain complex SQL queries.
• Execute ETL jobs using orchestration tools.

Skills

Test automation architecture

SQL query creation

Data validation

Automation testing for ETL

Agile methodologies

Data modeling

Tools

Apache Airflow

Informatica

Tableau

Python

Jenkins

Job description

Overview

• Be an expert in writing and executing test cases, managing and analyzing large sets of data, creating automation scripts, and communicating relevant insights to the team.


• Collaborate with other data professionals, engineers, and business operation experts to understand and address reporting needs.


• Experience with both traditional and big data streaming.


• Create and maintain complex SQL queries such as type 2 triggers, various joins, aggregations, groupings, and more.


• Execute ETL jobs using orchestration tools (Airflow, Scheduler, SQL Agent).


• Have a working knowledge and testing experience of ETL.


• Be proactive with leadership abilities with a strong can‑do attitude.


• Possess heavy experience with automation testing for ETL.


• Highly detail oriented.


• Strong willingness and comfort in taking on and challenging development approaches.


• Conduct and facilitate UAT.


• Previously worked in Agile and Scrum.

What You Will Need

• Solid understanding of test automation architecture, framework, and automation script creation using programming languages such as Python, Bash scripts, etc., and orchestration tools like Apache Airflow, Luigi.


• Strong knowledge of creating SQL queries for source-to-target database validation and data warehouse testing.


• Hands-on experience interpreting and understanding data models and ER diagrams.


• Experience with traditional SQL databases (MySQL, Postgres, SQL Server) and cloud-native data warehouses Snowflake or Redshift.


• Experience in ETL tools Informatica, Ab Initio, Talend, and reporting tools such as Tableau and Power BI.


• Create and execute strategies and test cases for applications that use ETL components.


• CI/CD implementation through Jenkins, GitLab, Maven.


• Experience with HP ALM, Jira, Rally or other Agile test management tools.


• Implement the orchestration of business flows on given problem statements for the automation of complex scenarios.


• Review technical requirements with data warehouse and business intelligence terminology to produce test strategies, test scenarios, and test cases for the data warehouse team.


• Create the test plan for the software release, defining resources, and test suites required for each test cycle, dependencies, risks, and the overall strategy for testing complex systems and applications.


• Experience in using frontend (UI) to generate test scenarios and validate data in the backend.

Equal Opportunity

ROBOTICS TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTICS TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTICS TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract