Vacancy caducado!
- 5+ years experience writing complex SQL queries
- 5+ years experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing
- QA Testing experience must be in both manual and automated testing environments, with a strong focus in both as manual testing experience is required to create the automated test cases and SQL statements. Automated testing experience should be with IBM Rational Tools.
- Extensive knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data Capture (CDC), and relational and dimensional data modeling techniques.
- 5+ years experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment.
- 5+ years Oracle experience
- 3+ Years experience with Unix
- Advanced knowledge of MS Office suite tools required with a focus on advanced knowledge of Microsoft Excel for the purpose of creating test grids and using formulas to compare test results.
- Ability to convert requirements documents (Business Requirements, Functional and Technical Requirements) into test strategies/plans, test scenarios and test cases, including appropriate SQL scripts to execute testing cases.
- Ability to evaluate the “testability” of requirements and reports to project team member’s changes or additional information needed in requirements
- Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.) and create a comprehensive test plan that supports the business and technological solutions being delivered
- Ability to coordinate test execution across multiple teams
- Defect tracking experience (i.e. ClearQuest or HP Service Center)
- Experience in tuning SQL queries for performance improvements
- Proficiency with the following Informatica tools
- Informatica PowerCenter 10.2
- Informatica PowerExchange 10.2
- 2-3 years strong experience in:
- Hadoop
- RedShift Database
- Tableau
- Writing Test Scripts in:
- Hive/Impala
- PostGres
- 2+ years current experience with the following Rational Tools
- Rational ClearQuest (RCQ)
- 2+ years experience with Cognos (Version 10 or higher)
- General health care knowledge in any of the major subject areas listed below:
- Medical claims
- Memberships
- Pharmacy claims
- Customers
- Knowledge of Toad for Oracle is a plus
- Knowledge of Databricks is a plus
- Specific experience working with the Enterprise Data Warehouse is a plus
- Working knowledge of scheduling tools, such as Tivoli and Stonebranch
- Prior Mainframe experience is a plus
- Tableau experience is a plus