What are the responsibilities and job description for the ETL Test Engineer position at TechnoGen?
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
