Sr. ETL Tester Job at Cloud Analytics Technologies LLC, Las Vegas, NV

SVZlMFpGRnJJcGZhYW91MnpuWE8xbXpiZUE9PQ==
  • Cloud Analytics Technologies LLC
  • Las Vegas, NV

Job Description

Job Details

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

Job Tags

Similar Jobs

Wyndham Destinations

Inbound Sales Agent Remote Job at Wyndham Destinations

Inbound Sales Agent Remote Location Remote in Orlando, FL : We Put the World on Vacation At Travel + Leisure Co., our mission is simple...  ...of 4:00pm to 11:00pm on weekdays and 1:00pm to 8:00pm on weekends after they have completed their initial training. *** How You... 

Ozinga Bros, Inc.

Equipment Operator Job at Ozinga Bros, Inc.

Overview: Pay Rate : $21-$23 Per Hour Summary: The Equipment Operator/Stevedore will be responsible for operating heavy machinery and stevedoring activities in and around the port facility to keep the operation moving materials in a safe and efficient manner.... 

Little Caesars

Crew Member Job at Little Caesars

 ...squatting, and standing for long periods of time on any given day. Essential job duties are dened as the fundamental activities...  ...one of the nations leading pizza chains. Flexible hours. Same day pay availablewith Tapcheck The ability to have fun while making... 

Prometheus Advertising Inc.

LPN: Earn Up to $12,335 PER MONTH + Weekly Pay! Job at Prometheus Advertising Inc.

LPN: Earn Up to $12,335 PER MONTH + Weekly Pay!Location: Fordham, NY 10458 | Pay Frequency: WeeklyYour Chance for a Major Career & Income Boost!Licensed Practical Nursesready to take your career to the next level and earn incredible pay? Join our premier Bronx... 

Baylor College of Medicine

Medical Assistant II Job at Baylor College of Medicine

 ...College of Medicine, has an immediate opening for an experienced Medical Assistant II. The ideal candidate will have two or more years of...  ...required, but is desired. The MA II may assist with training entry-level MAs. The Dermatology Clinic at Baylor College of Medicine...