Interviews Started: ETL Tester

19 May 2024

Vacancy expired!

ETL Tester

Location:The position is based in Norfolk, VA JD:

Senior ETL TesterUST is looking for a qualified Senior ETL tester to ensure quality delivery of end to end business solutions and to work with one of the leading healthcare providers in US. The ideal candidate must possess excellent background on ETL testing with respect to extracting, transforming and loading data into the warehouse. The candidate must possess excellent written and verbal communication skills with the ability and collaborate effectively with domain and technical experts in the team.

ETL tester Responsibilities:As a Senior ETL tester, you will be 1. Proving BRD assessment / evaluation / feedback (if applicable)2. Understanding of High level solution / design (big picture, design for future)3. Performing Analysis of the requirements and do root cause analysis if issues are identified4. Working with business stakeholders, Business Systems Analysts and Developers to ensure quality delivery of software.5. Following quality management best practices and processes to bring consistency and completeness to integration service testing6. Designing, developing and implementing comprehensive QA test plans and test cases, tools and infrastructure for assigned areas7. Designing, developing, automating, monitoring and maintaining data quality assurance processes that transfer data to and from internal and external locations.8. Executing test scenarios in Datawarehouse centric application, Providing Backend testing using SQL9. Executing Front end testing and writing simple Unix scripting commands10. Providing assistance to the team in Test Estimation & Test Planning11. Analyzing and evaluating data sources, data volume, and business rules.12. Validating in PLT / PROD13. Attending all the project meetings14. Getting involved in the intake of the requirements to ensure that the requirements are feasible given the company’s technology stack15. Finding Gaps are highlighted and filled if possible16. Troubleshooting issues when they arise. In situations where old Defects ts are being analyzed17. Working collaboratively with Business, Development and system analyst team in shift left mode

Requirements:Minimum of 8-10 years of hands-on experience with the following:1. Involved in testing in the following areas:a. Data Warehousing and ETLb. Data Martsc. Data Profiling2. Understanding Dimensional Databases and Data Marts (includes physical and logical models)3. Writing complex SQL and stored procedures (DB2 preferred); translating specifications and rules into SQL4. Interpreting and writing source to target mappings (ETL transformation rules)5. SME knowledge on project healthcare and Datawarehouse6. Maintaining and interpreting data lineages7. Ability to speak to the various aspect of the SDLC8. working knowledge in SAFe agile9. Ability to provide time estimations for Test activities for a project based on the design10. Ability to work closely with Development, Business, system analyst and UAT teams to provide them the required support11. Ability to perform and provide a detailed impact analysis for a given a defect and provide estimates12. Able to lead testers and possibly provide feedback on multiple projects13. Working knowledge in Unix scripting basicsRequired Soft Skills:a. Good analytical and problem-solving skillsb. Exceptional communication skills (written and verbal)c. Good documentation skillsd. Proficiency in English language (as a medium of communication)e. Frank and open communication with peers and higher-ups about realistic estimations and meeting timelines/expectations and proactive communication of issues and concerns thereoff. Assertiveness in communicating ideas, estimates, scope and timelines

Nice to have:a. Experience with working on Automationb. Experience working with PHI & PII and sensitive datac. Knowledge about ETL tools (preferably Ab Initio)d. Knowledge about other Ab Initio tools like Query>IT, MDH, BRE etc.e. Knowledge about business intelligence / analytics / tool experience – Cognos/Tableauf. Knowledge about medical and Rx claims processing, healthcare enrollments and providersg. Knowledge and understanding of security standards

Qualification:Preferred: Master’s Degree in Computer Science or similar technologiesMust Have: Bachelor’s Degree in Computer Science or similar technologiesThanksMounikaMounika AT ksourceinc.com

  • ID: #41153315
  • State: Virginia Hampton roads 23501 Hampton roads USA
  • City: Hampton roads
  • Salary: Depends on Experience
  • Job type: Permanent
  • Showed: 2022-05-19
  • Deadline: 2022-07-01
  • Category: Et cetera