Sr. ETL Tester(Manager Level)

Cloud Hybrid Technologies LLC; Las Vegas (NV); On-site; USD 90,000 - 140,000; Full time

Job summary

Cloud Hybrid Technologies LLC in Las Vegas seeks a data automation engineer focused on test automation for ETL, data quality, and reporting. You will design and execute test plans, build scripts in Python, work with Airflow, SQL, and BI tools, and participate in Agile/Scrum ceremonies.

This role demands hands-on data warehousing, streaming data experience, and collaboration with engineers and business ops to deliver reliable insights.

Qualifications

• Solid understanding of test automation architecture and frameworks.
• Hands-on experience with ETL testing and data validation.
• Strong SQL skills for source-to-target DB validation.
• Experience with BI reporting tools like Tableau/PowerBI.
• Experience with Agile/Scrum environments.
• Experience with CI/CD pipelines.

Responsibilities

• Create and execute test plans and test cases for ETL components.
• Develop automation scripts and runtime automation.
• Conduct UAT and coordinate with data warehousing team.
• Review requirements and produce test strategies for data pipelines.
• Collaborate with data engineers and BI teams to ensure data quality.
• Validate data through UI and backend checks.

Skills

Test Automation

ETL Testing

SQL Proficiency

Data Warehousing

Python

Airflow

CI/CD

Jira

UAT

Big Data

Tools

Apache Airflow

Informatica

Talend

Tableau

PowerBI

HP ALM

Jenkins

GitLab

Maven

SQL Server

Job description

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

Love to 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

Possesses heavy experience with automation testing for ETL

Highly detailed oriented

Strong willingness & 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 language 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

Experienced in traditional SQL DB (MySQL, Postgres, SQL server) and cloud-native data warehouses Snowflake or Redshift

Experienced in ETL tools Informatica, ab initio, Talend, and reporting tools - Tableau and PowerBI

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

CI/CD implementation through Jenkins/GitLab/Maven

Experienced with HP ALM, Jira, rally any 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

Experienced in using frontend (UI) to generate test scenarios and validate data in the backend

Cloud Hybrid 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. Cloud Hybrid 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 Cloud Hybrid 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