ETL Test Engineer

Sr. ETL Test Engineer Philadelphia,PA (Day 1 Hybrid - 3 days in client office Must) Contract/CTH Job description: • Strong hands on ETL/ database testing experience • 5years of experience with a proven experience in ETL testing • Hands on 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 Datastage / Informatica, GCP Bigquery, 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 • 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