ETL Test Engineer

ETL Test Engineer

Location: Philadelphia, USA (Hybrid) (Contract to hire)

Job Description:

About Us:

Client is a Google Cloud Premier Partner serving over 1,400 customers, including several of the world's largest corporations, enabling them to leverage Google Cloud Platform across industries and use cases effectively. Client specializes in Google Cloud Solutions such as Workload Migrations, Data & Analytics, Data infrastructure and Visualization, Infrastructure Services, Collaboration & Productivity, and Location-based Services. Client is a 12-time 'Google Partner of the Year' award winner and a Google Cloud Managed Services Partner. We are a global Leader in the Data Warehouse Migration and Modernization to the Cloud, we empower businesses by migrating their Data/Workload/ETL/Analytics to the Cloud by leveraging Automation.

We have our own products!

Eagle – Data warehouse Assessment & Migration Planning Product

Raven – Automated Workload Conversion Product

Pelican - Automated Data Validation Product, which helps automate and accelerate data

migration to the cloud.

Summary:

This role is particularly in "Health Care, Insurance Business Domain" The test engineers at Client are encouraged to share their point-of-views on better implementation based on their experience. You will be working on Cloud Data projects in the Data Warehousing, Data Analytics domain.

Required Past Experience:

5+ years of experience with a proven experience in ETL testing

Handson experience in SQL with advanced level skills

Experience in scripting language (shell/python)

Knowledge and understanding in Data Warehouse and data modeling

Experience in healthcare insurance domain would be nice to have

Experience using Data Warehousing and Business Intelligence tools such as Data stage /

Informatica, GCP Big query, Tableau and SSRS, etc.

Willingness to continuously learn & share learnings with others and capability to collaborate

with stakeholders and project leaders to understand requirements, deliverables

Experience working in an agile and collaborative team environment

Excellent written and verbal communication, presentation and professional speaking skills

Proven problem-solving skills and attention to detail with a commitment to excellence and

high Standards

Required Skills and Abilities:

Mandatory Skills - Data Warehouse ETL/ELT Testing, SQL, UNIX Shell Scripting

Understanding of the project functional and Nonfunctional requirements and Hands-on

experience in QA ETL Testing. Test Plan, Test Cases development

Test Data Driven solutions by defining test cases and test strategy and provide support for

application codes and solutions

Creating Test Scripts, execution of test case and defects status reporting

Execute ETL/ELT jobs or scripts using enterprise schedulers / Cloud Schedulers across

various environments for testing the functionality

Hands on experience in writing SQL queries and unix scripts

Log defects and triage the defects to ensure logical closure of the defects

Work extensively within the Cloud ecosystem ( Data platforms like GCP Big Query)

Strong testing experience in Data warehousing

Education: Bachelor's Degree or equivalent experience required.

Travel Expectation: Up to 10%