ETL Test Engineer
Job Description
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
5+years 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