Reply to:Vasu@beyondtekit.com
Client is looking for DataStage8X (ETL) Developer - Round Lake, IL. This is a 2 months Contract position.
DataStage 8.x developer
· Please ensure that candidate has DataStage 8.x experience, and working knowledge of Oracle database (SQL, PL/SQL).
· Ability to read and write effective, modular, dynamic and robust code, establish and follow already established code standards, experience with Change Data Capture, Slowly Changing Dimension Type 2, Surrogate Key Generator, Aggregator, Merge, Sort, Join, Lookup, Transformer, Filter, Shared Container Stages, utilization of Datasets, Parameter files and Parameter sets.
· Excellent troubleshooting & optimization skills: interpreting DataStage log files, SQL / Data validation, dissecting DataStage code at the UNIX OS level, understanding the benefits of parallelism, drawbacks and appropriateness of using the multi-node vs. single node processing; ability to understand and optimize the surrogate key generator behavior, date range and inconsistent data types handling.
· Understanding of DataStage abilities and limitations from a scheduling perspective: DataStage jobs vs. sequences, UNIX Cron and UNIX Shell scripting and ability to select the most optimal scheduling solution; ability to call DataStage jobs from the command line
· Ability to design jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without rewriting jobs.
· Clear understanding of DataStage and ETL best practices within an Oracle environment
· DataStage error handling, error propagation and email notification
Specific Qualifications Required (specialized skills, degrees, certification, etc.)
· 5+ years experience implementing ETL for Data Warehouse and Business intelligence solutions
· Deep familiarity with Oracle database technologies (9i & 10g)
· 3+ years with DataStage server / parallel addition (DataStage 8.x required)
· 5 years experience with scheduling ETL jobs using DataStage Scheduler, UNIX Cron, and external scheduling tool
· UNIX (Korn) Shell scripting and Perl development skills strongly preferred
Other qualifications
· Strong analytical and problem solving skills
· Effective communication skills
· Ability to work independently and as part of a team
Please complete the following skills-matrix and send back with your updated resume.
Full Name:
Degree Major:
Total IT Experience:
Total DataStage ETL Developer exp:
Total DataStage 8.x developer exp:
Total exp of Oracle database (SQL, PL/SQL): please specify
Total exp implementing ETL for Data Warehouse and Business intelligence solutions:
Total exp with Oracle database technologies (9i & 10g):
Total exp with DataStage server / parallel addition (DataStage 8.x required):
Total exp with scheduling ETL jobs using DataStage Scheduler, UNIX Cron, and external scheduling tool: please specify
Total exp in UNIX (Korn) Shell scripting and Perl development:
Hourly Rate:
Day Phone #:
Evening Phone #:
Cell Phone #:
Availability:
Current City/State:
Work Status (US Citizen / Green Card / Others):
Have you applied recently for this requirement earlier through any one else? Y/N:
* If you qualify for this position, are available immediately and are interested, please send your resume, rate and contact information to
mailto:vasu@BeyondTekIT.com?subject=DataStage ETL Developer - Round Lake, IL
* Please ensure you complete and copy/paste the above-completed matrix with your response
Vasu
BeyondTekIT
Tel: 714-857-2002 - Ext -815
Fax: 714-364-9705
vasu@beyondtekit.com
http://www.beyondtekit.com/
--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.To post to this group, send email to sureshotjobs@googlegroups.com.
To unsubscribe from this group, send email to sureshotjobs+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sureshotjobs?hl=.
No comments:
Post a Comment