*Dear Associate,, Hope the day is treating you well! * *We have the following requirement currently open. Please review the requirement and send me the best matching resume. Please make sure that the Consultant's skills and experience match the requirement before submitting the resume. *
*Job Title: ETL Ab Initio QA Consultant Duration: 12+ year Location: San Mateo, CA* *PLEASE SEND ME THE RESUME ON **shiv.ku...@panzersolutions.com*<shiv.ku...@panzersolutions.com> *Job Description: ETL skills 1. Familiarity with Data Warehousing concepts 2. Familiarity with ETL concepts 3. Experience with testing or developing ETL processes 4. Familiarity with commercial ETL tools, Ab Initio required 5. Experience in data analyses, data validation and/or data quality assurance 6. Experience in validating data mapping, selection criteria, aggregations, sorting, lookups, transformations, data loads. 7. Experience in processing and validating data in flat files as well as in DB tables. 8. Experience with batch processing.* *Ab Initio: 1. Knowledge of Ab Initio, basic understanding of GDE, individual components. 2. Ability to execute the graph from GDE and command line. 3. Ability to manipulate the code and update/create basic test tools. 4. Ability to read and interpret the code and create data requirements based on code changes.* *Test Methodology and General Skills: 1. Strong understanding of the role of testing in development lifecycle 2. Strong ability to analyze technical documentation 3. Ability to develop test assets (e.g. test plans, test designs, test cases, discrepancy reports, etc.) 4. Ability and working knowledge of Rational products (ClearQuest, Test Manager, Robot, etc.) 5. Strong communications skills. UNIX skills 1. Ability to use VI editor, edit files 2. Ability to create, rename, delete, copy files and directories 3. Ability to maneuver around the directory structure, find specific files 4. Ability to set and modify file permissions 5. Ability to write simple regular expressions 6. Ability to use basic UNIX commands like wc, grep, cut, sort, more, cat 7. Ability to modify existing UNIX scripts 8. Basic understanding of redirection* *MVS skills 1. Ability to copy, edit, delete, rename a sequential data set 2. Ability to view data in the data set 3. Ability to navigate within the data set (find specific record, value, etc.) 4. Ability to copy a member from one JCL library to another 5. Basic knowledge of JCL (ability to modify existing JCL so that the job could be run in QA environment) 6. Ability to execute a job from JCL and interpret job output 7. Ability to use FileAid, access and use data set layout* *Database skills (SQL) 1. Ability to find a specific record in the table, display data for specified fields 2. Ability to update a field, a record in the table 3. Ability to delete a record from a table 4. Ability to calculate total number of records in the table 5. Ability to calculate total sum for a specific column in the table 6. Basic understanding of RDBMS 7. Understanding of the data warehousing concepts (e.g. purpose and role of the fact tables versus dimension tables).* *Thanks, Shiv Kumar* -- You received this message because you are subscribed to the Google Groups "Oracle Developers" group. To post to this group, send email to oradev@googlegroups.com. To unsubscribe from this group, send email to oradev+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oradev?hl=en.