Hi,
*Please send resume to [email protected]* *D**atawarehouse tester *** *Location: **Des Moines, IA. *** *Duration: **6 month assignment *** *R**ate is $40/hr.* >From a discussion I had with the hiring manager the required skills are as follows. 1) DataWarehouse Testing Experience 2) Strong SQL Skills 3) DataStage 4) Business Objects 5) Understanding of Star and Snowflake Schema at a high level Please review the full requirement below. *Overview:* Provide efficient test support for IT Data Warehouse projects and initiatives, designing and developing test scripts, defining test data, executing test scripts, and reporting defects. Understand business processes and system design to effectively conduct System Testing and Production Verification. *Responsibilities:* 1. Including experience with relational databases (prefer DB2) and broad experience and expertise with ETL processes and tools (prefer Data Stage). Experience in both Snowflake and Star Schema. -1-2 years experience writing complex SQL to incorporate ETL logic and validate test cases. SQL knowledge will need to be demonstrated. -1-2 years experience testing data through Business Objects or other reporting tool. Business Objects is preferred. -Detailed knowledge of Data Warehouse platform and general knowledge of other IT Platforms such as Client/Server, ---Internet/Intranet, Electronic Commerce, Mainframe) -Demonstrated ability to manage business expectations and understand business processes. -Effective communication skills including issue resolution. -Strong time management and organizational skills. -Ability to operate with some specific direction and general direction. -Ability to see a task through to completion independently or as a team member. -Analytical ability and strong problem solving skills. -Demonstrated ability to produce results. *Qualifications:* Analyze requirements, data models and other documents to construct effective test scripts. 1. Ability to test slowly changing dimensions and Fact tables. 2. Design automated scripts for efficient testing of interfaces, data translations, batch outputs, or similar processes. This includes using SQL scripts to validate data movement from source to target as well as performing data integrity and referential integrity in Data Warehouse tables. 3. With direction, specify test cases and design scripts for efficient testing of data extraction, translation and load processes. 4. Interpret test plans to understand priorities, schedules, and expectations 5. Review documented requirements to ensure testability, maintainability, accuracy and consistency. Document test coverage and traceability to requirements. 6. Develop test scripts and define test data for System Testing and Production Verification. 7. Execute test scripts and document test results for IT projects. 8. Identify system defects and retest defect resolutions. 9. Support and adhere to Client IT Software Development Lifecycle (SDLC), operational procedures and development and security standards. 10. Other duties as assigned. *Have a blessed day!*** *Thanks & Regards* *Annie Mark **|*Aim Computer Consulting | 734-591-3562 EXT: 1+180|Fax : 734-418-2603 Mail id: [email protected] Yahoo IM: [email protected] Visit our Website at www.aim-cc.com To unsubscribe from this group, send email to tek-professionals+unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.
