Boston, Massachusetts
Sr.ETL Tester Job Opening in Boston, Massachusetts - ETL Tester with a Healthcare Client in the Boston area. There are 3 openings here. This is a 6 month + position, and interviews will be via phone/Skype. Local & Healthcare highly preferred.
ETL Tester
With general guidance and coaching, participates in developing and executing test scenarios for process, function, system integration and acceptance testing. Develops test cases, scenarios and scripts to ensure applications quality. Designs and develops usability testing scenarios, and administers portions of testing process. Defines criteria for testing, analyzes results of testing sessions and presents results. Utilizes appropriate testing tools and testing processes on projects and assists in building test environments.
Top Skills/Experience:
8+ years? experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing, within a Data Warehousing environment
ETL Testers will need to test the movement back and forth against the Interfaces to the Legacy system.
QA Testing experience must be in a manual testing environment, not an automated testing environment that predominantly utilizes tools, such as SQL Developer, Toad for SQL execution. The bulk of our testing work is performed by manually creating and executing testing cases and SQL. Manual Test cases are stored in Jira using the Zephyr extension.
5+ years? experience writing complex SQL queries
Ability to determine the types of testing that must be conducted (i.e., data validation, regression, etc.), including evaluating the testability of requirements, and create a comprehensive test plan that supports the business and technological solutions being delivered
Required Skills/Experience:
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
5+ years SQL Server experience
3+ Years? experience with Linux
Ability to convert requirements documents (Business Requirements, Functional and Technical Requirements) into test scenarios and test cases, including appropriate SQL scripts to execute the test cases.
Ability to evaluate the testability of requirements and reports to project team member's changes or additional information needed in requirements
Able to effectively communicate with application SMEs, project teams, and Data Management to ensure that the test case requirement analysis and coverage is appropriate.
Defect tracking experience (i.e. Jira, ClearQuest or HP Service Center)
Experience in tuning SQL queries, Stored Procedures, Views, etc for performance improvements
Proficiency with the following Informatica tools
PowerCenter
Workflow Manager
Workflow Monitor
PowerExchange
Knowledge of data models and entity relationship diagrams
Knowledge and experience in data masking methodologies
Job Type: Contract
Required experience:
Healthcare: 5 years
|
