ETL Test Engineer

ETL Test Engineer Location: Philadelphia, USA (Hybrid) (Contract to hire)Exp: 5+ Years

GC/USC only

Education: Bachelor's Degree or equivalent experience required. Travel Expectation: Up to 10% • These are contract to hire positions for 6 months, after 6 months depending on candidate performance client may hire him/her on their direct payroll • Client/ job location: Philadelphia, Hybrid mode (3 days in client office)• Candidates willing to relocate to Phili are also welcome • Only US nationals or GC are required (no visa sponsorship now or in future)

Required Past 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 ● 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