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

Yk5KamJZM0M1U3FIenVxaEVoQStKTHdsL2c9PQ==
  • 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

Erie Insurance Group

Investment Intern Job at Erie Insurance Group

 ...Division Or Field Office Investment Division Department of Position: Investments Work From Corporate Office in Erie, PA Hourly Rate $19.18/hour Please Note: We are only considering US workers for this position. We are unable to offer this position... 

HeliCentre Helicopters

Helicopter Flight Instructor & Commercial Pilot at HeliCentre Helicopters Job at HeliCentre Helicopters

 ...European Heli Center is seeking an experienced helicopter flight instructor to join our team at our Lelystad base in the Netherlands. Our operation consists of approximately 65% ATO activities and 35% AOC/SPO operations. During the spring and summer season, we provide... 

Tennessee Hospital Association

Assistant Vice President of Data Analysis Job at Tennessee Hospital Association

 ...of experience in complex data querying and analysis. 2. Hands-on experience with data visualization and reporting tools such as Power BI, Tableau, SSRS, R, or Python. 3. Strong knowledge of UB-04 claims data, including ICD-10, DRGs, HCPCS, and CPT coding standards.... 

Kelly Services

Executive Recruiter Job at Kelly Services

 ...Description At Kelly, were passionate about helping you find a job that works for you. How about this one? Were seeking an Executive Recruiter to work at a leading healthcare organization in Nashville, Tennessee . With us, its all about finding the job thats just... 

LPS, Inc.

Oilfield Security; FT $14hr In/around Murrysville, PA Job at LPS, Inc.

Job Details Job Location IRWIN, PA - Irwin, PA Description "Why work for the rest when you can work for the BEST" Join the LPS Services Team: A Leader in Security and Traffic Control for the Oil and Gas Industry LPS Services is a trusted provider of exceptional...