Hi, Hope you are doing well..!
Please go through below job requirement and revert me back with contact details and updated resume of your consultants. *Title: ETL QA Tester* *Location: Boston, MA* *Duration: 12 + month contract* *USC and GC only * *Initial phone followed by Skype/WebEX Interview* 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 Three Skills/Experience:* 5+ years’ experience in Quality Assurance testing with a focus in ETL (Extract, Transform, Load) Testing, within a Data Warehousing environment 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 Familiar with Meta Data Management tools *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 business reporting tools e.g. Cognos Prior experience with Healthcare domain (Claims, Enrollment, Billing) preferred: Knowledge of following tools/applications are a plus: Toad for Oracle SQL Developer SQL Server Enterprise Manager Jira with Zephyr extension Knowledge of IBM’s UDMH Data Models (preferred but not required) Automation experience knowledge in Selenium / QTP *EDUCATIONAL REQUIREMENTS* Bachelor’s Degree in related field required. Master's Degree in related field preferred -- Thanks & Regards….. *Deepak Bandari* dee...@osairtech.com <deepakosairt...@gmail.com> 703-349-2764 IT Recruiter Osair Technologies LLC -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to firstname.lastname@example.org. Visit this group at https://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.