At a glance
Location: US-IL-Naperville
Posted: 11/30/2019
Closing: 12/29/2019
Degree: Not Specified
Employment Type: Full-Time
Experience: Not Specified
ETL Data Warehouse Tester
Job description
JOB SUMMARY: The incumbent will look to utilize expertise and knowledge through the execution of regular software quality assurance (SQA) test activities that assure organizational products operate correctly and defined requirements are maintained.
1. Analyze business requirements and technical specifications for organizationally utilized applications. Build and maintain the corresponding test strategy, test plans, and test cases for Multiplan's SQA team
2. Execute SQA testing of applications in accordance with project documentation and aligned with company standards
3. Perform back-end (database) testing using complex SQL queries on Oracle and SQL Server databases. Complete regression and integration testing as necessary.
4. Analyze test results and logs defects in JIRA. Partner with project team members on the resolution and re-testing of identified defects and issues
5. Draft, analyze and maintain reports of defects, test results, etc., through JIRA. Provide constructive feedback and process improvement recommendations to the project team as needed.
6. Collaborate, coordinate, and communicate across disciplines and departments.
7. Ensure compliance with HIPAA regulations and requirements.
8. Demonstrate commitment to the Company's core values.
9. Please note due to the exposure of PHI sensitive data -- this role is considered to be a High Risk Role.
10. The position responsibilities outlined above are in no way to be construed as all encompassing. Other duties, responsibilities, and qualifications may be required and/or assigned as necessary.
JOB SCOPE: The incumbent works with appreciable latitude and relies on judgment and experience to complete job responsibilities. Work is varied and complex. The incumbent strives to continuously improve service delivery according to industry standard quality management guidelines and principles and analyzes products based on company guidelines. Serves as a mentor to less experienced team members.
Job requirements
JOB REQUIREMENTS (Education, Experience, and Training):
* Minimum high school diploma and 5 years' of IT experienced preferably within the scope of Jr. ETL or Jr. PL/SQL developer or Jr. Oracle DBA or similar roles; 3 years' should be inclusive of data warehouse testing experience.
* Required licensures, professional certifications, and/or Board certifications as applicable
* Advanced knowledge of Software QA automated test tools
* Knowledge of load testing
* Knowledge of medical terminology
* Knowledge of health care industry a plus
* Knowledge of project management and execution of multiple projects
* Knowledge of health care EDI formats and processes a plus
* Knowledge of the Test Data Management/ETL tools like Informatica, Pervasive etc.
* Exposure to Enterprise Data Architectures like EDW and ODS
* Experience working with complex Logical and Physical Models
* Strong SQL and PL/SQL skills
* Strong Data warehouse end to end and data completeness testing experience.
* Experience in complex ETL mappings, mapplets and complex transformations testing.
* Experience in development of ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
* Exposure to end-to-end data validation for ETL and BI systems
* Exposure to DB tools like Toad/PL SQL developer/SQL Plus/Sql server management studio
* Experience in Business Intelligence testing in various reports using Cognos, Business Objects, Crystal Reports and Crystal Dashboards
* Communication (verbal, written and listening), planning, organizing, analytical, project management, problem-solving and decision-making skills
* Ability to analyze data and arrive at a logical conclusion
* Ability to effectively present information and respond to questions from groups of managers, clients and customers
* Ability to evaluate production situations and current information to determine the appropriate course of action and execute decisions
* Ability to operate in a dynamic change environment
* Ability to use software, hardware and peripherals related to job responsibilities, including MS Office and Project
* Ability to write and understand complex SQL against Oracle and Sql server databases.
* Individual in this position must be able to work in a standard office environment which requires sitting and viewing monitor(s) for extended periods of time, operating standard office equipment such as, but not limited to, a keyboard, copier and telephone
As an Equal Opportunity Employer, the Company will provide equal consideration to all employees and job candidates without regard to sex, age, race, marital status, sexual orientation, religion, national origin, citizenship status, physical or mental disability, political affiliation, service in the Armed Forces of the United States, or any other characteristic protected by federal, state, or local law.