*>>>NEEDED URGENTLY THIS IS VERY HOT POSITION<<<*

Hi ,
Hope you are doing great !
If you have any Excellent consultants who is available and perfect for this
position please send me their most updated resume along with the contact
details ASAP...

Title         : DataStage w/ MVS
Location  : Kansas City, MO
Duration :  12 months
Rate         :  Open

Skills needed for Mainframe/DataStage programmers are as follows:
Required Skills:
DataStage MVS
Mainframe
MVS
Navigate the z/OS system—both MVS and USS
MVS
USS
SPUFI / SQL

*Role:
*Mentor developers in use of DataStage MVS and to define best practices with
the project architects

*Position Description -*
Generate JCL/COBOL ETL code utilizing DataStage 7.5.2 MVS Edition.
Perform analysis of complex flat files including VSAM, multi format, multi
record.
Create metadata tracking facility compatible with IBM 390 environment.
Use advanced troubleshooting methods to determine metrics for the project
using the Business Rule Stage.
Provide best practices, unit testing standards and project tracking
documents.
Develop DataStage processes that are responsible for processing numerous
record responses.

Tools: DataStage 7.52 MVS Edition, XPlanner, ClearCase 6.x and 7, Spufi for
SQL on 390, DBII Mainframe

Must be able to work with this skills :
1. DataStage MVS:
Ability to use all MVS stages, especially the File Stages, the Transformer
Stage, Link Collectors and Database stages
Use Manager to create, import and export dsx files
Familiarity with the Business Rule Stage
Consistently use descriptive names to name links, stages and jobs
Save and load table definitions
Use link constraints
Define and use variables
Ability to modify the generated COBOL; In particular, writing DISPLAY
statements to debug problems.

2. Mainframe:
Job Control Language:
Write JCL to compile, link and bind COBOL
Write JCL to execute a series of PROCs
Create and use PROCs
Reference PARMs from within PROCs
Understand and use symbolics
Ability to code and use temporary datasets
Ability to use conditional statements to catch Return Codes

3. MVS:
Familiarity with DFSORT, IDCAMS, IEBGENER, BPXBATCH, REXX
Read Spool Display and Prevail to determine success of a job and
troubleshoot problems
Allocate datasets, PDS and libraries
Troubleshoot JCL Errors and ABENDS

4. Navigate the z/OS system—both MVS and USS

5. MVS:
Using 3.4 to find datasets
Browsing, Editing, Selecting or getting Information about a file
Thorough understanding fie allocation including (NEW, CAT, DELETE), but also
PASS, MOD, SHR
Familiarity with VSAM files

6. USS:
Basic USS/UNIX commands such as ls, cp, mv
USS specific commands such as 'tso oget' and 'tso oedit'
Execute a shell script
Write simple shell scripts

7. SPUFI / SQL:
Be able to create SQL from scratch and execute it against DB2
Create from scratch, Select, Insert, Update and Delete statements
Create, from scratch, Inner join, outer join, inner selects
Ability to look up SQL Return Codes and determine the cause of problems
Familiarity with the MVS SPUFI utility

Please feel free to contact me for additional information...

Regards,
Srinivas Rao
Sr. Technical Recruiter
Voice : 201-255-0319 ext 289
Email: [EMAIL PROTECTED]<[EMAIL PROTECTED]/[EMAIL PROTECTED]>

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"DATAWAREHOUSE VENDORS" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/datawarehouse-vendors?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to