The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.
M8y57q5xl50dzv1104k

ETL Data Wareshouse 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.
JOB ROLES AND RESPONSIBILITIES:
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.

Job Snapshot

Location US-IL-Naperville
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type Engineering & Aerospace, IT & Technical
Apply

Company Overview

MultiPlan

At MultiPlan, our employees are instrumental to our success and we reward them accordingly. We offer a very competitive compensation and benefits package, an incentive bonus program, service recognition awards and an employee recognition program that honors individuals whose achievements go above and beyond even our high expectations. We invite you to search our listing of current Career Opportunities. One of our top priorities is the career development of our employees. Learn More

Contact Information

US-IL-Naperville
Snapshot
MultiPlan
Company:
US-IL-Naperville
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
Engineering & Aerospace, IT & Technical
Store Type:

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.
JOB ROLES AND RESPONSIBILITIES:
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.
Mrt3c768phnp0gk12d2
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
ETL Data Wareshouse Tester Apply now