What are the responsibilities and job description for the ETL Tester position at nirvanaHealth?
RxAdvance
, now doing business as
nirvanaHealth
, is committed to bringing the art of possible to the payer and PBM industries, which is why we strive to invest in our employees throughout all stages of life. Success radiates through all levels of employees here, with competitive benefits, a strong focus on employee wellness, and optional education courses offered through UDEMY: we aim to support all aspects of employee growth.
nirvanaHealth
is the first to offer medical and pharmacy benefit management solutions that run on the same platform, made possible by our creation, Aria – the first robotic process automation cloud platform designed for healthcare.
ikaSystems
Ravi Ika,
nirvanaHealth
endeavors to sizably reduce the $900 billion in waste in healthcare administrative and medical costs. We are seeking A-players to join our team – folks who embrace the grind and hustle of a growing company, are collaborative and innovate, are life-long learners and growers, and have an entrepreneurial and positive mindset.
Job Summary :
The ETL Tester will design, test, and troubleshoot data storage systems. They will be responsible for validating data sources, extracting data applications of transformation logic, and uploading data in target tables.
Job Responsibilities (but not limited to):
- Design Test Strategy, Test Plans and Automation for QA of ETL functionalities implemented across variety of custom scripts, jobs, and packaged solutions.
- Identify test cases which must be automated and prepare test automation strategy.
- Perform partial E2E validations of the ETL scenarios with multiple test scenarios and test data.
- Write advanced SQL queries for ETL/data warehousing/Business Intelligence testing.
- Other duties as assigned.
Qualifications:
Education and/or Training:
- Bachelor’s degree in Computer Science or related field required.
Professional Experience:
- 6 years of strong experience in ETL testing
- Experience in Agile projects (Scrum, Kanban etc.)
- Strong SQL experience in Oracle OR NoSQL OR RDBMS OR Big Data
- Data warehouse testing experience involving the testing of stored procedures, slowly changing dimension tables, Change Data capture etc.
Specialized Skills:
- Understand data flow and test strategy for ETL, Data warehouse and Business Intelligence testing
- Ability to go through the User stories and understand the technical aspects required for aspects of ETL/Data process
- Good communication skills
- Good analytical & problem-solving skills
- Working knowledge of fundamental quality assurance concepts and best practices
Strong PC skills; MS Word, Excel, Access, and Power Point
Additional Considerations:
Applicants must be able to pass a background investigation as all offers are pending a successful
completion of background check per the company policy