Home   Register   Sign In
 
Company Info

ePromptus

Novi
NOVI, MI, United States

Phone: 248-809-1414
Web Site: www.epromptus.com

Company Profile


Senior ETL Test/QA Analyst


col-narrow-left   

Job ID:

257

Location:

NOVI, MI, United States 

Category:

Information-Technology
col-narrow-right   

Job Views:

186

Zip Code:

48375

Employment Type:

Contract - W2

Posted:

05.06.2014
col-wide   

Job Description:

General Description:
Responsible for corroboratory and collateral whether or not merchandise or services meet mere requirements; concerned all told phases of the QA method. They implement quality assurance objectives and processes, monitor and value testing results against the preset objectives, and apply counseled actions for enhancements. internal control activities could embody purposeful and non-functional testing like regression, system, integration, security and performance testing.

QA professionals are responsible for defining the test environment used by the organization. They interact with all members of the project team including architects, business analysts, systems analysts and project managers. They also work with the development team to successfully integrate testing into each development phase. Other responsibilities include developing and executing formal test plans, writing and executing test cases/scripts, and validating results. They define and track quality assurance metrics such as defects, defect counts, test results and test status. QA professionals communicate testing results and provide recommendations based on issues discovered. They also monitor, evaluate and make recommendations on QA tasks within enterprise-wide processes such as change and release management.

Work Complexity:
- Works on multiple test programs/systems as a team member or testing lead.
- Considered a subject matter expert for one or more programs/systems.
- Works on projects of high complexity within one or more development environments.

Job Requirements:

Required Skills:

-  Five years experience in QA with a focus in ETL (Extract, Transform, Load) Testing
- Quality Assurance Testing experience must be in a manual testing environment, not an automated testing environment that predominantly utilizes testing tools, such as Quality Center or Rational Tools.  The bulk of our testing work is performed by manually creating and executing testing cases and SQL.
- 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:
- Five plus years experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing
- QA Testing experience must be in a manual testing environment, not an automated testing environment that predominantly utilizes testing tools, such as Quality Center or Rational Tools.  The bulk of our testing work is performed by manually creating and executing testing cases and SQL.
-  Extensive knowledge of data warehousing concepts, such as slowly changing dimensions (SCD), Change Data Capture (CDC), and relational and dimensional data modeling techniques
- Five plus years experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an information technology operating environment
- Required Five years experience writing complex SQL queries 
- Required Five years Oracle experience
-Required Three Years experience with Unix
- Advanced knowledge of Microsoft Excel
- 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 members 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
- Workflow Manager
- Mapplet Designer
- Workflow Monitor
- Source Analyzer 
- Informatica PowerExchange

Soft Skills Required:
- Must have the ability to multi-task and adapt quickly to changes while maintaining urgency in completing assigned tasks.
- Must have the ability to work independently with minimal supervision
- Excellent analytical, organizational, verbal, and written communication skills
- Will be responsible for explaining and validating test results to peers as well as clients
- Must be able to question the work of others to ensure accuracy and be able to defend theories and methodologies used to create individual results
- Extensive creativity is required

Preferred Skills/Experience:
- 2+ years experience with Cognos (Version 8 or higher)
- General business knowledge of any of the major subject areas listed below:
- Medical claims
- Memberships
- Pharmacy claims
- Customers
- Knowledge of following tools/applications are a plus:
- Toad for Oracle
- Toad for Data Analysts
- MS Office Suite
- Specific experience working with the client Enterprise Data Warehouse is a plus
- Working knowledge of scheduling tools (examples below)
- Tivoli
- AutoSys
- Working knowledge of Rational Tools (examples below)
- Clear Quest
- Functional Tester
- Quality Manager
- Requisite Pro
- Test Manager
- Prior Mainframe experience is a plus

Educational Requirements:
Bachelor’s Degree in related field preferred



© 2017 Powered by Rootjobs     About Us   Sitemap   Terms and Conditions   Privacy Policy   Mobile Version     Twitter RSS LinkedIn Facebook